| From: | Jérome Knobl <jknobl(at)mandanet(dot)ch> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | How to recreate index of a pg table |
| Date: | 2000-11-01 08:54:51 |
| Message-ID: | 39FFDA5B.4BA9E74@mandanet.ch |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Hi,
When I make a vacuum on my data base, I have the following NOTICE:
NOTICE: Index pg_attrdef_adrelid_index: NUMBER OF INDEX' TUPLES (36) IS
NOT THE SAME AS HEAP' (34).
Recreate the index.
NOTICE: Index pg_attrdef_adrelid_index: NUMBER OF INDEX' TUPLES (36) IS
NOT THE SAME AS HEAP' (34).
Recreate the index.
I had the same trouble on my own talbe, and to recreate the index, I
drop the index and recreate it.
But with an pg table I have the following message when I try to drop the
index :
ERROR: class "pg_attrdef_adrelid_index" is a system catalog index
How can I recreate my pg_attrdef_adrelid_index?
Thanks.
Best regards, Jérome Knobl, Lausanne, Switzerland
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Eduardo Kotujansky | 2000-11-01 11:51:26 | pg_hba.conf |
| Previous Message | Igor N. Avtaev | 2000-10-31 08:32:44 | FATAL: 1 Memory exhausted in AllocSetAlloc() |