[gdal-dev] append mode in postgresql

Yves Jacolin (Free) yjacolin at free.fr
Wed Mar 6 06:38:11 PST 2013


Hello,

I am trying to import EDIGEO files in append mode. The doc said to use -append 
flag with ogr2ogr commande.

ogr2ogr -gt 65536 -f "PostgreSQL" "PG:dbname=test_edigeo  host='localhost'" -
lco "GEOMETRY_NAME=the_geom" -lco "SCHEMA=test" -lco "OVERWRITE=YES" -nln 
EDIGEO_parcelle  E0001.THF PARCELLE_id

=> ok

ogr2ogr -append -update -gt 65536 -f "PostgreSQL" "PG:dbname=test_edigeo  
host='localhost'" -lco "GEOMETRY_NAME=the_geom" -lco "SCHEMA=test" -nln 
EDIGEO_parcelle  E0002.THF PARCELLE_id

=> nok I get this error message:

ERROR 1: Layer test.edigeo_parcelle already exists, CreateLayer failed.
Use the layer creation option OVERWRITE=YES to replace it.
ERROR 1: Terminating translation prematurely after failed
translation of layer PARCELLE_id (use -skipfailures to skip errors)

Postgresql log file shows:
2013-03-06 15:35:44 CET LOG:  could not receive data from client: Connection 
reset by peer
2013-03-06 15:35:44 CET LOG:  unexpected EOF on client connection

and other information which doesn't seem interesting to me.

Any idea whe append mode is not wroking in my test?

Thanks,

Y.



More information about the gdal-dev mailing list