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

From strk
Subject ERROR: Index pg_toast_8443892_index is not a btree
Date
Msg-id 20031208104009.A55237@freek.keybit.net
Whole thread Raw
Responses Re: ERROR: Index pg_toast_8443892_index is not a btree  (Jan Wieck <JanWieck@Yahoo.com>)
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 ?).

After that, I put the insert query I was trying to feed to
psql in a file and sourced it... Bump! that error appeared.
psql:B:477: ERROR:  Index pg_toast_8443892_index is not a btree

Line 477 is EOF...

Vacuum does not solve this (as you can see in the first error message)

Do you have any hint about how to fix this ? 


TIA

--strk;


pgsql-hackers by date:

Previous
From: Tatsuo Ishii
Date:
Subject: Re: aggregate + view + alias crash on 7.4 stable
Next
From: Abhijit Menon-Sen
Date:
Subject: Re: Double linked list with one pointer