Re: The Contrib Roundup (long)

On Sat, 11 Jun 2005, Tom Lane wrote:

> Bruce Momjian <pgman@candle.pha.pa.us> writes:
>> Kaare Rasmussen wrote:
>>> I consider this a bug, or at least a badly thought out name. I can't
>>> understand that someone approved 'reindex database' to mean 'reindex the
>>> system tables of a database'.
>
>> Agreed.
>
> 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 ..

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