| 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
| 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 |