Re: Function and view to retrieve WAL receiver status - Mailing list pgsql-hackers

From Michael Paquier
Subject Re: Function and view to retrieve WAL receiver status
Date
Msg-id CAB7nPqSF=m7mvQDGaZfn-oCvy6PAMeir=h7f5u5Zhf_k5gLLxg@mail.gmail.com
Whole thread Raw
In response to Re: Function and view to retrieve WAL receiver status  (Gurjeet Singh <singh.gurjeet@gmail.com>)
Responses Re: Function and view to retrieve WAL receiver status  (Gurjeet Singh <singh.gurjeet@gmail.com>)
List pgsql-hackers
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.
-- 
Michael



pgsql-hackers by date:

Previous
From: Gurjeet Singh
Date:
Subject: Re: Function and view to retrieve WAL receiver status
Next
From: Vladimir Sitnikov
Date:
Subject: Re: W-TinyLfu for cache eviction