get me off this list please
От | Oelkers, Phil |
---|---|
Тема | get me off this list please |
Дата | |
Msg-id | F5F5D222CD70D111886C00805FE69D21024483E2@schexch1 обсуждение исходный текст |
Список | pgsql-general |
-----Original Message----- From: Brook Milligan [mailto:brook@biology.nmsu.edu] Sent: Tuesday, October 24, 2000 4:05 PM To: pgsql-general@postgresql.org Subject: [GENERAL] index problems I am getting the following messages when I VACUUM ANALYZE: NOTICE: Index pg_attribute_relid_attnum_index: NUMBER OF INDEX' TUPLES (3579) IS NOT THE SAME AS HEAP' (4517). Recreate the index. NOTICE: Index pg_attribute_relid_attnam_index: NUMBER OF INDEX' TUPLES (3579) IS NOT THE SAME AS HEAP' (4517). Recreate the index. How do I recreate these indexes? Is this a symptom of greater problems? I notice in src/backend/local1_template1.bki.source the following lines: declare unique index pg_attribute_relid_attnam_index on pg_attribute using btree(attrelid oid_ops, attname name_ops) declare unique index pg_attribute_relid_attnum_index on pg_attribute using btree(attrelid oid_ops, attnum int2_ops) I presume these must be related to what I need to do, but I'm not sure how to make use of this information (or even if I'm right). Should I translate these into CREATE UNIQUE INDEX ... statements? Thanks for the help. Cheers, Brook
В списке pgsql-general по дате отправления: