Re: ERROR: could not open relation

------=_Part_29593_27694247.1210149874557
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

On Wed, May 7, 2008 at 1:50 PM, Zdenek Kotala <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
-- 
gurjeet[.singh]@[EMAIL PROTECTED]
 gmail | hotmail | indiatimes | yahoo }.com

EnterpriseDB http://www.enterprisedb.com

Mail sent from my BlackLaptop device

------=_Part_29593_27694247.1210149874557
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

On Wed, May 7, 2008 at 1:50 PM, Zdenek Kotala &lt;<a
href="mailto:Zdenek.Kotala@[EMAIL PROTECTED]
">Zdenek.Kotala@[EMAIL PROTECTED]
>&gt;
wrote:<br><div class="gmail_quote"><blockquote class="gmail_quote"
style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt
0.8ex; padding-left: 1ex;">
Q Master napsal(a):<div class="Ih2E3d"><br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204,
204, 204); padding-left: 1ex;">
I get this strange error<br>
<br>
Caused by: org.postgresql.util.PSQLException: ERROR: could not open
relation 1663/53544/58374: No such file or directory<br>
<br>
How do I recover from it ? Version 8.2 on windows.<br>
<br>
I think I had an hardware issue in the past where my box rebooted few
times I assume this is due to that thing.<br>
<br>
I tried to re index them but is not working. Any ideas ?<br>
<br>
</blockquote>
<br></div>2) get table name (connect to affected database)<br>
<br>
select * from pg_class where oid=58374<br></blockquote></div><br>The query
should be<br><br>select * from pg_class where relfienode = 58374<br
clear="all"><br>Best regards<br>--
<br>gurjeet[.singh]@[EMAIL PROTECTED]
>singh.gurjeet@[EMAIL PROTECTED]
 gmail | hotmail |
indiatimes | yahoo }.com<br>
<br>EnterpriseDB <a
href="http://www.enterprisedb.com">http://www.enterprisedb.com</a><br><br>Mail
sent from my BlackLaptop device

------=_Part_29593_27694247.1210149874557--