Hi PostgreSQL developers!
I recently got a rather interesting Debian bug : When upgrading a
pre-8.1 database to 8.1, the upgrade messes up permissions if the old
database had users and groups with the same name. Since in 8.1 they
get collapsed to a 'role' there will be a name clash.
My current solution checks for this situation and aborts the upgrade
if there is at least one name which is both an user and a group (and
asks for renaming either before attempting the upgrade again).
For an upstream solution, maybe pg_dumpall should detect this
situation and abort with an error?
Thank you in advance for any idea,
Martin Pitt http://www.piware.de
Ubuntu Developer http://www.ubuntu.com
Debian Developer http://www.debian.org
In a world without walls and fences, who needs Windows and Gates?
pgsql-bugs by date
|Next:||From: Bruce Momjian||Date: 2005-12-30 01:06:04|
|Subject: Re: Upgrading from < 8.1 with users and groups with same name|
|Previous:||From: Carlos del Cacho||Date: 2005-12-29 14:26:51|
|Subject: BUG #2135: system error 182 while loading ODBC driver|