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