| From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
|---|---|
| To: | Joseph Brenner <doomvox(at)gmail(dot)com> |
| Cc: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Select works only when connected from login postgres |
| Date: | 2016-12-06 05:03:42 |
| Message-ID: | CAKFQuwZ2cmj-f3hXJUCAvWGAmVzq5d-EBA-ZZMo1auaMAWfORw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
On Mon, Dec 5, 2016 at 9:53 PM, Joseph Brenner <doomvox(at)gmail(dot)com> wrote:
> And I guess I did that intentionally, my .bashrc has
>
> # I use emacs shells, I got a "pager" already:
> export PAGER=''
>
>
PAGER= psql --pset=pager=always -c 'select 1;'
<nothing on the screen>
Remove PAGER= and I'm good.
I guess that psql could be a bit more helpful by reporting something to
stderr if the value of PAGER is not an executable (platform dependent...)
I find it a bit odd that all of your queries were using the pager...did I
miss where you reported that setting?
David J.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joseph Brenner | 2016-12-06 05:28:11 | Re: Select works only when connected from login postgres |
| Previous Message | Joseph Brenner | 2016-12-06 04:53:41 | Re: Select works only when connected from login postgres |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Paquier | 2016-12-06 05:13:23 | Re: Adding in docs the meaning of pg_stat_replication.sync_state |
| Previous Message | Fujii Masao | 2016-12-06 04:54:55 | Re: Adding in docs the meaning of pg_stat_replication.sync_state |