Re: Using CTID system column as a "temporary" primary key

Поиск
Список
Период
Сортировка
От Maciek Sakrejda
Тема Re: Using CTID system column as a "temporary" primary key
Дата
Msg-id CAOtHd0B8RihPwaE7_iO0JSe4utk=DJZ31ivic6+R7XP3E3dFUg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Using CTID system column as a "temporary" primary key  (Sebastien Flaesch <sebastien.flaesch@4js.com>)
Список pgsql-general
Note that VACUUM FULL and CLUSTER can update ctids. I don't believe regular VACUUM can, so you should be safe from autovacuum interfering in this scheme, but the ctid colum documentation [1] states "A primary key should be used to identify logical rows," so this is not exactly intended usage.

Thanks,
Maciek

В списке pgsql-general по дате отправления:

Предыдущее
От: Dominique Devienne
Дата:
Сообщение: Re: Cluster table based on grand parent?
Следующее
От: Rob Sargent
Дата:
Сообщение: Re: Cluster table based on grand parent?