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

"Marc G. Fournier" <scrappy(at)postgresql(dot)org> 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