Re: delete commands fails silently to delete primary key - Mailing list pgsql-general

From Tom Lane
Subject Re: delete commands fails silently to delete primary key
Date
Msg-id 25120.1227458223@sss.pgh.pa.us
Whole thread Raw
In response to Re: delete commands fails silently to delete primary key  ("Andrus" <kobruleht2@hot.ee>)
List pgsql-general
"Andrus" <kobruleht2@hot.ee> writes:
>> There have been a number of index-corruption bugs fixed since 8.1.4 ...
>>
>> In particular, if it's possible that any of these clients abort before
>> committing these insertions, the vacuum race condition bug fixed in
>> 8.1.10 is a pretty likely candidate for your problem.

> I changed second statement to ...
> Will this fix the isse

No.  Look, as you've been told several times already you are running a
very old version with a lot of known bugs.  Just update to the latest
in that branch.  It's not hard.

            regards, tom lane

pgsql-general by date:

Previous
From: "V S P"
Date:
Subject: Re: Using Postgres to store high volume streams of sensor readings
Next
From: "Ciprian Dorin Craciun"
Date:
Subject: Re: Using Postgres to store high volume streams of sensor readings