Re: ERROR: Index pg_toast_8443892_index is not a btree

strk wrote:

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

You must have killed a lot more than your psql frontend to get that as a 
result.

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

Try "reindex table <tablename>". If you really only lost that btree 
index, that should do.


Jan

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