[postgis-users] shp2pgsql, pb with append
"Guillaume SUEUR (Géosignal)"
guillaume.sueur at geosignal.fr
Fri Dec 10 01:29:47 PST 2004
Hi,
When I use shp2pgsql with -a option to append the records to an existing
table, the script doesn't include the id fields in the fields list but
it does for the values list. And so the insert is incorrect :
INSERT INTO "geocomm" ("code","nom","dep",the_geom) VALUES
('1','97209','Fort-de-France','972',GeometryFromText('MULTIPOLYGON(((....
See : 4 fields and 5 values !
I'm still using postGIS 0.8, is that fixed in version 0.9 ?
Thanks
--
---------------------------
Guillaume SUEUR
GEOSIGNAL - Groupe BVA
25bis Avenue Marcel Dassault
31505 TOULOUSE CEDEX 5
----------------------------
More information about the postgis-users
mailing list