Re: ERROR: Index pg_toast_8443892_index is not a btree

From: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
To: strk <strk(at)keybit(dot)net>
Cc: Jan Wieck <JanWieck(at)Yahoo(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: ERROR: Index pg_toast_8443892_index is not a btree
Date: 2003-12-09 01:50:50
Message-ID: 3FD52A7A.3060108@familyhealth.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2003-12-09 02:05:37 Re: ERROR: Index pg_toast_8443892_index is not a btree
Previous Message Jim C. Nasby 2003-12-09 00:49:31 Re: Release cycle length