| From: | Färber, Franz-Josef (StMUK) <Franz-Josef(dot)Faerber(at)stmuk(dot)bayern(dot)de> |
|---|---|
| To: | "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Extension has owner |
| Date: | 2022-02-01 12:08:38 |
| Message-ID: | a44a6d4c94f843d595af48ecf3c4cf67@stmuk.bayern.de |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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 for something like ALTER EXTERNSION .... OWNER TO ...
· pg_dump does not dump the owner.
Is this a bug? At least it is uncomfortable for me currently. Is any further support to change, export or otherwise handle extension owners planned?
Tested on a fresh postgres:14 docker container.
Regards,
Franz-Josef Färber
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2022-02-01 15:03:33 | Re: Extension has owner |
| Previous Message | Michael Harris | 2022-02-01 06:50:06 | Re: Undetected Deadlock |