Re: Corrupted table . . . - Mailing list pgsql-novice

From Stephan Szabo
Subject Re: Corrupted table . . .
Date
Msg-id 002901c15096$34171910$014ba8c0@myst.com
Whole thread Raw
In response to Corrupted table . . .  (Robert Mosher <mosher@andrews.edu>)
List 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


pgsql-novice by date:

Previous
From: Robert Mosher
Date:
Subject: Re: Corrupted table
Next
From: Stoffel van Aswegen
Date:
Subject: JDBC ResultSet