Re: ALTER TABLE OWNER: change indexes - Mailing list pgsql-patches

From Yury Bokhoncovich
Subject Re: ALTER TABLE OWNER: change indexes
Date
Msg-id Pine.LNX.4.33.0203111527570.5154-100000@panda.center-f1.ru
Whole thread Raw
In response to Re: ALTER TABLE OWNER: change indexes  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: ALTER TABLE OWNER: change indexes
List 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 by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: ALTER TABLE OWNER: change indexes
Next
From: Bruce Momjian
Date:
Subject: Re: ALTER TABLE OWNER: change indexes