[EMAIL PROTECTED] (Martijn van Oosterhout) writes: > On Tue, Dec 14, 2004 at 05:15:08PM -0800, Tim Vadnais wrote: >> I tried to rebuild the two indexes and got the following error. The >> optional FORCE has no effect on the output. >> >> bwks=# reindex index pg_database_oid_index; >> ERROR: shared index "pg_database_oid_index" can only be reindexed in >> stand-alone mode > > How difficult would it be for the system to notice this and tag the > index as "to be reindexed". Then, the next time the system is started > up, it can reindexed before starting to accept connections. > > It would at least simplify the help in this case to "restart the server > to do the reindexing".
Part of me wants to ask for the feature: "On restart, always re-index all system tables..." There are, alas, pathological cases where that wouldn't turn out well... -- "cbbrowne","@","ca.afilias.info" <http://dev6.int.libertyrms.com/> Christopher Browne (416) 673-4124 (land) ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
