On Wed, Aug 9, 2017 at 10:10 AM, Tom Lane <[email protected]> wrote: > Melvin Davidson <[email protected]> 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 ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
