Re: Cause of ERROR: could not open relation

"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.

regards, tom lane