Re: [GENERAL] psql \s not working - OS X - Mailing list pgsql-bugs

From Tom Lane
Subject Re: [GENERAL] psql \s not working - OS X
Date
Msg-id 28664.1308150995@sss.pgh.pa.us
Whole thread Raw
List pgsql-bugs
Joel Jacobson <joel@gluefinance.com> writes:
> I'm trying the new 9.1b2 release and got a weird problem with the \s
> command to show the latest history, for some reason it's trying to
> write to /dev/tty instead of printing out to stdout:

> glue=# \s
> could not save history to file "/dev/tty": Operation not permitted

Yeah, it's always done that.  libedit thinks it should do chmod()
on the target file, which while not inherently unreasonable is
guaranteed to spit up on /dev/tty.

Another problem with implementing \s-to-display as save-to-/dev/tty
is that if something did come out, it would be in libedit's rather ugly
encoded format.  libreadline happens to save the history file without
any decoration, but it's improper of us to depend on that.

We really ought to get rid of that implementation entirely and have
a separate code path for \s-to-display, which for extra credit could
go through the pager.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: Postgresql 9.0.4 initdb bug on solaris 64 bit
Next
From: Tom Lane
Date:
Subject: Re: BUG #6060: does not work -z option of pg_basebackup