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:53:41Z
Lists: pgsql-hackers, pgsql-general
And I guess I did that intentionally, my .bashrc has # I use emacs shells, I got a "pager" already: export PAGER='' On Mon, Dec 5, 2016 at 8:52 PM, Joseph Brenner <doomvox@gmail.com> wrote: > 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