Thread: Backend died while dropping index

Backend died while dropping index

From
brianb-pgadmin@edsamail.com
Date:
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

Re: Backend died while dropping index

From
"S.K. Cho"
Date:
 Hello everone!

i am useing postgreSQL just beginning, I don't known How to Setup about
"crypt"
when i had select
    host  all     127.0.0.1  55.255.255.0  crypt
in pg_hba.conf.

help me please!

thanks

Cho


Re: Backend died while dropping index

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

vacuum user_usage;

--
Bangh

brianb-pgadmin@edsamail.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@edsamail.com>
> http://www.baquiran.com/
> AIM: bbaquiran