Re: duplicate key

pascal =?iso-8859-1?Q?b=E9rest?= <lists@magnetophone.com> writes:
> We have exactly the same things in the base.
> Actually, we have 221 duplicate keys in the table (65000 records)

Seems like a bug, but there's no chance of diagnosing it without more
info.  For starters, what Postgres version are you running?  Are all of
the records with duplicate keys exact duplicates in all other fields
too?  Also, it would be useful to see the ctid, xmin, xmax, cmin,
and cmax values for some of the sets of duplicate rows.

            regards, tom lane