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 tablesREINDEX DATABASE
->both of the above
regards, tom lane
