Received: from s20.highertech.net (root@s20.highertech.net [209.54.120.20]) by hub.org (8.9.3/8.9.1) with ESMTP id OAA90792; Tue, 20 Apr 1999 14:56:28 -0400 (EDT) (envelope-from jt-kirkpatrick@mpsllc.com) Received: from kirkpatrickjt (whiteoak-34.highertech.net [209.140.56.34] (may be forged)) by s20.highertech.net (8.8.6/8.8.6) with SMTP id OAA21453; Tue, 20 Apr 1999 14:11:44 -0400 Received: by localhost with Microsoft MAPI; Tue, 20 Apr 1999 14:58:49 -0400 Message-ID: <01BE8B3E.4C03C020.jt-kirkpatrick@mpsllc.com> From: JT Kirkpatrick To: "'pgsql-sql@hub.org'" , "'pgsql-interfaces@hub.org'" , "'pgsql-general@hub.org'" , "'pgsql-admin@hub.org'" , "'pgsql-hackers@hub.org'" Subject: TUPLES <> HEAP Date: Tue, 20 Apr 1999 14:58:48 -0400 Organization: MPS, LLC X-Mailer: Microsoft Internet E-mail/MAPI - 8.0.0.4211 MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Hi all. Head hanging a little low, even though system still seems to work fine. Here is what I did: - update pg_class set relname = lower(relname); - update pg_attribute set attname = lower(attname); - (why did I do that? Following something I read, not really having problems in the first place and not really knowing the effects). Now when I vacuum I get the error messages: NOTICE: Index pg_class_relname_index: NUMBER OF INDEX' TUPLES (108) IS NOT THE SAME AS HEAP' (82) NOTICE: Index pg_class_oid_index: NUMBER OF INDEX' TUPLES (108) IS NOT THE SAME AS HEAP' (82) I'd like to drop these indexes and re-create them, hoping that would solve the problem. But I tried to drop them and postgres wouldn't let me - claiming they were system catalog indexes. Would dropping and recreating the indexes get rid of the error messages? If so, how can I drop them and what is the proper way to recreate them? Newbie mistakes aren't much fun. Thanks for helping. . . jt