From: | Martin Pitt <martin(at)piware(dot)de> |
---|---|
To: | PostgreSQL Bugs <pgsql-bugs(at)postgresql(dot)org> |
Subject: | Upgrading from < 8.1 with users and groups with same name |
Date: | 2005-12-29 22:00:27 |
Message-ID: | 20051229220027.GE5114@piware.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
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?
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2005-12-30 01:06:04 | Re: Upgrading from < 8.1 with users and groups with same name |
Previous Message | Carlos del Cacho | 2005-12-29 14:26:51 | BUG #2135: system error 182 while loading ODBC driver |