Re: Backend died while dropping index

Поиск
Список
Период
Сортировка
От bangh
Тема Re: Backend died while dropping index
Дата
Msg-id 394A2503.35B2ECA7@baileylink.net
обсуждение исходный текст
Ответ на Backend died while dropping index  (brianb-pgadmin@edsamail.com)
Список pgsql-admin
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


В списке pgsql-admin по дате отправления:

Предыдущее
От: "S.K. Cho"
Дата:
Сообщение: Re: Backend died while dropping index
Следующее
От: "Gagan"
Дата:
Сообщение: