8.0 -> 8.1 migration issue with ROLEs ... maybe?

From: "Marc G(dot) Fournier" <scrappy(at)postgresql(dot)org>
To: pgsql-hackers(at)postgresql(dot)org
Subject: 8.0 -> 8.1 migration issue with ROLEs ... maybe?
Date: 2005-11-23 22:48:24
Message-ID: 20051123184049.U1053@ganymede.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


I just setup a test 8.1 server, to see how things work as far as the new
roles system is concerned, as it relates to migrating from 8.0->8.1 ...
specifically since there doesn't appear to be anything in HISTORY
concerning migrating up to 8.1 from 8.0 concerning this ...

As expected:

template1=# create group a_test_group;
CREATE ROLE
template1=# create user a_test_user in group a_test_group;
CREATE ROLE
template1=#

but:

template1=# create user a_test_group in group a_test_group;
ERROR: role "a_test_group" already exists
template1=#

So, if I have a group that happens to have a userid matching it, in the
old system, its going to fail to load?

Whereas, under 8.0, it does work:

test=# create user a_test_group in group a_test_group;
CREATE USER
test=#

Is there something I'm missing here, as far as ensuring a 'clean'
migration from pre-ROLEs?

----
Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
Email: scrappy(at)hub(dot)org Yahoo!: yscrappy ICQ: 7615664

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2005-11-24 00:05:26 Re: 8.0 -> 8.1 migration issue with ROLEs ... maybe?
Previous Message Oleg Bartunov 2005-11-23 21:31:48 Re: core dump on 8.1 and no dump on REL8_1_STABLE