Postgres Pro
Downloads
Home   >   mailing lists

Re: FATAL: could not open relation xxx: No such file or directory - Mailing list pgsql-admin

From Pavan Deolasee
Subject Re: FATAL: could not open relation xxx: No such file or directory
Date
Msg-id 2e78013d0804170336j4299161bm3f280fc9b930b474@mail.gmail.com
Whole thread Raw
In response to Re: FATAL: could not open relation xxx: No such file or directory  ("Mikko Partio" <mpartio@gmail.com>)
Responses Re: FATAL: could not open relation xxx: No such file or directory  ("Mikko Partio" <mpartio@gmail.com>)
List pgsql-admin
Tree view 
On Thu, Apr 17, 2008 at 3:38 PM, Mikko Partio <mpartio@gmail.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

pgsql-admin by date:

Previous
From: "Mikko Partio"
Date:
Subject: Re: FATAL: could not open relation xxx: No such file or directory
Next
From: "Mikko Partio"
Date:
Subject: Re: FATAL: could not open relation xxx: No such file or directory