BUG #2032: grant role bug - Mailing list pgsql-bugs

The following bug has been logged online:

Bug reference:      2032
Logged by:          Tom
Email address:      tom.zschockelt@flender.com
PostgreSQL version: 8.1
Operating system:   win2k
Description:        grant role bug
Details:

I've two login-roles ( usermgr, enduser ) each with a separate schema. I
want to grant privileges on schema usermgr and some of it's objects to a
group-role 'g_usermgr_use'.
(user = usermgr )

GRANT usage on SCHEMA usermgr to g_usermgr_use;
GRANT select on table a to g_usermgr;
GRANT select on table b to g_usermgr;

now I grant the group-role 'g_usermgr_use' to my login-user 'enduser'.

GRANT g_usermgr_use to enduser;

now I tried a select on one of the tables
user = enduser

select * from usermgr.a;

Here I got the following error message :

ERROR: permission denied for schema usermgr

Then I tried a
user = usermgr
GRANT usage on SCHEMA usermgr to enduser;

and again a
user = enduser

select * from usermgr.a;

now I got the following error

ERROR: permission denied for relation a

It seems that the group-role permissions do not work
properly.