[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