One of my index file is corrupted, that cause insertion failed when insert record to the table with error message "ERROR: Index pk_mytest is not a btree". After reindex, everything is fine.
My question is how this happen? Is there any way to prevent it happen? Is there any tool to detect the corrupted data file?
I run Postgres 7.2.4 on Linux.
Thanks in advance.
Wenzhe