Re: [BUGS] Upgrading from < 8.1 with users and groups with same name

2005-12-29 Thread Tom Lane
Martin Pitt <[EMAIL PROTECTED]> writes: > 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 na

Re: [BUGS] Upgrading from < 8.1 with users and groups with same name

2005-12-29 Thread Bruce Momjian
Martin Pitt wrote: -- Start of PGP signed section. > 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 > ge

[BUGS] Upgrading from < 8.1 with users and groups with same name

2005-12-29 Thread Martin Pitt
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