From: | bangh <banghe(at)baileylink(dot)net> |
---|---|
To: | brianb-pgadmin(at)edsamail(dot)com |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Backend died while dropping index |
Date: | 2000-06-16 13:00:52 |
Message-ID: | 394A2503.35B2ECA7@baileylink.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(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
From | Date | Subject | |
---|---|---|---|
Next Message | Bruno Madeiro da Silva | 2000-06-16 18:59:42 | Installation |
Previous Message | Stefan Muehlebach | 2000-06-16 12:52:57 | Preventing users from creating tables in certain dbs. |