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

Re: ALTER TABLE OWNER: change indexes

From: Yury Bokhoncovich <byg(at)center-f1(dot)ru>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
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 09:30:53
Message-ID: Pine.LNX.4.33.0203111527570.5154-100000@panda.center-f1.ru (view raw or flat)
Thread:
Lists: pgsql-patches
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.

Just my two kopecks.

-- 
WBR, Yury Bokhoncovich, Senior System Administrator, NOC of F1 Group.
Phone: +7 (3832) 106228, ext.140, E-mail: byg(at)center-f1(dot)ru(dot)
Unix is like a wigwam -- no Gates, no Windows, and an Apache inside.



In response to

Responses

pgsql-patches by date

Next:From: Bruce MomjianDate: 2002-03-11 15:04:14
Subject: Re: ALTER TABLE OWNER: change indexes
Previous:From: Bruce MomjianDate: 2002-03-11 02:29:29
Subject: Re: ALTER TABLE OWNER: change indexes

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