Re: BUG #8891: Duplicate Primary Key

From: Marti Raudsepp <marti(at)juffo(dot)org>
To: anjali_524(at)yahoo(dot)co(dot)in
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #8891: Duplicate Primary Key
Date: 2014-01-20 09:55:42
Message-ID: CABRT9RBzJWFua2NYXJWjVkbjPOu19toW1JmisWdjM2TG4xxuLg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Mon, Jan 20, 2014 at 11:22 AM, <anjali_524(at)yahoo(dot)co(dot)in> wrote:
> The Postgres version on which the issue was reported is 8.2.2

Do you realize that this version was released almost 7 years ago? The
last bugfix release in the 8.2 series was 8.2.23, only 2 years ago. If
you don't apply bugfixes then you *will* eventually hit bugs.

> I verified the issue fix information into postgres release notes
> 9.0.4, 9.0.15, and 9.1 but could not find anything related to this issue.

It was probably some sort of index corruption, which allowed duplicate
values to be inserted. There have been a dozen bugs of this kind fixed
and it's hard to tell which one.

> We have upgraded our Postgres version to 9.0.4

Wait, what? 9.0.15 is the most recent version in the 9.0 series. You
should *always* use the newest minor version in a series and update
when new versions are released. Otherwise you will hit bugs again that
have been fixed for years.

Regards,
Marti

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message herbert.grohmann 2014-01-20 11:54:11 BUG #8893: Precompiler ECPG doesn't check Var-List in Select corrrect.
Previous Message anjali_524 2014-01-20 09:22:09 BUG #8891: Duplicate Primary Key