index file corrupted

From: Wenzhe Zhou <wzhou(at)cisco(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: index file corrupted
Date: 2003-04-22 02:36:57
Message-ID: 4.3.2.7.2.20030421193111.023deef0@mira-sjc5-6.cisco.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Browse pgsql-general by date

  From Date Subject
Next Message Jim C. Nasby 2003-04-22 07:02:27 Re: Case sensitive order by
Previous Message Tom Lane 2003-04-22 01:43:10 Re: > 16TB worth of data question