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

[Sandro Santilli]

On Mon, Oct 17, 2016 at 01:34:03PM -0200, Frederico dos Santos Soares wrote:
> Hi Sandro,
> Yes I can but, where?

On http://github.com/qgis/qgis ?

--strk;
> 
> 2016-10-17 7:07 GMT-02:00 Sandro Santilli <strk at kbt.io>:
> 
> > Frederico, would you be up to turn this into a pull request ?
> >
> > There's now a test for connection string building in
> > python/plugins/processing/tests/GdalAlgorithmsTest.py
> > where you could add a test for it.
> >
> > --strk;
> >
> > On Sat, Oct 15, 2016 at 08:29:57PM -0300, Frederico dos Santos Soares
> > wrote:
> > > --Sorted out
> > >
> > > Sharing with the list the solution found.
> > >
> > > In a current work process, I need to run several models using the
> > > "processing" as "[OGR] Import into PostGIS" is the only tool that allows
> > > the output of the models do "append" on a table of Postgres / PostGIS, I
> > > had to solve the problem in the script.
> > >
> > > Recalling I am using QGIS 2.8
> > >
> > > The reference that I used to solve the problem, comes from the same tool
> > in
> > > version 2.14. Clarify that in version 2.14 Import into postgis did not
> > work
> > > if executed within a model, at least not work for me, I believe we have
> > > another bug there.
> > >
> > > Returning. The "Import into postgis" (for available connections) works in
> > > ogr2ogrtopostgislist.py file in the ... \ QGIS Wien \ apps \ qgis-ltr \
> > > python \ plugins \ processing \ algs \ gdal
> > >
> > > The file in its original version builds the command of ogr2ogr with the
> > > schema parameter "-lco" + schema outside the database configuration
> > > parameters: -> ... -append -nlt MULTILINESTRING -lco SCHEMA = teste_geo
> > ...
> > >
> > > I changed the file so that the schema parameter was written into the
> > > connection as follows "active_schema =" + schema -> PG: "host = localhost
> > > port = 5432 dbname = gis password = xxx active_schema=temp
> > >
> > > And voila it worked!
> > >
> > > Attached the file, marked with # rows that were changed.
> > >
> > > I hope that helps someone want to use this tool in their models. I'm
> > using
> > > it's pretty cool.
> > >
> > > Best regards.