Re: duplicate key

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pascal bérest <lists(at)magnetophone(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: duplicate key
Date: 2003-01-13 15:53:28
Message-ID: 25349.1042473208@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

pascal =?iso-8859-1?Q?b=E9rest?= <lists(at)magnetophone(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message pascal bérest 2003-01-13 16:22:12 Re: duplicate key
Previous Message Christoph Dalitz 2003-01-13 15:17:09 Re: PostgreSQL on Windows