It's funny how writing a question is usually the first step to answering it. Larry, you win! That was exactly the problem. I was logged in with my account which is not the owner of the schema. I realized that while digging a little deeper.
So this begs the question, how does one allow users to create tables that will inherit the default permissions without giving them explicit ownership of the schema? For instance, in my database I have a staff group that has read-only access to the database and other more specific groups that have more privileges, depending on the schema. Item 2? Anyone? Anyone? Bueller...? Bueller...? I am installing 3.2.1 now -- fingers crossed the problem is fixed. Thanks for the help! Cliff On Tue, Jul 24, 2018 at 12:20 PM, larry price <lapr...@gmail.com> wrote: > Regarding 1 are you and QGIS accessing the database as the same user? Is > that user the owner of the database or the schema in which tables are being > created? If not you will need to GRANT the appropriate privileges to the > user QGIS is using ON the parent object of the objects you are trying to > create > https://www.postgresql.org/docs/current/static/sql-grant.html > > > > On Tue, Jul 24, 2018 at 7:53 AM Cliff Patterson <cliffpatter...@gmail.com> > wrote: > >> 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 > >
_______________________________________________ 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
