Re: databases hidden in phppgadmin

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: databases hidden in phppgadmin
Дата
Msg-id 20295.1152890551@sss.pgh.pa.us
обсуждение исходный текст
Ответ на databases hidden in phppgadmin  ("Darren" <notross@hotmail.com>)
Ответы Re: databases hidden in phppgadmin
Список pgsql-general
"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

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

Предыдущее
От: "Merlin Moncure"
Дата:
Сообщение: Re: Problem with archive_command
Следующее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: Antw: Problem with archive_command