[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