| 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: | Whole Thread | Raw Message | 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
| 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! |
| 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 |
| 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 |