| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2002-03-11 15:04:14 | Re: ALTER TABLE OWNER: change indexes |
| Previous Message | Bruce Momjian | 2002-03-11 02:29:29 | Re: ALTER TABLE OWNER: change indexes |