From: | Robert Treat <xzilla(at)users(dot)sourceforge(dot)net> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Darren" <notross(at)hotmail(dot)com> |
Subject: | Re: databases hidden in phppgadmin |
Date: | 2006-07-18 19:12:32 |
Message-ID: | 200607181512.32520.xzilla@users.sourceforge.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Friday 14 July 2006 11:22, Tom Lane wrote:
> "Darren" <notross(at)hotmail(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Merlin Moncure | 2006-07-18 19:39:34 | Re: Performance problem with query |
Previous Message | Xn Nooby | 2006-07-18 19:09:54 | Just want to verify Posgresql works on DRDB |