"Marc G. Fournier" <[EMAIL PROTECTED]> writes:
> template1=# create user a_test_group in group a_test_group;
> ERROR: role "a_test_group" already exists
> So, if I have a group that happens to have a userid matching it, in the
> old system, its going to fail to load?
Groups and users are the same thing now, so the above isn't unexpected.
I think though that if you just ignore the error, it'll still work the
way you want --- the same role can serve as both a user and a group.
If the script tries to create the group first, you might need
ALTER USER a_test_group LOGIN;
to enable the role to login as a user.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
