Re: [BUGS] BUG #6706: pg_upgrade fails when plpgsql dropped/re-created

2012-07-10 Thread Daniel Farina
On Tue, Jul 10, 2012 at 2:43 PM, Bruce Momjian wrote: > 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 sens

Re: [BUGS] BUG #6706: pg_upgrade fails when plpgsql dropped/re-created

2012-07-10 Thread Bruce Momjian
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)?

Re: [BUGS] BUG #6706: pg_upgrade fails when plpgsql dropped/re-created

2012-07-10 Thread Maciek Sakrejda
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 f