Re: FATAL: could not open relation xxx: No such file or directory

From: "Pavan Deolasee" <pavan(dot)deolasee(at)gmail(dot)com>
To: "Mikko Partio" <mpartio(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: FATAL: could not open relation xxx: No such file or directory
Date: 2008-04-17 10:36:00
Message-ID: 2e78013d0804170336j4299161bm3f280fc9b930b474@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Thu, Apr 17, 2008 at 3:38 PM, Mikko Partio <mpartio(at)gmail(dot)com> wrote:

>
> 2008-04-17 13:05:30 EEST [8435]: [32-1] ERROR: could not open relation
> 1663/16386/359232: No such file or directory
>

Looks like a corrupt index to me. DId you try REINDEX on the table ?

Thanks,
Pavan

--
Pavan Deolasee
EnterpriseDB http://www.enterprisedb.com

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Mikko Partio 2008-04-17 10:44:22 Re: FATAL: could not open relation xxx: No such file or directory
Previous Message Mikko Partio 2008-04-17 10:08:58 Re: FATAL: could not open relation xxx: No such file or directory