Re: ALTER TABLE OWNER: change indexes

Поиск
Список
Период
Сортировка
От Yury Bokhoncovich
Тема Re: ALTER TABLE OWNER: change indexes
Дата
Msg-id Pine.LNX.4.33.0203111527570.5154-100000@panda.center-f1.ru
обсуждение исходный текст
Ответ на Re: ALTER TABLE OWNER: change indexes  (Bruce Momjian <pgman@candle.pha.pa.us>)
Ответы Re: ALTER TABLE OWNER: change indexes  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список pgsql-patches
Hello!

On Sun, 10 Mar 2002, Bruce Momjian wrote:

>
> Actually, more to the point, the table owner does own the indexes.  I
> know that is is always true, but if someone is spinning through pg_class
> and wants to find everything owned by a specific person, without joining
> to pg_index, keeping the user id correct on indexes is helpful.

Sometimes it is very useful to have one owner on a table and another owner
on indices of that table (all from real life).

BTW, compare with MySQL privileges to manage index/indices.

Just my two kopecks.

--
WBR, Yury Bokhoncovich, Senior System Administrator, NOC of F1 Group.
Phone: +7 (3832) 106228, ext.140, E-mail: byg@center-f1.ru.
Unix is like a wigwam -- no Gates, no Windows, and an Apache inside.



В списке pgsql-patches по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: ALTER TABLE OWNER: change indexes
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: ALTER TABLE OWNER: change indexes