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

From Jan Wieck
Subject Re: ERROR: Index pg_toast_8443892_index is not a btree
Date
Msg-id 3FD674AB.5070707@Yahoo.com
Whole thread Raw
In response to Re: ERROR: Index pg_toast_8443892_index is not a btree  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
Responses Re: ERROR: Index pg_toast_8443892_index is not a btree
Re: ERROR: Index pg_toast_8443892_index is not a btree
List pgsql-hackers
Christopher Kings-Lynne wrote:

>> 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.

I know, that's (unfortunately) true. Although it's not very farsighted 
because better bug reports usually lead to better software in the next 
release.


Jan

-- 
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #



pgsql-hackers by date:

Previous
From: Christopher Kings-Lynne
Date:
Subject: Re: ERROR: Index pg_toast_8443892_index is not a btree
Next
From: Teodor Sigaev
Date:
Subject: Re: Searching for substring with tsearch(1/2)