Dave Hughes <dhughes20@xxxxxxxxx> writes: > I recently noticed that my default superuser "postgres" cannot create > tables in new schemas I create, but can in some existing ones. > So as the postgres user I ran: > afleads=# create schema mytest; > CREATE SCHEMA > afleads=# create table mytest.test (col1 int); > ERROR: permission denied for schema mytest > LINE 1: create table mytest.test (col1 int); I think you're shooting yourself in the foot with those event triggers, ie trg_create_table is switching the role to something that lacks permissions to do the CREATE. regards, tom lane
