Re: psql \q hang

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jeff Ross <jross(at)wykids(dot)org>
Cc: Greg Sabino Mullane <greg(at)turnstep(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: psql \q hang
Date: 2010-10-05 17:14:29
Message-ID: 26719.1286298869@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Jeff Ross <jross(at)wykids(dot)org> writes:
> On 10/05/10 10:35, Tom Lane wrote:
>> Huh ... what version of libreadline (or libedit) are you using exactly?
>> How did the large dump get in there?

> According to the README in the source, this is "Gnu Readline library,
> version 4.3.".

Well, that's not terribly new, but still ...

> I'm not sure how the dump got in there. I have a table of US Cities,
> Zip Codes and lat/long data in one of the databases and the contents of
> that table were in the history file twice.

When you say "contents of the table", what do you mean exactly? Did it
look like COPY data, psql SELECT output, or what? I'm still quite
confused about how data that you didn't type got into the history.

If you still have the file on backup media, it might be useful to look
at the last few history lines before each instance of the table
contents.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Andrea Peri 2007 2010-10-05 17:28:47 Need the binary of PG9.0 for Windows 32bit
Previous Message Jeff Ross 2010-10-05 17:01:26 Re: psql \q hang