On Wed, Aug 9, 2017 at 10:10 AM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Melvin Davidson <melvin6925(at)gmail(dot)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?