Tom Lane wrote: > Bruce Momjian <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html