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 <[EMAIL PROTECTED]>
http://www.baquiran.com/
AIM: bbaquiran

Reply via email to