Thread: Duplicate rows primary key bug

Duplicate rows primary key bug

From
leo xu
Date:
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?






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

Re: Duplicate rows primary key bug

From
Pavel Stehule
Date:
Hello

2012/7/23 leo xu <leoxu8703@gmail.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@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-bugs