Re: The Contrib Roundup (long)

On Sun, 12 Jun 2005, Tom Lane wrote:

> "Marc G. Fournier" <scrappy@postgresql.org> writes:
>> On Sat, 11 Jun 2005, Tom Lane wrote:
>>> It's always bothered me too.  How about
>>>
>>> REINDEX SYSTEM -> system tables (current meaning of R. DATABASE)
>>> REINDEX USER -> all non-system tables
>>> REINDEX DATABASE -> both of the above
>
>> Why all the choices?  What cases are there for doing one without the
>> other?  If you want to get 'fine tuned', do a 'REINDEX TABLE' ... I can
>> see REINDEX SYSTEM and REINDEX DATABASE (includes SYSTEM), but not the
>> USER one ..
>
> The main argument I can think of for REINDEX USER is that it could be
> executed by someone who isn't necessarily superuser.  Not sure how
> important that is, though.

Couldn't behaviour of REINDEX DATABASE not take that into account, and 
'skip' the system indices if not superuser?

----
Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
Email: scrappy@hub.org           Yahoo!: yscrappy              ICQ: 7615664