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
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 |