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
|
| Список | pgsql-hackers |
On Sun, Dec 13, 2015 at 10:15 PM, Michael Paquier <michael.paquier@gmail.com> wrote:
The whole point is to not use a SRF in this case: there is always atOn 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.
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 по дате отправления: