Re: Corrupted table . . .

From: "Stephan Szabo" <acroyear_07030(at)yahoo(dot)com>
To: "Robert Mosher" <mosher(at)andrews(dot)edu>, "Mailing List Postgresql" <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Corrupted table . . .
Date: 2001-10-09 07:44:16
Message-ID: 002901c15096$34171910$014ba8c0@myst.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

> Ok. I did some poking around where postgres sticks the databases, and
> noticed that, yes, my table (info) does not exist in it's databases
> directory. However there is an infoold file. Could I move/copy the
> infoold file to info, so that when I tried to access info, there would be
> something to access. Or could I just 'touch info' giving psql something
> to delete, and then delete the table?
>
> Or are these all just bad ideas that are likely to wreak havoc?

Well, on a more recent version I've had success on just touching the correct
file, so I would think that'd work for you to get you into a state where you
could
deal with the table.

_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Stoffel van Aswegen 2001-10-09 09:30:55 JDBC ResultSet
Previous Message Robert Mosher 2001-10-09 04:29:23 Re: Corrupted table