Re: Function and view to retrieve WAL receiver status

On Sun, Dec 13, 2015 at 10:15 PM, Michael Paquier <michael(dot)paquier(at)gmail(dot)com
> wrote:

> On Mon, Dec 14, 2015 at 3:09 PM, Gurjeet Singh <singh(dot)gurjeet(at)gmail(dot)com>
> wrote:
> > On Dec 13, 2015 9:56 PM, "Michael Paquier" <michael(dot)paquier(at)gmail(dot)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/