[Qgis-user] Append in Import Vector into PostGIS didn't work

Frederico dos Santos Soares fssunb at gmail.com
Thu Oct 13 18:21:57 PDT 2016


Hi everybody,
I have some problems with the "Import Vector into PostGIS" in processing
tool.

I looked for, but I didn't find nothing  about this problem.
The  "append" funcionality in an existent table in PostGIS didn't work for
me.
First I tried using the funcionality with a complex model, then I tried a
very simple model that use one entry, one MultiLinestring shape (with the
same columns and data type) doing a append in another MultiLinestring
table. In all situations I have the same error:
I'm using Win7 (64bits) and QGIS 2.8 (64bits) - PostGIS 2.2 Postgre 9.4.5

I dont use create new table, or create new fields, "launder" is off, only
"append" is on.

Has anyone gone through this?

Thank you all.

cmd.exe /C ogr2ogr.exe -progress --config PG_USE_COPY YES -f PostgreSQL
PG:"host=xxxx port=5432 dbname=db_teste_geo password=xxxx user=xxxx" -lco
DIM=2
C:\Users\XXX~1\AppData\Local\Temp\processing\6961f6cd879c4bdc92c49e140f8b5d57\OUTPUTALGQGISDELETECOLUMN4.shp
OUTPUTALGQGISDELETECOLUMN4 -append -nlt MULTILINESTRING -lco
SCHEMA=teste_geo -lco GEOMETRY_NAME=ge_unidade_coleta -lco
FID=sq_unidade_coleta -nln unidade_coleta -spat -3989795.35353
-1055635.86106 -3988598.79104 -1047550.89123 -nlt PROMOTE_TO_MULTI -lco
PRECISION=NO
GDAL command output:
Progress turned off as fast feature count is not available.
ERROR 1: Layer teste_geo.unidade_coleta already exists, CreateLayer failed.
Use the layer creation option OVERWRITE=YES to replace it.
ERROR 1: Terminating translation prematurely after failed
translation of layer OUTPUTALGQGISDELETECOLUMN4 (use -skipfailures to skip
errors)


-- 

Frederico dos Santos Soares
GeĆ³grafo
55 61 8416 0105
fssunb at gmail.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20161013/79c9ee2b/attachment.html>


More information about the Qgis-user mailing list