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.
regards, tom lane