[gdal-dev] append mode in postgresql

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


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?



More information about the gdal-dev mailing list