So, is there hope of a better fix here for 9.2 (specifically for preserving extension ownership on pg_upgrade and dump/restore, though I understand it may not make sense to do that if we can't fix a number of related issues)? If not, is the below catalog-twiddling sane, lacking an ALTER EXTENSION foo OWNER TO ...?
postgres=# update pg_extension set extowner = (select oid from pg_roles where rolname = 'maciek') where extname = 'plpgsql'; -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs