Re: Function and view to retrieve WAL receiver status

Поиск
Список
Период
Сортировка
От Gurjeet Singh
Тема Re: Function and view to retrieve WAL receiver status
Дата
Msg-id CABwTF4XVB0+QPWDxxuFF3Fi=6TRBF+XUiqmSa7LT-qUF6EZhMw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Function and view to retrieve WAL receiver status  (Michael Paquier <michael.paquier@gmail.com>)
Ответы Re: Function and view to retrieve WAL receiver status  (Michael Paquier <michael.paquier@gmail.com>)
Список pgsql-hackers
Дерево обсуждения

On Sun, Dec 13, 2015 at 10:15 PM, Michael Paquier <michael.paquier@gmail.com> wrote:
On Mon, Dec 14, 2015 at 3:09 PM, Gurjeet Singh <singh.gurjeet@gmail.com> wrote:
> On Dec 13, 2015 9:56 PM, "Michael Paquier" <michael.paquier@gmail.com>
> wrote:
>> If the node has no WAL receiver active, a tuple with NULL values is
>> returned instead.
>
> IMO, in the absence of a WAL receiver the SRF (and the view) should not
> return any rows.

The whole point is to not use a SRF in this case: there is always at
most one WAL receiver.

The function, maybe. But emitting an all-nulls row from a view seems counter-intuitive, at least when looking at it in context of relational database.

--
Gurjeet Singh http://gurjeet.singh.im/

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

Предыдущее
От: Tomas Vondra
Дата:
Сообщение: PATCH: postpone building buckets to the end of Hash (in HashJoin)
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: fix for readline terminal size problems when window is resized with open pager