Extension pg_trgm, permissions and pg_dump order

2022-05-25 Thread StMUK
Hello, using the postgres:14.3 docker container, the following fails - whereas using the 14.2 container, it succeeds. A bug? My minimal example goes like this: On the fresh container, execute ```sql CREATE ROLE limitedrole; CREATE SCHEMA ext_trgm; CREATE EXTENSION pg_trgm SCHEMA ext_trgm; GRANT

Extension has owner

2022-02-01 Thread StMUK
Hello, I discovered that extensions have owners (pg_extension.extowner). The pgadmin4 schema diff ... well er, kind of tried to report to me that the owners differ (https://redmine.postgresql.org/issues/7145). This seems to be badly supported: ยท postgres does not seem to have support f