Re: ALTER TABLE OWNER: change indexes

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.