On Wed, 27 Aug 2003, Tom Lane wrote:
> Curt Sampson <cjs@cynic.net> writes:
> > While we're at it, anybody got a clue on how to reindex system tables?
> The procedure given in the REINDEX reference page doesn't work for you?
You mean with the standalone backend? All the other developers get
pissed at me when I take down the database cluster. :-) Heck, I get
pissed at me because some other thing I was running in the background
goes and blows up.
I'm not actually sure why there would be a problem (aside from
performance) in removing and rebuilding an index on a system table,
unless there are cached query plans somewhere that would try to use
the old or now-nonexistent index.
cjs
--
Curt Sampson <cjs@cynic.net> +81 90 7737 2974 http://www.NetBSD.org
Don't you know, in this new Dark Age, we're all light. --XTC