you should reply to the list, not only to single posters.
this way, more people see your reply,and can help you.
Putting the list back, and quoting whole message.
On lau, 2006-12-30 at 15:17 +0530, karthik nandagiri wrote:
> hello ragnar,
> i am using postgresql version8.0. it is installed on debean linux 2.2
> we have intalled dspace on that system.and its a live website running
> since 2003.
> we have nearly 2055 fulltext records loaded on this server.
> since 4 months the application was not running properly so we made a
> research of the problem .
> then we came to know that a table named item2bundle is not getting
> the Query i executed was
> dspace=# select * from item2bundle;
> after pressing enteri get the below error
> Error:Could not open relation "item2bundle". no such file or
> i am not able to retrieve records from table.
it looks to me that you have experienced corruption, and some files may
be missing in the data directory.
you can check it yourself:
your data directory might be something like
this will contain a subdirectory base/
which will contain a directory for each of our databases
to get the directory name for database "dspace", do:
select oid from pg_database where datname='dspace';
this database directory will contain several files. to
find the file(s) making upa particular table do:
select relfilenode from pg_class
hope this helps you investigate this.
In response to
pgsql-general by date
|Next:||From: novnov||Date: 2006-12-30 18:33:01|
|Subject: Generic timestamp function for updates where field names vary|
|Previous:||From: Raymond O'Donnell||Date: 2006-12-30 16:31:48|
|Subject: Re: How to use Php connecting to pgsql |