Re: Internal error while setting reloption on system catalogs.

At Tue, 05 Feb 2019 10:01:48 -0500, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote in <20605(dot)1549378908(at)sss(dot)pgh(dot)pa(dot)us>
> 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/
> ?

Uggh Right. One of the problem is the same with this. Thank you
for the pointer, Tom.

> > 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.

I'm ok with that. Considering using reloption on system catalogs
let me notice it.

regards.

--
Kyotaro Horiguchi
NTT Open Source Software Center