[postgis-users] Shp2pgsql problem

[Frank Koormann]

Stefan,

could you please provide some more information regarding your table
structure? 

As a blind shot I could think of 
a) Your first column is a string and something is broken in the lines
   above line 743, the parser complains about.
b) Your first column is an integer, you try to force 32-bit ints by the
   "-i" option, but 512760001147050 is clearly greater than a 32-bit int. 

HTH,

        Frank

* Stefan Hahmann <s.hahmann at mapchart.com> [070418 10:17]:
> I have the following problem while trying to import a shapefile into
> postgis with shp2psql
> 
> I have run this command:
> 
> 
> /usr/local/pgsql/bin/shp2pgsql -s 4326 -i -a -I -D -k theshapefile.shp
> public._g24 > _g24.sql | /usr/local/pgsql/bin/psql -d mapdata -f
> _g24.sql -s
> 
> And got this errormessage:
> 
> psql:_g24.sql:743: ERROR:  syntax error at or near "512760001147050" at
> character 1
> psql:_g24.sql:743: LINE 1: 512760001147050 4110 0 512760200017359 0
> 512760200947163 0 0...
> psql:_g24.sql:743:         ^

-- 
Frank Koormann    |   ++49-541-335 08 35    |   http://www.intevation.net/
Intevation GmbH, Osnabrück, DE | Commercial Register Osnabrück, HR B 18998
Managing Directors: Frank Koormann, Bernhard Reiter, Dr. Jan-Oliver Wagner
PostGIS Support (http://www.intevation.net/geospatial/postgis-support.en.html)