Re: Internal error while setting reloption on system catalogs. - Mailing list 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