Re: ALTER TABLE on system catalogs - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: ALTER TABLE on system catalogs
Date
Msg-id 20180928190630.crt43sk5zd5p555h@alvherre.pgsql
Whole thread Raw
In response to Re: ALTER TABLE on system catalogs  (Andres Freund <andres@anarazel.de>)
Responses Re: ALTER TABLE on system catalogs  (Andres Freund <andres@anarazel.de>)
List pgsql-hackers
On 2018-Aug-21, Andres Freund wrote:

> On 2018-08-21 17:04:41 +0200, Peter Eisentraut wrote:
>
> > That doesn't solve the original problem, which is being able to set
> > reloptions on pg_attribute, because pg_attribute doesn't have a toast
> > table but would need one according to existing rules.
> 
> I still think it's wrong to work around this than to actually fix the
> issue with pg_attribute not having a toast table.

FWIW I'm still bothered by the inability to move pg_largeobject to a
different tablespace, per
https://postgr.es/m/20160502163033.GA15384@alvherre.pgsql
While that needs even more work (preservability across pg_dump for one),
this item here would be one thing to fix.

Also, I don't quite understand what's so horrible about setting
autovacuum options for system catalogs, including those that don't have
toast tables.  That seems a pretty general feature that needs fixing,
too.

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services


pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: doc - improve description of default privileges
Next
From: Peter Eisentraut
Date:
Subject: Re: automatic restore point