Postgres Pro
Downloads
Home   >   mailing lists

index file corrupted - Mailing list pgsql-general

From Wenzhe Zhou
Subject index file corrupted
Date
Msg-id 4.3.2.7.2.20030421193111.023deef0@mira-sjc5-6.cisco.com
Whole thread Raw
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: > 16TB worth of data question
Next
From: "Jim C. Nasby"
Date:
Subject: Re: Case sensitive order by