On Wednesday 15 July 2015 11:42:50 [email protected] wrote: > Hi all, > I recently installed GDAL 2.0 and this is my issue: > if I take a simple shp (or csv file) and then > > ogr2ogr -f PostgreSQL "PG:host=localhost user=myuser schemas=myschema" > mylayer -nln mylayer > > The layer is successfully imported in the DB and in the right schema, but I > read: > > ERROR 1: PQconnectdb failed: invalid connection option "schemas" > ERROR 1: Couldn't establish a database connection > > > If i use the -overwrite option, no errors are printed.
Michele, I can replicate the issue. I had a quick look and the cause was not obvious. Could you please file a ticket in Trac about that for further investigation ? Actually I see it works if you add -update, so as to update the PG connection in update mode, rather than in "creation" mode. The creation mode has always been kind of a hack since technically OGR does not create a database, but just connects to an existing one. But I can't figure out a strong reason for which the syntax you use wouldn't work anymore. Even > > michele > _______________________________________________ > gdal-dev mailing list > [email protected] > http://lists.osgeo.org/mailman/listinfo/gdal-dev -- Spatialys - Geospatial professional services http://www.spatialys.com _______________________________________________ gdal-dev mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/gdal-dev
