Re: databases hidden in phppgadmin

Поиск
Список
Период
Сортировка
От Robert Treat
Тема Re: databases hidden in phppgadmin
Дата
Msg-id 200607181512.32520.xzilla@users.sourceforge.net
обсуждение исходный текст
Ответ на Re: databases hidden in phppgadmin  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
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

В списке pgsql-general по дате отправления:

Предыдущее
От: "Xn Nooby"
Дата:
Сообщение: Just want to verify Posgresql works on DRDB
Следующее
От: "Merlin Moncure"
Дата:
Сообщение: Re: Performance problem with query