Re: duplicate key

Поиск
Список
Период
Сортировка
От Wenzhe Zhou
Тема Re: duplicate key
Дата
Msg-id 4.3.2.7.2.20030113085743.00ba3400@mira-sjc5-6.cisco.com
обсуждение исходный текст
Ответ на Re: duplicate key  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: pascal bérest
Дата:
Сообщение: Re: duplicate key
Следующее
От: Lincoln Yeoh
Дата:
Сообщение: Re: forum - Software