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

[Saulteau Don]

Does it work with the -update flag as well as keeping the -append flag?

On Thu, Oct 13, 2016 at 6:21 PM, Frederico dos Santos Soares <
fssunb at gmail.com> wrote:

> 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
>
> _______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20161013/2c81abe3/attachment.html>