[postgis-users] Shp2pgsql problem 2

[Stefan Hahmann]

Hi frank, david

Thank you for your help with the shapefile import. Switching off the
32-bit option and changing the way the shp2pgsql | psql commands were
invoked did help.

But now another problem occured:

After i have successfully loaded data into my table _g24 using

shp2pgsql -s 4326 -c -I -D -k myshapefile1.shp public._g24 | psql -d
mapdata

I was not able to append data using 

shp2pgsql -s 4326 -c -I -D -k myshapefile2.shp public._g24 | psql -d
mapdata

Although myshapefile1.shp and myshapefile2 do have the same structure.

I got again an errormessage:

ERROR:  syntax error at or near "2760003221743" at character 1
LINE 1: 2760003221743 4110 0 100000000005583 0 522760200562014 0 0 1...

My table structure is:

CREATE TABLE _g24
(
  gid serial NOT NULL,
  "ID" bigint,
  .
  .
  .
}

Maybe somebody can help?

Thanks in advance.