On Dec 31, 2009, at 3:41 PM, Tom Lane wrote:
>> My question is: why is the group membership of the foo_bar, foo_baz,
>> and foo_yow roles not reflected in pg_group?
>
> Per the fine manual:
>
> The view pg_group exists for backwards compatibility: it emulates a
> catalog that existed in PostgreSQL before version 8.1. It shows the
> names and members of all roles that are marked as not rolcanlogin, which
> is an approximation to the set of roles that are being used as groups.
Ah, hadn't noticed that, thanks for the pointer to TFM.
Best,
David