Re: Internal error while setting reloption on system catalogs.

2019-02-06 Thread Michael Paquier
On Wed, Feb 06, 2019 at 09:09:32AM +0900, Kyotaro HORIGUCHI wrote: > At Tue, 05 Feb 2019 10:01:48 -0500, Tom Lane wrote in > <20605.1549378...@sss.pgh.pa.us> >> Isn't this more or less the same thing Peter E. was attempting to fix in >> https://commitfest.postgresql.org/22/1764/? > > Uggh

Re: Internal error while setting reloption on system catalogs.

2019-02-05 Thread Kyotaro HORIGUCHI
At Tue, 05 Feb 2019 10:01:48 -0500, Tom Lane wrote in <20605.1549378...@sss.pgh.pa.us> > Kyotaro HORIGUCHI writes: > > The following command complains with an internal > > error. (allow_system_table_mods is on). > > > alter table pg_attribute set (fillfactor = 90); > >> ERROR:

Re: Internal error while setting reloption on system catalogs.

2019-02-05 Thread Tom Lane
Kyotaro HORIGUCHI 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

Internal error while setting reloption on system catalogs.

2019-02-05 Thread Kyotaro HORIGUCHI
Hello. 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. This is because ATRewriteCatalogs tries to add a toast table