Yury Bokhoncovich wrote:
> 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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
In response to
pgsql-patches by date
|Next:||From: Bruce Momjian||Date: 2002-03-11 16:48:29|
|Subject: Re: IPv6 Support for INET/CIDR types.|
|Previous:||From: Yury Bokhoncovich||Date: 2002-03-11 09:30:53|
|Subject: Re: ALTER TABLE OWNER: change indexes|