Re: psql \watch always ignores \pset null - Mailing list pgsql-hackers

From Tom Lane
Subject Re: psql \watch always ignores \pset null
Date
Msg-id 9543.1416376444@sss.pgh.pa.us
Whole thread Raw
In response to psql \watch always ignores \pset null  (Fujii Masao <masao.fujii@gmail.com>)
Responses Re: psql \watch always ignores \pset null  (Will Leinweber <will@heroku.com>)
List pgsql-hackers
Fujii Masao <masao.fujii@gmail.com> writes:
> Hi,
>> /*
>>  * Set up rendering options, in particular, disable the pager, because
>>  * nobody wants to be prompted while watching the output of 'watch'.
>>  */
>> myopt.nullPrint = NULL;
>> myopt.topt.pager = 0;

> I found psql's \watch command always ignores \pset null setting.
> The above source code comment explains why it does,
> but I'd like to see the specified string for null value even in \watch's
> output, in order to distinguish null and an empty value. Thought?
> Is there any reason why \watch must ignore \pset null setting?

Hmmm ... the comment offers a reasonable argument for forcing pager = 0,
but I agree the nullPrint change is not adequately explained.
Will, do you remember why you did that?
        regards, tom lane



pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: REINDEX CONCURRENTLY 2.0
Next
From: Etsuro Fujita
Date:
Subject: Re: postgres_fdw behaves oddly