Re: Internal error while setting reloption on system catalogs.

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Internal error while setting reloption on system catalogs.
Дата
Msg-id 20605.1549378908@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Internal error while setting reloption on system catalogs.  (Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>)
Ответы Re: Internal error while setting reloption on system catalogs.  (Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>)
Список pgsql-hackers
Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp> writes:
> The following command complains with an internal
> error. (allow_system_table_mods is on).

> alter table pg_attribute set (fillfactor = 90);
>> ERROR:  AccessExclusiveLock required to add toast table.

> The same happens for pg_class.

Isn't this more or less the same thing Peter E. was attempting to fix in
https://commitfest.postgresql.org/22/1764/
?

> The first attached is for master and 11.
> The second is for 10.
> The third is for 9.6.

It's not clear to me that we ought to consider catalog alterations
supported at all, but in any case I wouldn't treat it as something
to back-patch.

            regards, tom lane


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

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: Memory contexts reset for trigger invocations
Следующее
От: Andrew Dunstan
Дата:
Сообщение: Re: fast defaults in heap_getattr vs heap_deform_tuple