Re: ALTER TABLE OWNER: change indexes

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Yury Bokhoncovich <byg(at)center-f1(dot)ru>
Cc: PostgreSQL-patches <pgsql-patches(at)postgresql(dot)org>, Peter Eisentraut <peter_e(at)gmx(dot)net>, Neil Conway <nconway(at)klamath(dot)dyndns(dot)org>
Subject: Re: ALTER TABLE OWNER: change indexes
Date: 2002-03-11 15:04:14
Message-ID: 200203111504.g2BF4EV03743@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(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

Responses

Browse pgsql-patches by date

  From Date Subject
Next Message Bruce Momjian 2002-03-11 16:48:29 Re: IPv6 Support for INET/CIDR types.
Previous Message Yury Bokhoncovich 2002-03-11 09:30:53 Re: ALTER TABLE OWNER: change indexes