Hi PostgreSQL developers! I recently got a rather interesting Debian bug [1]: 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 [1] http://bugs.debian.org/343622 -- 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?
signature.asc
Description: Digital signature
