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