duplicate key

From: pascal bérest <lists(at)magnetophone(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: duplicate key
Date: 2003-01-13 15:10:43
Message-ID: a05200f07ba48876e5521@[80.236.54.8]
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello eveybody,

We are trying to REINDEX a database, but we encounter some strange problem.
We have the message "Cannot insert a duplicate key into index
synd_article_pkey".
It appears that we have duplicate key in the base, with exactly the
same informations.
We then did the above query:
"select id_synd_art from synd_article group by id_synd_art having
count(id_synd_art)>1".
id_synd_pkey is the primary key on id_synd_art, a not null field with
default nextval('"synd_article_id_seq"'::text)

By example, we can have the above informations, when we do a select
on one of the key given by the previous query :
11470 | actualite_generale/une/ | 2002-08-01 21:00:00-01 | La Une |
020802132619bsbfe0
11470 | actualite_generale/une/ | 2002-08-01 21:00:00-01 | La Une |
020802132619bsbfe0

We have exactly the same things in the base.
Actually, we have 221 duplicate keys in the table (65000 records)

We can't do REINDEX on the base and VACUUM. So the base is growing
and growing and so...

Any idea about this problem ?

Thanx,
Pascal.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Christoph Dalitz 2003-01-13 15:17:09 Re: PostgreSQL on Windows
Previous Message Nicolas Boretos 2003-01-13 14:59:00 Re: PostgreSQL on Windows