Re: duplicate key - Mailing list pgsql-general

From Tom Lane
Subject Re: duplicate key
Date
Msg-id 25349.1042473208@sss.pgh.pa.us
Whole thread Raw
In response to duplicate key  (pascal bérest <lists@magnetophone.com>)
Responses Re: duplicate key
List pgsql-general
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

pgsql-general by date:

Previous
From: Christoph Dalitz
Date:
Subject: Re: PostgreSQL on Windows
Next
From: pascal bérest
Date:
Subject: Re: duplicate key