[postgis-users] shp2pgsql, pb with append

["Guillaume SUEUR (Géosignal)"]

OK, I will wait then.

Thank you

strk at refractions.net wrote:
> ***********************
> Your mail has been scanned by InterScan VirusWall.
> ***********-***********
> 
> 
> On Fri, Dec 10, 2004 at 10:37:09AM +0100, strk at refractions.net wrote:
> 
>>On Fri, Dec 10, 2004 at 10:29:47AM +0100, "Guillaume SUEUR (Géosignal)" wrote:
>>
>>>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 ?
>>
>>Yes, removing the id from the VALUES, as it should have its own
>>sequence generating unique ids for appended values.
> 
> 
> Oops.. sorry. I found out it didn't go to 0.9.0.
> You need a snapshot of the pgis_0_9_0 branch or
> must wait for 0.9.1.
> 
> --strk;
> 
> 
>>>Thanks
>>
>>Thank you
>>--strk;
>>
>>
>>>-- 
>>>---------------------------
>>>Guillaume SUEUR
>>>GEOSIGNAL - Groupe BVA
>>>25bis Avenue Marcel Dassault
>>>31505 TOULOUSE CEDEX 5
>>>----------------------------
>>>
>>>_______________________________________________
>>>postgis-users mailing list
>>>postgis-users at postgis.refractions.net
>>>http://postgis.refractions.net/mailman/listinfo/postgis-users
>>
>>_______________________________________________
>>postgis-users mailing list
>>postgis-users at postgis.refractions.net
>>http://postgis.refractions.net/mailman/listinfo/postgis-users
> 
> 
> 
> 
> 

-- 
---------------------------
Guillaume SUEUR
GEOSIGNAL - Groupe BVA
25bis Avenue Marcel Dassault
31505 TOULOUSE CEDEX 5
----------------------------