Postgres Pro
Downloads
Home   >   mailing lists

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 16353.1227396045@sss.pgh.pa.us
Whole thread Raw
In response to delete commands fails silently to delete primary key  ("Andrus" <kobruleht2@hot.ee>)
Responses Re: delete commands fails silently to delete primary key  ("Andrus" <kobruleht2@hot.ee>)
List pgsql-general
Tree view 
"Andrus" <kobruleht2@hot.ee> writes:
> I have table in 8.1.4 which tracks users logged into db

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.

            regards, tom lane

pgsql-general by date:

Previous
From: Martin Gainty
Date:
Subject: Re: date stamp on update?
Next
From: Scara Maccai
Date:
Subject: Re: Using Postgres to store high volume streams of sensor readings