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, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq