Re: referential integrity violation - key referenced from - Mailing list pgsql-bugs

From Tom Lane
Subject Re: referential integrity violation - key referenced from
Date
Msg-id 11815.1156281520@sss.pgh.pa.us
Whole thread Raw
In response to Re: referential integrity violation - key referenced from  ("Luiz Henrique" <luizhwk@gmail.com>)
List pgsql-bugs
"Luiz Henrique" <luizhwk@gmail.com> writes:
> On 8/21/06, Jim Nasby <jnasby@pervasive.com> wrote:
>> What version are you using? In recent versions, indexes are supposed
>> to be safe from corruption, even through crashes.

> It's Postgresql 7.2.1, installed with stable version of Debian Woody, at the
> time.

7.2.1 is ancient and has a very long list of known bugs.  We officially
abandoned support for the 7.2.* branch more than a year ago, upon
finding some bugs that were simply not practical to fix in that branch.

If you must keep using 7.2.*, at least get yourself onto 7.2.8, the last
of that series.  But you'd be doing yourself a real favor by expending
a little more effort and moving to a current release series ---
preferably 8.1.*.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #2585: Please provide pkg-config support
Next
From:
Date:
Subject: Transactions from Visual C++