Re: "could not open file" issue - Mailing list pgsql-sql

From Daniel Caune
Subject Re: "could not open file" issue
Date
Msg-id 1E293D3FF63A3740B10AD5AAD88535D20213299C@UBIMAIL1.ubisoft.org
Whole thread Raw
In response to "could not open file" issue  ("Daniel Caune" <daniel.caune@ubisoft.com>)
Responses Re: "could not open file" issue  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-sql

> De : pgsql-sql-owner@postgresql.org [mailto:pgsql-sql-
> owner@postgresql.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
alsopassed).  Then I created the table.  I'm not sure that it fixes my problem.  I modified my fstab file so that Linux
checksmy file system's health on the next boot. 

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


pgsql-sql by date:

Previous
From: "Daniel Caune"
Date:
Subject: Re: "could not open file" issue
Next
From: Alvaro Herrera
Date:
Subject: Re: "could not open file" issue