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

From Bruce Momjian
Subject Re: ALTER TABLE OWNER: change indexes
Date
Msg-id 200203111504.g2BF4EV03743@candle.pha.pa.us
Whole thread Raw
In response to Re: ALTER TABLE OWNER: change indexes  (Yury Bokhoncovich <byg@center-f1.ru>)
Responses Re: ALTER TABLE OWNER: change indexes
List pgsql-patches
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

pgsql-patches by date:

Previous
From: Yury Bokhoncovich
Date:
Subject: Re: ALTER TABLE OWNER: change indexes
Next
From: Bruce Momjian
Date:
Subject: Re: IPv6 Support for INET/CIDR types.