Re: BUG #5891: Unique index is not unique

On Thu, Feb 17, 2011 at 4:51 AM, Alexander V. Chernikov
<melifaro(at)ipfw(dot)ru> wrote:
> Identical records:
> meganet=# SELECT count(*), array_agg(bc_payment_id) FROM billing.bc_payments
> GROUP BY contractor_name, payment_date, payment_commission_number,
> payment_sum, contractor_account, contractor_bik, inn HAVING count(*) > 1;
>  count |  array_agg
>
>
> -------+-------------
>
>
>     2 | {6376,6380}
>
>
>     2 | {6947,6605}

Has this database crashed at any point?

Can you reply-all with the output of SELECT ctid, xmin, xmax,
bc_payment_id FROM billing.bc_payments WHERE bc_payment_id IN
(6376,6380,6947,6605)?

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company