Thread: psql error on quitting...

Hi,

I just upgraded from 8.0.4 to 8.1.0 this afternoon and the only thing
"bad" I have noticed is that whenever I quit psql I get a message:

could not save history to file "/Users/jerry/.psql_history": Invalid
argument

This is on MacOS X 10.4.3

Thanks for any info...

Jerry

Jerry LeVan <jerry.levan@eku.edu> writes:
> I just upgraded from 8.0.4 to 8.1.0 this afternoon and the only thing
> "bad" I have noticed is that whenever I quit psql I get a message:
> could not save history to file "/Users/jerry/.psql_history": Invalid
> argument
> This is on MacOS X 10.4.3

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() :-(

            regards, tom lane

Tom Lane writes:

> Jerry LeVan <jerry.levan@eku.edu> writes:
>> I just upgraded from 8.0.4 to 8.1.0 this afternoon and the only thing
>> "bad" I have noticed is that whenever I quit psql I get a message:
>> could not save history to file "/Users/jerry/.psql_history": Invalid
>> argument
>> This is on MacOS X 10.4.3
>
> The Postgres code in that area hasn't changed at all.

input.c has:

--8<---------------cut here---------------start------------->8---
revision 1.45
date: 2005/06/10 15:40:41;  author: momjian;  state: Exp;  lines: +2 -2
Use saveHistory so we get a nice error message on failure.
--8<---------------cut here---------------end--------------->8---

So, the error probably also occured in 8.0.4, but just wasn't reported
at all.

regards,
Andreas

Tom was right, on the Mac libreadline is linked to libedit.

My "solution" was to comment out the line reporting the
error in the program "input.c"

Jerry

On Nov 9, 2005, at 7:27 AM, Andreas Seltenreich wrote:

> Tom Lane writes:
>
>> Jerry LeVan <jerry.levan@eku.edu> writes:
>>> I just upgraded from 8.0.4 to 8.1.0 this afternoon and the only
>>> thing
>>> "bad" I have noticed is that whenever I quit psql I get a message:
>>> could not save history to file "/Users/jerry/.psql_history": Invalid
>>> argument
>>> This is on MacOS X 10.4.3
>>
>> The Postgres code in that area hasn't changed at all.
>
> input.c has:
>
> --8<---------------cut here---------------start------------->8---
> revision 1.45
> date: 2005/06/10 15:40:41;  author: momjian;  state: Exp;  lines:
> +2 -2
> Use saveHistory so we get a nice error message on failure.
> --8<---------------cut here---------------end--------------->8---
>
> So, the error probably also occured in 8.0.4, but just wasn't reported
> at all.
>
> regards,
> Andreas