Backend died while dropping index - Mailing list pgsql-admin

From brianb-pgadmin@edsamail.com
Subject Backend died while dropping index
Date
Msg-id 20000616091807.11115.qmail@mail01.edsamail.com.ph
Whole thread Raw
List pgsql-admin
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 or
directory

How do I fix this? This is on 6.5.

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

pgsql-admin by date:

Previous
From: Haroldo Stenger
Date:
Subject: Re: Database replication ?
Next
From: "S.K. Cho"
Date:
Subject: Re: Backend died while dropping index