"Florian G. Pflug" <fgp@phlo.org> writes:
> grant admin to fgp ;
> The last statement fails with "role "admin" is a member of role "fgp" -
> but I believe it is not.
> Did I do something wrong, or is this really a bug?
Looks like a bug to me too. I think it's coming from the fact that
is_member_of_role() thinks superusers are members of every role
ex officio ... which is true for permission checking purposes but
we don't want that rule applied here. Will fix.
regards, tom lane