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