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 16:24:26
Message-ID: 25697.1042475066@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:
>> Also, it would be useful to see the ctid, xmin, xmax, cmin,
>> and cmax values for some of the sets of duplicate rows.

> Could you explain where we can have these informations ?

Select 'em. They're system columns, like OID.

> We also delete the duplicate keys, but we still have some of them.
> We delete again and again, and we still have some of them. Finally,
> we delete them manually, and it was possible to REINDEX the table.

So in other words, the evidence is now all gone? Oh well.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Larry Rosenman 2003-01-13 16:27:36 DNS for POSTGRESQL.ORG
Previous Message pascal bérest 2003-01-13 16:22:12 Re: duplicate key