Re: ERROR: Index pg_toast_8443892_index is not a btree - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject Re: ERROR: Index pg_toast_8443892_index is not a btree
Date
Msg-id 3FD67FE5.5060501@familyhealth.com.au
Whole thread Raw
In response to Re: ERROR: Index pg_toast_8443892_index is not a btree  (Jan Wieck <JanWieck@Yahoo.com>)
Responses Re: ERROR: Index pg_toast_8443892_index is not a btree  (Jan Wieck <JanWieck@Yahoo.com>)
List pgsql-hackers
> I couldn't agree more. Look at this very instance. He now found the 
> right reindex command and the corrupted file is gone. We don't have the 
> slightest clue what happened to that file. Was it truncated? Did some 
> other process scribble around in the shared memory? How do you tell now?

The end user just could not care less.  They want their machine running 
again as soon as is humanly possible without going through a back and 
forth process of subscribing to some lists they don't care about, etc.

Chris



pgsql-hackers by date:

Previous
From: Dave Cramer
Date:
Subject: Re: PostgreSQL port to pure Java?
Next
From: Jan Wieck
Date:
Subject: Re: ERROR: Index pg_toast_8443892_index is not a btree