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
I like that.
-- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610)
359-1001+ If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square,
Pennsylvania19073
