On Wed, Aug 9, 2017 at 12:19 PM, Scott Marlowe <scott.marl...@gmail.com> wrote:
> On Wed, Aug 9, 2017 at 10:10 AM, Tom Lane <t...@sss.pgh.pa.us> wrote: > > Melvin Davidson <melvin6...@gmail.com> 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? > *In keeping with what Tom advised, the SQL to do that would be"UPDATE pg_shdepend SET refobjid = {oid_of_new_owner} WHERE refobjid = {oid_of old_owner} AND deptype = 'o';* *However, as Scott suggested, there should definitely be an ALTER statement to change the owner of the extension * *and that does the work required.* *IE: ALTER EXTENSION name OWNER TO new_owner;* *Perhaps in Version 10 or 11?* *-- * *Melvin DavidsonI reserve the right to fantasize. Whether or not you wish to share my fantasy is entirely up to you. *