Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql General > ERROR: could no...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 4 Topic 15477 of 15975
Post > Topic >>

ERROR: could not open relation

by theqmaster@[EMAIL PROTECTED] (Q Master) May 6, 2008 at 09:53 PM

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 ?

Thanks
Q

Ps.

I tried to start the server in stand alone and reindex all (used the -P 
command to disable the indexed but it didn't work) any ideas ?


-- 
Sent via pgsql-general mailing list (pgsql-general@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general




 4 Posts in Topic:
ERROR: could not open relation
theqmaster@[EMAIL PROTECT  2008-05-06 21:53:05 
Re: ERROR: could not open relation
Zdenek.Kotala@[EMAIL PROT  2008-05-07 10:20:55 
Re: ERROR: could not open relation
singh.gurjeet@[EMAIL PROT  2008-05-07 14:14:34 
Re: ERROR: could not open relation
Zdenek.Kotala@[EMAIL PROT  2008-05-07 11:45:02 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan13V112 Fri Jul 4 9:39:54 CDT 2008.