[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