Kyotaro HORIGUCHI <horiguchi(dot)kyotaro(at)lab(dot)ntt(dot)co(dot)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