reindex of toast tables
Tom, when you loosened the restriction on reindexing toast tables, did
you continue to restrict indexing of system tables to the superuser? Is
that required?
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
Bruce Momjian <pgman@candle.pha.pa.us> writes:
Tom, when you loosened the restriction on reindexing toast tables, did
you continue to restrict indexing of system tables to the superuser? Is
that required?
Hm. Now that I look at it, the forms REINDEX TABLE and REINDEX INDEX
don't seem to have any permissions checks at all :-(. One would think
that they need to require ownership rights on the target table.
regards, tom lane
Tom Lane dijo:
Hm. Now that I look at it, the forms REINDEX TABLE and REINDEX INDEX
don't seem to have any permissions checks at all :-(. One would think
that they need to require ownership rights on the target table.
They are done in tcop/utility.c AFAICS.
--
Alvaro Herrera (<alvherre[a]atentus.com>)
"Cuando ma�ana llegue pelearemos segun lo que ma�ana exija" (Mowgli)
Alvaro Herrera <alvherre@atentus.com> writes:
Tom Lane dijo:
Hm. Now that I look at it, the forms REINDEX TABLE and REINDEX INDEX
don't seem to have any permissions checks at all :-(. One would think
that they need to require ownership rights on the target table.
They are done in tcop/utility.c AFAICS.
Oh, right. I was just looking at the catalog/index routines. Nevermind...
regards, tom lane