Hi Nikolai,
I was not able to reproduce the problem. I've imported several layers,
with different options, changing the geometry column, etc, and
everything went smooth, as expected.
I'm using QGIS 2.14.0, PostgreSQL 9.5.1, Postgis 2.2.1, DB Manager 0.1.20.
The DB Manager reposts the following privileges (selecting the target DB):
User has privileges:
create new schemas
create temporary tables
Can you try on the command line, for example, using ogr2ogr with the
same database, user and layer? Something like:
ogr2ogr -f "PostgreSQL" PG:"host=localhost user=xxx dbname=xxx
password=xxx active_schema=xxx" -nln tablename data.shp
Regards,
J. Gustavo
Às 20:39 de 10-03-2016, Nikolai Bezdna escreveu:
When importing a layer to a postgres db from a database manager window I
get an 'Error 8 Loading of layer failed' message.
From a postgis log the query part that fails is this one:
SELECT has_column_privilege('"myschema"."mytable"','mygeom','UPDATE')
And the error from postgres is well expected, because there is no
'mygeom' column of relation 'mytable' yet.
Double checked that in pgAdmin.
Maybe geometry field should be created earlier?
Can anyone confirm if it's a bug? I'm on 2.14.0.
_______________________________________________
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
J. Gustavo
--
Jorge Gustavo Rocha
Departamento de Informática
Universidade do Minho
4710-057 Braga
Tel: +351 253604480
Fax: +351 253604471
Móvel: +351 910333888
skype: nabocudnosor
_______________________________________________
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
