Re: Select works only when connected from login postgres
Joseph Brenner <doomvox@gmail.com>
From: Joseph Brenner <doomvox@gmail.com>
To: Adrian Klaver <adrian.klaver@aklaver.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, pgsql-general@postgresql.org
Date: 2016-12-06T04:52:37Z
Lists: pgsql-hackers, 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
Commits
-
Handle empty or all-blank PAGER setting more sanely in psql.
- 1ec5cc025b41 9.2.20 landed
- ccb84dae13c9 9.4.11 landed
- bb39f58f76b4 9.6.2 landed
- 82eb5c514473 9.3.16 landed
- 370c7a863aa7 9.5.6 landed
- 18f8f784cbbf 10.0 landed