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  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: ALTER TABLE OWNER: change indexes  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-patches
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
Дата:
Сообщение: Re: ALTER TABLE OWNER: change indexes
Следующее
От: Tom Lane
Дата:
Сообщение: Re: ALTER TABLE OWNER: change indexes