Re: Assigning fixed OIDs to system catalogs and indexes

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Assigning fixed OIDs to system catalogs and indexes
Дата
Msg-id 2011.1113358405@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Assigning fixed OIDs to system catalogs and indexes  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
Ответы Re: Assigning fixed OIDs to system catalogs and indexes
Список pgsql-hackers
Christopher Kings-Lynne <chriskl@familyhealth.com.au> writes:
>> So some changing-oid operations like vacuum full, reindex, etc will not
>> affect these system catalogs?

> Is it possible to cluster system tables?

No, and yes.  CLUSTER, REINDEX, and similar things change the
relfilenode, not the relation OID.

If you are looking for things that will fundamentally break the system,
try renaming one of the indexes of a core system catalog ;-).  We could
avoid that dependency if we went by OIDs instead.
        regards, tom lane


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

Предыдущее
От: "Qingqing Zhou"
Дата:
Сообщение: Re: Assigning fixed OIDs to system catalogs and indexes
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Assigning fixed OIDs to system catalogs and indexes