save history error, ignorable?

Started by Scott Frankelover 20 years ago3 messagesgeneral
Jump to latest
#1Scott Frankel
leknarf@pacbell.net

I just upgraded from postgres 7.x.x to 8.1.0 and am getting the
following error from cmd-line psql:

could not save history to file "<my_home_dir>/.psql_history":
Invalid argument

Searching the archives, I found a thread about this error wherein the
poster "solved" the problem by commenting out the reporting code in
the source file. Tom's reply (*) suggests a discrepancy in libraries
on MacOSX. Nonetheless, I *seem* to have the intended functionality
(readline history on the cmd-line), in spite of the error msg.

Questions:

- Is the error msg ignorable?

- Else, is there a post-compile fix for the problem?

- Does the correct lib exist on MacOSX? If so, is there doco on how
to specify its use on compiling?

My platform:

MacOSX v10.4.2
PostgreSQL v8.1.0

Thanks in advance!
Scott

(*) [ from Tom Lane, via archives search ]
The Postgres code in that area hasn't changed at all. Maybe in this
build you linked against Apple's builtin libedit instead of libreadline?
libedit seems to have a bizarre definition of the result value from
write_history()

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Scott Frankel (#1)
Re: save history error, ignorable?

Scott Frankel <leknarf@pacbell.net> writes:

[ Mac OS X ]
could not save history to file "<my_home_dir>/.psql_history":
Invalid argument

Searching the archives, I found a thread about this error wherein the
poster "solved" the problem by commenting out the reporting code in
the source file.

If you look back further, there is more discussion of this several
months back. It seems that libedit and libreadline are not compatible
about how write_history() reports errors. We haven't figured out a
nice solution for this yet.

- Is the error msg ignorable?

Pretty much.

- Does the correct lib exist on MacOSX?

You can grab libreadline and install it into /usr/local, or use the
version from Fink.

regards, tom lane

#3Scott Frankel
leknarf@pacbell.net
In reply to: Tom Lane (#2)
Re: save history error, ignorable?

OK. Thanks!
Scott

On Nov 10, 2005, at 10:20 AM, Tom Lane wrote:

Show quoted text

Scott Frankel <leknarf@pacbell.net> writes:

[ Mac OS X ]
could not save history to file "<my_home_dir>/.psql_history":
Invalid argument

Searching the archives, I found a thread about this error wherein the
poster "solved" the problem by commenting out the reporting code in
the source file.

If you look back further, there is more discussion of this several
months back. It seems that libedit and libreadline are not compatible
about how write_history() reports errors. We haven't figured out a
nice solution for this yet.

- Is the error msg ignorable?

Pretty much.

- Does the correct lib exist on MacOSX?

You can grab libreadline and install it into /usr/local, or use the
version from Fink.

regards, tom lane

---------------------------(end of
broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster