Backend died while dropping index - Mailing list pgsql-general

The backend died while I was dropping an index on a table. Now I cannot
access my data! Help!

My table looks like

create table user_usage (email varchar(100),date date);

I created the index:
CREATE INDEX user_usage_email_idx on user_usage(email);

When I dropped the index, the backend died. Now whenever I try to do an
insert I get:

ERROR:  mdopen: couldn't open user_usage_email_idx: No such file
ordirectory

How do I fix this? This is on 6.5.

Thanks,
Brian
--
Brian Baquiran <brianb@edsamail.com>
http://www.baquiran.com/
AIM: bbaquiran