Re: duplicate key

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: duplicate key
Дата
Msg-id 25697.1042475066@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: duplicate key  (pascal bérest <lists@magnetophone.com>)
Ответы Re: duplicate key  (Wenzhe Zhou <wzhou@cisco.com>)
Список 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 по дате отправления:

Предыдущее
От: pascal bérest
Дата:
Сообщение: Re: duplicate key
Следующее
От: Larry Rosenman
Дата:
Сообщение: DNS for POSTGRESQL.ORG