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 SAA32589; Mon, 19 Apr 1999 18:21:50 -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 RAA26702; Mon, 19 Apr 1999 17:37:12 -0400 Received: by localhost with Microsoft MAPI; Mon, 19 Apr 1999 18:24:17 -0400 Message-ID: <01BE8A7D.00789480.jt-kirkpatrick@mpsllc.com> From: JT Kirkpatrick To: "'pgsql-admin@hub.org'" , "'pgsql-sql@hub.org'" , "'pgsql-general@hub.org'" , "'pgsql-interfaces@hub.org'" Subject: problem when vacuuming. . . Date: Mon, 19 Apr 1999 18:24:16 -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 When I vacuum I get two 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 had followed some advice I read in one of these postgres mailing lists (from this weekend) regarding case problems when transferring from access97, and I executed both of those updates. I can't find them now, nor can I remember them, but they replaced certain values in the tables corresponding to the indexes above with the lowercase equivalent of those values. I'd like to try to reverse the effect - does anyone have a copy of that email from sometime this weekend? jt