Re: Backend died while dropping index

You may try to vacuum your table, sometimes this will help to fix this kind
of problems.

vacuum user_usage;

--
Bangh

brianb-pgadmin(at)edsamail(dot)com wrote:

> 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(at)edsamail(dot)com>
> http://www.baquiran.com/
> AIM: bbaquiran