On 03/07/12 07:14, James Sewell wrote:
Hello,
When I run pgsql2shp like so:
pgsql2shp -u plm25 -g the_geom database table
I get the following output:
Xcolumn number -1 is out of range 0..1
column number -1 is out of range 0..1
column number -1 is out of range 0..1
column number -1 is out of range 0..1
column number -1 is out of range 0..1
column number -1 is out of range 0..1
column number -1 is out of range 0..1
column number -1 is out of range 0..1
column number -1 is out of range 0..1
column number -1 is out of range 0..1
column number -1 is out of range 0..1
column number -1 is out of range 0..1
This continues in blocks for (I assume) each row in the table.
When I go to load the shape I get null values for all rows as follows:
INSERT INTO "table" (the_geom) VALUES (NULL);
My versions are:
PostgreSQL 9.1.4 on sparc-sun-solaris2.10, compiled by cc: Sun C 5.11
SunOS_sparc 145354-05 2011/09/13, 64-bit
POSTGIS="2.0.1 r9979" GEOS="3.3.5-CAPI-1.7.5" PROJ="Rel. 4.8.0, 6 March 2012" GDAL="GDAL 1.9.1, released
2012/05/15 GDAL_DATA not found" LIBXML="2.7.8" LIBJSON="UNKNOWN" R
ASTER
Any ideas? This is a fresh table, not migrated form an old version.
That's strange - I don't see that error message within the PostGIS
codebase at all, so maybe it is coming from libpq. Do you see that error
with just that one table, or with a shapefile you have loaded using
shp2pgsql?
Any chance of sharing your table schema with us, e.g. the output of \d
<table> in psql?
ATB,
Mark.
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
