mystery disease -- problems creating simple table[s]

From: Frank Miles <fpm(at)u(dot)washington(dot)edu>
To: pgsql-general(at)postgresql(dot)org
Subject: mystery disease -- problems creating simple table[s]
Date: 2000-09-15 23:56:54
Message-ID: Pine.A41.4.21.0009151646060.136268-100000@mead2.u.washington.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have a small database which has been working fine. I just converted
from 6.5.3 to 7.0.2 (Debian/Linux). Used pg_dumpall to restore the contents.
What is strange now is that I can't create new tables without causing
vacuum problems. For example:

CREATE TABLE test_table (
test_id int4,
description text,
PRIMARY KEY(test_id)
);

will cause subsequent vacuums to say:

NOTICE: Index pg_attribute_relid_attnum_index: NUMBER OF INDEX' TUPLES
(564) IS NOT THE SAME AS HEAP' (573).
Recreate the index.
VACUUM.

Unfortunately the next vacuum repeats this same message. Restarting
the postmaster does no good.

'Drop table test_table' will fix things (vacumm stops complaining), but
clearly it's not very good if new tables can't be added.

Any suggestions as to how to diagnose this problem are welcome!

-frank

Browse pgsql-general by date

  From Date Subject
Next Message Jan Wieck 2000-09-16 01:20:48 Re: Linking Postgresql OBDC via C
Previous Message Jim Jennis 2000-09-15 21:24:36 Linking Postgresql OBDC via C