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 3FD52A7A.3060108@familyhealth.com.au
Whole thread Raw
In response to Re: ERROR: Index pg_toast_8443892_index is not a btree  (strk <strk@keybit.net>)
Responses Re: ERROR: Index pg_toast_8443892_index is not a btree
List pgsql-hackers
>>>I get the following error when vacuuming a db or inserting
>>>a big value in a column of a toastable datatype (GEOMETRY).
>>>
>>>    ERROR:  Index pg_toast_8443892_index is not a btree
>>>
>>>My last action has been killing a psql that was getting
>>>mad about receiving too much input and beeping as hell
>>>(readline issue ?).

Is there anything stopping us going through the code and finding all 
ereports that can be fixed by a REINDEX, and issue a HINT with all of 
them saying that they should REINDEX the broken index?

That would seem to me to be really helpful for people.

Chris



pgsql-hackers by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Re: Release cycle length
Next
From: Tom Lane
Date:
Subject: Re: ERROR: Index pg_toast_8443892_index is not a btree