Re: Select works only when connected from login postgres

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Joseph Brenner <doomvox(at)gmail(dot)com>
Cc: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Select works only when connected from login postgres
Date: 2016-12-06 01:37:06
Message-ID: 23772.1480988226@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

Joseph Brenner <doomvox(at)gmail(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message sunpeng 2016-12-06 02:05:47 Does PostgreSQL support BIM(Building Information Modeling) storage?
Previous Message Adrian Klaver 2016-12-06 01:33:01 Re: Select works only when connected from login postgres

Browse pgsql-hackers by date

  From Date Subject
Next Message Craig Ringer 2016-12-06 01:46:17 Re: Typmod associated with multi-row VALUES constructs
Previous Message Kyotaro HORIGUCHI 2016-12-06 01:36:39 Re: Typmod associated with multi-row VALUES constructs