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