On Tue, Jul 10, 2012 at 01:03:18PM -0700, Maciek Sakrejda wrote: > 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';
There is no hope that any changes to extensions will be preserved across upgrades any better than it was in 9.1 --- the change is only that pg_upgrade will not fail. -- Bruce Momjian <br...@momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com + It's impossible for everything to be true. + -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs