Обсуждение: Duplicate rows primary key bug

Поиск
Список
Период
Сортировка

Duplicate rows primary key bug

От
leo xu
Дата:
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

От
Pavel Stehule
Дата:
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