[Qgis-user] Importing to postgres db fails on 2.14

[Jorge Gustavo Rocha]

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
> 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
>

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