problem when vacuuming. . .

From: JT Kirkpatrick <jt-kirkpatrick(at)mpsllc(dot)com>
To: "'pgsql-admin(at)hub(dot)org'" <pgsql-admin(at)hub(dot)org>, "'pgsql-sql(at)hub(dot)org'" <pgsql-sql(at)hub(dot)org>, "'pgsql-general(at)hub(dot)org'" <pgsql-general(at)hub(dot)org>, "'pgsql-interfaces(at)hub(dot)org'" <pgsql-interfaces(at)hub(dot)org>
Subject: problem when vacuuming. . .
Date: 1999-04-19 22:24:16
Message-ID: 01BE8A7D.00789480.jt-kirkpatrick@mpsllc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-interfaces pgsql-sql

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Max 1999-04-20 00:07:12
Previous Message Oleg Broytmann 1999-04-19 13:35:38 Re: [GENERAL] Questions about libpq!

Browse pgsql-interfaces by date

  From Date Subject
Next Message Screech 1999-04-20 00:07:42 Re: [INTERFACES] where did that date and time come from??
Previous Message Sergio A. Kessler 1999-04-19 17:31:42 Re: [INTERFACES] Delphi TDataset

Browse pgsql-sql by date

  From Date Subject
Next Message Screech 1999-04-20 00:07:42 Re: [INTERFACES] where did that date and time come from??
Previous Message Brian 1999-04-19 21:35:02 Re: [SQL] VACUUM in a trigger