On Wed, Aug 9, 2017 at 10:10 AM, Tom Lane <tgl@xxxxxxxxxxxxx> wrote:
> Melvin Davidson <melvin6925@xxxxxxxxx> writes:
>> *UPDATE pg_extension SET extowner = {oid_of_new_owner} WHERE extowner =
>> {oid_from_above_statement};*
>
> Note you'll also have to modify the rows in pg_shdepend that reflect
> this ownership property.
Seems like something that should be handled by alter doesn't it?
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
