Postgres Pro
Downloads
Home   >   mailing lists

Re: Cause of ERROR: could not open relation - Mailing list pgsql-general

From Tom Lane
Subject Re: Cause of ERROR: could not open relation
Date
Msg-id 25328.1159885662@sss.pgh.pa.us
Whole thread Raw
In response to Re: Cause of ERROR: could not open relation  ("Wyatt Tellis" <wtellis@radiology.ucsf.edu>)
List pgsql-general
Tree view 
"Wyatt Tellis" <wtellis@radiology.ucsf.edu> writes:
>>> I'm running 8.1.4 on W2K3 R2. I occasionally get errors of the type:
>>> ERROR: could not open relation 1663/856689/856777: Invalid argument

> I was able to figure out the table name, but is there a way to figure
> out which file caused this error?

Huh?  That *is* the filename.  See
http://www.postgresql.org/docs/8.1/static/storage.html

            regards, tom lane

pgsql-general by date:

Previous
From: km
Date:
Subject: postgresql.conf shared buffers
Next
From: Ritesh Nadhani
Date:
Subject: Text retrieval & data mining features in PostgreSQL