Re: "could not open file" issue

From: "Daniel Caune" <daniel(dot)caune(at)ubisoft(dot)com>
To: "Andrew Sullivan" <ajs(at)crankycanuck(dot)ca>, <pgsql-sql(at)postgresql(dot)org>
Subject: Re: "could not open file" issue
Date: 2006-04-24 21:02:37
Message-ID: 1E293D3FF63A3740B10AD5AAD88535D20213299C@UBIMAIL1.ubisoft.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

> De : pgsql-sql-owner(at)postgresql(dot)org [mailto:pgsql-sql-
> owner(at)postgresql(dot)org] De la part de Andrew Sullivan
>
> On Mon, Apr 24, 2006 at 12:17:07PM -0400, Daniel Caune wrote:
> > Hi,
> >
> > Is there any way to solve the following issue without dropping the
> > table?
>
> I doubt you'll be able to drop the table. I think you have some sort
> of corruption. Assuming your hardware is good, you maybe oughta take
> this over to -general to see if the wizards can identify your
> problem. (But check your hardware first.)
>

It seems that was possible: I tried first to truncate the table (it passed), and finally I tried to drop the table (it also passed). Then I created the table. I'm not sure that it fixes my problem. I modified my fstab file so that Linux checks my file system's health on the next boot.

>
> --
> Andrew Sullivan | ajs(at)crankycanuck(dot)ca
> "The year's penultimate month" is not in truth a good way of saying
> November.
> --H.W. Fowler

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Alvaro Herrera 2006-04-24 21:40:07 Re: "could not open file" issue
Previous Message Daniel Caune 2006-04-24 20:38:06 Re: "could not open file" issue