Hello! we run on our PostgreSQL instanze a vaccum full and a reindex every night to keep the db fast, our PostgreSQL version is 7.2. It works fine but last night, the indexes were beeing destroyed. A query returned the message:
Index <indexname> is not a btree After dropping all indexes and creating them new everything works fine again. Now my question is: Is this behaviour known? Is it a fixed bug in newer versions? Can you please reply to my emailadress beause I do not have the chance to read the pgsql-admin mailing list all the time. Thanks in advance. We cant upgrade to 7.3 oder newer 7.2.x version so easily because the db must be up all the time. Next time frame for an upgrade may be chrismas... -- Dipl. Inform. Boris Klug, control IT GmbH, Germany ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly