Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-patches by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group