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
_______________________________________________ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
