Re: Bug in Role support? - Mailing list pgsql-general

From Tom Lane
Subject Re: Bug in Role support?
Date
Msg-id 14497.1131123202@sss.pgh.pa.us
Whole thread Raw
In response to Bug in Role support?  ("Florian G. Pflug" <fgp@phlo.org>)
List pgsql-general
"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

pgsql-general by date:

Previous
From: "Florian G. Pflug"
Date:
Subject: Bug in Role support?
Next
From: Alex Turner
Date:
Subject: Re: Changing ids conflicting with serial values?