Re: [HACKERS] Group and Role Disagreement

2009-12-31 Thread David E. Wheeler
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 PostgreS

Re: [HACKERS] Group and Role Disagreement

2009-12-31 Thread Tom Lane
"David E. Wheeler" writes: > 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 show

[HACKERS] Group and Role Disagreement

2009-12-31 Thread David E. Wheeler
Fellow Hackers, Given this SQL: BEGIN; CREATE ROLE foo WITH NOLOGIN; CREATE ROLE foo_bar WITH LOGIN PASSWORD '***' INHERIT IN ROLE foo; CREATE ROLE foo_baz WITH LOGIN PASSWORD '***' INHERIT IN ROLE foo; CREATE ROLE foo_yow WITH LOGIN PASSWORD '***' INHERIT IN ROLE