Обсуждение: 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,
Pennsylvania19073
 

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