The following bug has been logged online:

Bug reference: 2506
Logged by: Wagner Cipriano
Email address: wagner@2xt.com.br
PostgreSQL version: 8.0
Operating system: Linus Suse 10
Description: hash index
Details:

Error: index "xxx" is not a hash index.
Always this error happen with me.
Can You help me ?
Thanks!

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

"Wagner Cipriano" <wagner@2xt.com.br> writes:
> Error: index "xxx" is not a hash index.
> Always this error happen with me.

You haven't provided enough information to let anyone help you ...
but if you mean that you've got a corrupt index, REINDEXing it
should fix that.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings