"Florian G. Pflug" <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq