Re: Cause of ERROR: could not open relation

Tom Lane wrote:
> "Wyatt Tellis" <wtellis(at)radiology(dot)ucsf(dot)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
>
>> Is there a command or way to determine if an index is corrupt? Is there
>> anyway to discern this info from the error message itself (i.e. are the
>> numbers a pointer to a specific index)?
>
> 856689 references a database OID (try "select datname from pg_database
> where oid = 856689") and then 856777 is a relfilenode (in that database,
> do "select relname from pg_class where relfilenode = 856777").
>
> As for what "Invalid argument" on a file open might mean, my personal
> advice is to get a real operating system. W2K is by far the weakest
> link in your platform.

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

-Wyatt