Horton

Re: Select works only when connected from login postgres

Tom Lane <tgl@sss.pgh.pa.us>

View thread View on postgr.es
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Joseph Brenner <doomvox@gmail.com>
Cc: Adrian Klaver <adrian.klaver@aklaver.com>, pgsql-general@postgresql.org
Date: 2016-12-06T01:37:06Z
Lists: pgsql-hackers, pgsql-general 
Joseph Brenner <doomvox@gmail.com> writes:
> Okay: I think I'm closing in on the trouble.  I didn't used to
> have a ~/.psqlrc file, but recently I experimented with
> creating one.  When I have a .psqlrc file containing the magic
> incantaion

>    \pset pager off

> *Then* everything works.

Ah!  So, most likely, there is something wrong with the local installation
of "more", or whatever the environment variable PAGER is set to.  If you
say "more somefile", does it behave reasonably?  Check "echo $PAGER"
as well.

			regards, tom lane

Commits

  1. Handle empty or all-blank PAGER setting more sanely in psql.