Re: pg_sorttemp* - Mailing list pgsql-general

From Tom Lane
Subject Re: pg_sorttemp*
Date
Msg-id 15628.961438199@sss.pgh.pa.us
Whole thread Raw
In response to RE: pg_sorttemp*  ("Chris Dorr" <chris@townnews.com>)
List pgsql-general
"Chris Dorr" <chris@townnews.com> writes:
> We are running 6.5 RPM version off of RH 6.1 I believe.

7.0.2 fixes a heck of a lot of bugs; you would be well advised to
update.

> As for the crash's, the data that was being inserted was found to be at
> fault.  We changed the data and we seem to be doing just fine now, but I'm
> sure it will pop up again.  I've got the old data around here that I'm going
> to analyze when I get a spare minute or two.  All the data was being
> inserted fine, but when we pulled it out via a PHP script (SELECT) it was
> dropping core files on us and wouldn't pull anything out.

Hmm.  What data types are involved, and how did you change the data
exactly to avoid the bug(s)?

            regards, tom lane

pgsql-general by date:

Previous
From: Joseph Shraibman
Date:
Subject: Re: postmaster logs
Next
From: Tom Lane
Date:
Subject: Re: current database?