Re: mistakes in postgresql-snapshots (7.3)

Tom Lane wrote:
> Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> > Is this something we need to address for 7.3?
>
> Peter pointed out that he'd already hacked pg_dump to do the right
> thing (or at least what is arguably the right thing) against older
> databases. That covers LANGUAGE, FUNCTION, and other objects-within-
> a-database cases. pg_dumpall doesn't yet do the right thing at the
> database level, but I believe he's planning to take care of that.
>
> A larger problem is that this only works if you use 7.3 pg_dump
> to dump your older database. If you dump with your then-current
> pg_dump, you'll be unhappy with the permissions that result after
> reloading into your new 7.3 server.
>
> I'm not sure there is anything we can do about this without making
> life worse. But it's annoying. Any thoughts?

Yep, it better be on our radar screen. Added to open items:

Fix db, function, language permissions on 7.2 database loads

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073