Re: ALTER TABLE OWNER: change indexes

Поиск
Список
Период
Сортировка
Искать
От
Peter Eisentraut
Тема
Re: ALTER TABLE OWNER: change indexes
Дата
Msg-id
Pine.LNX.4.30.0202241818570.686-100000@peter.localdomain
Ответ на
Список
Дерево обсуждения
Re: ALTER TABLE OWNER: change indexes Bruce Momjian <pgman@candle.pha.pa.us>
Re: ALTER TABLE OWNER: change indexes Yury Bokhoncovich <byg@center-f1.ru>
Re: ALTER TABLE OWNER: change indexes Bruce Momjian <pgman@candle.pha.pa.us>
Re: ALTER TABLE OWNER: change indexes Yury Bokhoncovich <byg@center-f1.ru>
Re: ALTER TABLE OWNER: change indexes Tom Lane <tgl@sss.pgh.pa.us>
Re: ALTER TABLE OWNER: change indexes Yury Bokhoncovich <byg@center-f1.ru>
Tom Lane writes:

> Another point that maybe does need immediate attention: as coded,
> reassignment of ownership of a table won't affect the associated
> TOAST table, if any.  Should it?

Maybe indexes and TOAST tables shouldn't have ownership it all.  (Set
relowner to 0.)  Since only owners can create these things, there doesn't
seem to be a point in maintaining ownership.

-- 
Peter Eisentraut   peter_e@gmx.net

В списке pgsql-patches по дате отправления
От: Tom Lane
Дата:
От: Tom Lane
Дата:
FAQ