On Wed, May 7, 2008 at 1:50 PM, Zdenek Kotala <[EMAIL PROTECTED]> wrote:
> Q Master napsal(a): > > > 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 ? 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 ? > > > > > 2) get table name (connect to affected database) > > select * from pg_class where oid=58374 > The query should be select * from pg_class where relfienode = 58374 Best regards -- [EMAIL PROTECTED] [EMAIL PROTECTED] gmail | hotmail | indiatimes | yahoo }.com EnterpriseDB http://www.enterprisedb.com Mail sent from my BlackLaptop device