Re: Role incompatibilities

Stephen Frost <sfrost@snowman.net> writes:
> Eh, it does and it doesn't.  The SQL standard says that no roles are
> automatically inheirited and that you have to 'set role' to them.  Thus,
> all non-user roles which are granted to users in Postgres would need to
> be defined 'noinherit' to have things work as the spec wants.

We note in the CREATE ROLE docs:
The behavior specified by the SQL standard is most closely approximatedby giving users the NOINHERIT attribute, while
rolesare given theINHERIT attribute.
 

For the purposes of the information_schema, it might work best to
consider NOINHERIT (rather than LOGIN) as being what identifies a user
rather than a role.
        regards, tom lane