Re: ALTER TABLE OWNER: change indexes

Yury Bokhoncovich wrote:
> 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.

Can you explain the advantages?  We don't allow that currently.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026