Re: Select works only when connected from login postgres - Mailing list pgsql-general

From Joseph Brenner
Subject Re: Select works only when connected from login postgres
Date
Msg-id CAFfgvXVOpGHhCzQLkEy-LGt-6oQKnuzauaP_dBZJY4PdkMPWvw@mail.gmail.com
Whole thread Raw
In response to Re: Select works only when connected from login postgres  (Joseph Brenner <doomvox@gmail.com>)
Responses Re: Select works only when connected from login postgres
List pgsql-general
Wait, that's not quite right.  The user 'postgres' has no PAGER envar,
but user 'doom' has an empty value:

PAGER=


On Mon, Dec 5, 2016 at 8:50 PM, Joseph Brenner <doomvox@gmail.com> wrote:
>> So what does:
>>
>> env | grep PAGER
>>
>> show?
>
> Nothing.  I have no PAGER settting (I don't normally use one).
>
>
> On Mon, Dec 5, 2016 at 5:33 PM, Adrian Klaver <adrian.klaver@aklaver.com> wrote:
>> On 12/05/2016 05:13 PM, Joseph Brenner wrote:
>>
>>
>>> I just went around temporarily undoing things I did while
>>> straigtening up, and I find there's one thing I can do that
>>> consistently breaks things: removing my new ~/.psqlrc file.
>>> In fact, it appears that I need to have a file that exists and
>>> contains this line:
>>>
>>>    \pset pager off
>>
>>
>> So what does:
>>
>> env | grep PAGER
>>
>> show?
>>
>>
>>
>>
>> --
>> Adrian Klaver
>> adrian.klaver@aklaver.com


pgsql-general by date:

Previous
From: Joseph Brenner
Date:
Subject: Re: Select works only when connected from login postgres
Next
From: Joseph Brenner
Date:
Subject: Re: Select works only when connected from login postgres