Re: [GENERAL] flatten pg_auth_members

2010-06-25 Thread A.M.
On Jun 23, 2010, at 6:01 PM, A.M. wrote: > Hello, > > I am trying to make a query which will flatten pg_auth_members into a table > with two columns "user" and "group" which will recurse inherited roles so > that each login role is associated once with any inherited roles (assuming > all asso

[GENERAL] flatten pg_auth_members

2010-06-23 Thread A.M.
Hello, I am trying to make a query which will flatten pg_auth_members into a table with two columns "user" and "group" which will recurse inherited roles so that each login role is associated once with any inherited roles (assuming all associated roles are inherited). This query does not do wh