Re: primary_conninfo missing from pg_stat_wal_receiver - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: primary_conninfo missing from pg_stat_wal_receiver
Date
Msg-id 20160701175615.GA318434@alvherre.pgsql
Whole thread Raw
In response to Re: primary_conninfo missing from pg_stat_wal_receiver  (Michael Paquier <michael.paquier@gmail.com>)
Responses Re: primary_conninfo missing from pg_stat_wal_receiver  (Michael Paquier <michael.paquier@gmail.com>)
List pgsql-hackers
Michael Paquier wrote:
> On Fri, Jul 1, 2016 at 8:50 AM, Michael Paquier
> <michael.paquier@gmail.com> wrote:

> >> Okay, that argument I buy.
> >>
> >> I suppose this function/view should report no row at all if there is no
> >> wal receiver connected, rather than a view with nulls.
> >
> > The function returns PG_RETURN_NULL() so as we don't have to use a
> > SRF, and the view checks for IS NOT NULL, so there would be no rows
> > popping up.
> 
> In short, I would just go with the attached and call it a day.

Done, thanks.

-- 
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services



pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: Forthcoming SQL standards about JSON and Multi-Dimensional Arrays (FYI)
Next
From: Robert Haas
Date:
Subject: Re: Bad behavior from plpython 'return []'