Re: duplicate key - Mailing list pgsql-general

From Tom Lane
Subject Re: duplicate key
Date
Msg-id 25697.1042475066@sss.pgh.pa.us
Whole thread Raw
In response to Re: 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:
>> 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

pgsql-general by date:

Previous
From: pascal bérest
Date:
Subject: Re: duplicate key
Next
From: Larry Rosenman
Date:
Subject: DNS for POSTGRESQL.ORG