Postgres Pro
Downloads
Home   >   mailing lists

Help! ERROR: could not open relation - Mailing list pgsql-general

From Mircea Moisei
Subject Help! ERROR: could not open relation
Date
Msg-id BAY103-W40898DEC0DEB97C9A8F030D5DC0@phx.gbl
Whole thread Raw
In response to Re: status on pgiomonitor  (Martin Marques <martin@marquesminen.com.ar>)
Responses Re: Help! ERROR: could not open relation  (Shane Ambler <pgsql@Sheeky.Biz>)
List pgsql-general
Tree view
I get this strange error

Caused by: org.postgresql.util.PSQLException: ERROR: could not open relation 1663/53544/58374: No such file or directory

How do I recover from it ? Postgresql version 8.2 on windows.

I think I had an hardware issue in the past where my box rebooted few times I assume this is due to that thing.

I tried to re index them but is not working. Any ideas ?

Can one tell how do I start the server in stand alone mode in windows ? I tried via the postgres command but still can't reindex all...

Thanks

pgsql-general by date:

Previous
From: "William Temperley"
Date:
Subject: Re: passing a temporary table with more than one column to a stored procedure
Next
From: seijin@gmail.com
Date:
Subject: String Comparison and NULL