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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
