| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Färber, Franz-Josef (StMUK) <Franz-Josef(dot)Faerber(at)stmuk(dot)bayern(dot)de> |
| Cc: | "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Extension has owner |
| Date: | 2022-02-01 15:03:33 |
| Message-ID: | 927333.1643727813@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
=?iso-8859-1?Q?F=E4rber=2C_Franz-Josef_=28StMUK=29?= <Franz-Josef(dot)Faerber(at)stmuk(dot)bayern(dot)de> writes:
> I discovered that extensions have owners (pg_extension.extowner).
Yup.
> 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?
It's been discussed, but there are some sticky issues around whether
to change the ownership of the extension's objects. I don't know
of anyone working on it at the moment.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Shaozhong SHI | 2022-02-01 18:49:34 | Re: Counting the number of repeated phrases in a column |
| Previous Message | Färber | 2022-02-01 12:08:38 | Extension has owner |