[postgis-users] postgis - polygon load failed

[Mark Cave-Ayland]

On Wed, 2007-06-20 at 13:20 -0700, Peter Shrock wrote:
> Dear all:
> 
> I have installed Postgresql 8.2.4 (windows 2000 platform).
> 
> I have loaded a few shapefiles from the ESRI sample data using shp2pgsql
> successfully.
> 
> However, I have difficulties to load my working shapefiles. These shapefiles
> have been generalized (vertex have been reduced).
> 
> The pgadmin log is:
> 2007-06-20 14:19:56 ERROR  : server sent data ("D" message) without prior row
> description ("T" message)
> could not receive data from server: No buffer space available
> (0x00002747/10055)
> 
> The layer cannot loaded into Quantum GIS either - invalid layer.
> 
> The shapefiles can be operated properly in ArcGIS/ArcView.
> 
> Does any one know the reason? I assume that it had something to do with
> geometry. Any way to solve this issue?
> 
> You help is much appreciated.
> 
> Peter.


Hi Peter,

A starting point would be to alter your postgresql.conf so that all SQL
commands are logged in the log file, and then try and see on which
statement it is failing. Note that you will have to restart the
PostgreSQL service and reconnect in order for this to take effect.


Kind regards,

Mark.

-- 
ILande - Open Source Consultancy
http://www.ilande.co.uk