Re: duplicate key - Mailing list pgsql-general

From Wenzhe Zhou
Subject Re: duplicate key
Date
Msg-id 4.3.2.7.2.20030113085743.00ba3400@mira-sjc5-6.cisco.com
Whole thread Raw
In response to Re: duplicate key  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
I got same problem with Postgres 7.2.3. I kept a tar file for the whole data directory.

Wenzhe

At 11:24 AM 1/13/2003 -0500, Tom Lane wrote:
>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
>
>---------------------------(end of broadcast)---------------------------
>TIP 2: you can get off all lists at once with the unregister command
>    (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)



pgsql-general by date:

Previous
From: pascal bérest
Date:
Subject: Re: duplicate key
Next
From: Lincoln Yeoh
Date:
Subject: Re: forum - Software