Re: [GENERAL] databases hidden in phppgadmin

2006-07-18 Thread Robert Treat
On Friday 14 July 2006 11:22, Tom Lane wrote: > "Darren" <[EMAIL PROTECTED]> writes: > > When I login to phppgadmin, the list of databases does not include any > > databases that are owned by a 'group' (i.e. a role with NOLOGIN set). > > I'm betting that phppgadmin is using something like an inner

Re: [GENERAL] databases hidden in phppgadmin

2006-07-14 Thread Tom Lane
"Darren" <[EMAIL PROTECTED]> writes: > When I login to phppgadmin, the list of databases does not include any > databases that are owned by a 'group' (i.e. a role with NOLOGIN set). I'm betting that phppgadmin is using something like an inner join of pg_database and pg_user to produce its display.

[GENERAL] databases hidden in phppgadmin

2006-07-14 Thread Darren
My apologies if this is not the correct group, but I did not find a 'phppgadmin' specific group. When I login to phppgadmin, the list of databases does not include any databases that are owned by a 'group' (i.e. a role with NOLOGIN set). Databases owned by postgres or any specific user do show up.