[Qgis-user] PostGIS tables not inheriting default privileges in QGIS 2.18

[Cliff Patterson]

Good morning!

I am having two issues with PostGIS integration in QGIS. Wondering if
anyone can shed some light on the following.

*Issue 1*: Over the past few months I have noticed that all tables created
in or imported from QGIS 2.18 to my Postgres/PostGIS database do not
inherit the default privileges for the given schema (typically I use the DB
Manager for import or creation of new tables). I continually have to alter
the privileges manually for the newly created tables (in psql or PG Admin).
However, when I create  a table in psql or PGAdmin, all default privileges
are applied to the newly created table. I should add that I checked the
postgres logs and there are no errors when creating or importing tables
from QGIS. The only issue, of course, is that the default privileges are
not applied. Any ideas why this is happening?

*Issue 2: *I finally installed QGIS 3.2.0 and realized that rendering
PostGIS layers is VERY slow. All layers that load in seconds in 2.18 take
at least 10x longer in 3.2  A little googling revealed that this is a known
issue with QGIS 3.2.0, but no clear resolution. Is there currently a fix
for this issue for QGIS 3? Alternatively, is there a way to optimize
PostGIS performance in QGIS?

Big Thanks!
Cliff
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20180724/19c862d9/attachment.html>