Re: Extension has owner - Mailing list pgsql-general

From Tom Lane
Subject Re: Extension has owner
Date
Msg-id 927333.1643727813@sss.pgh.pa.us
Whole thread Raw
In response to Extension has owner  (Färber, Franz-Josef (StMUK) <Franz-Josef.Faerber@stmuk.bayern.de>)
List pgsql-general
=?iso-8859-1?Q?F=E4rber=2C_Franz-Josef_=28StMUK=29?= <Franz-Josef.Faerber@stmuk.bayern.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
handleextension 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



pgsql-general by date:

Previous
From: Färber, Franz-Josef (StMUK)
Date:
Subject: Extension has owner
Next
From: Shaozhong SHI
Date:
Subject: Re: Counting the number of repeated phrases in a column