Thread: databases hidden in phppgadmin

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.  I have
tried logging in as superuser, as well as a user belonging to the said
group, but the databases do not show up.

Is there a config option I need to set to allow this, or is it simply
not possible.

Thanks!
--Darren Hromas

"Darren" <notross@hotmail.com> 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.  As of PG 8.1 they need
to be using pg_roles instead ... and if I were them, I'd make it a LEFT
JOIN so that databases don't disappear completely if the owner can't be
found.

            regards, tom lane

On Friday 14 July 2006 11:22, Tom Lane wrote:
> "Darren" <notross@hotmail.com> 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.  As of PG 8.1 they need
> to be using pg_roles instead ... and if I were them, I'd make it a LEFT
> JOIN so that databases don't disappear completely if the owner can't be
> found.

You know Tom, if you're interested in hacking on phpPgAdmin, I'd be happy to
send you a copy of "Beginning PHP & PostgreSQL 8 "
:-)

Darren,  this is fixed in ppa's CVS HEAD.  If you want a specific patch, drop
me a note off list, though I am thinking of putting out a 4.0.2 release
sometime this week.

--
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL