On Wed, 27 Aug 2003, Tom Lane wrote: > Curt Sampson <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> +81 90 7737 2974 http://www.NetBSD.org Don't you know, in this new Dark Age, we're all light. --XTC ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly