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 < [email protected]> 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 > [email protected] > > _______________________________________________ > Qgis-user mailing list > [email protected] > List info: http://lists.osgeo.org/mailman/listinfo/qgis-user > Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user >
_______________________________________________ Qgis-user mailing list [email protected] List info: http://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
