Skip site navigation (1) Skip section navigation (2)

Re: Duplicate rows primary key bug

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: leo xu <leoxu8703(at)gmail(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Duplicate rows primary key bug
Date: 2012-07-23 06:33:18
Message-ID: CAFj8pRDxL6eWcQm-qefzrNu-X=5qbzHf_oahaL4+NROX0LbqLQ@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-bugs
Hello

2012/7/23 leo xu <leoxu8703(at)gmail(dot)com>:
>   version
> -----------------------------------------------------------------
>  PostgreSQL 9.1.2 on red hat 5.4 x64, compiled by GCC 4.1
>
>
> There are several tables have two same rows with the same primary key.  This
> shouldn't happen. Has this been reported as a bug in this version?
>

you index is broken - the source of this issue should be in hw or in sw.

Can you repeat a operations that breaks your indexes?

Regards

Pavel Stehule


>
>
>
>
>
> --
> View this message in context: http://postgresql.1045698.n5.nabble.com/Duplicate-rows-primary-key-bug-tp5717581.html
> Sent from the PostgreSQL - bugs mailing list archive at Nabble.com.
>
> --
> Sent via pgsql-bugs mailing list (pgsql-bugs(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-bugs

In response to

pgsql-bugs by date

Next:From: Tom LaneDate: 2012-07-23 18:43:34
Subject: Re: BUG #6748: sequence value may be conflict in some cases
Previous:From: meixiangmingDate: 2012-07-23 01:51:56
Subject: BUG #6748: sequence value may be conflict in some cases

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group