Re: ALTER TABLE on system catalogs

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: ALTER TABLE on system catalogs
Дата
Msg-id 20180928190630.crt43sk5zd5p555h@alvherre.pgsql
обсуждение исходный текст
Ответ на Re: ALTER TABLE on system catalogs  (Andres Freund <andres@anarazel.de>)
Ответы Re: ALTER TABLE on system catalogs  (Andres Freund <andres@anarazel.de>)
Список 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 по дате отправления:

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: doc - improve description of default privileges
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: automatic restore point