cache lookup for operator ...

Hello,

I am trying to determine what might cause an issue like this. This was a
large (several hundred GB) data warehouse server with PG 8.2.4. I can't
really determine what caused this issue. We ended up restoring the data
from a backup.

Here are some of the errors in the log:

postmaster.1:Jul 11 14:13:36 postgres[18051]: [8-1] ERROR: cache lookup
failed for operator 660

postmaster.1:Jul 11 15:27:00 postgres[26428]: [2-1] ERROR: cache lookup
failed for operator 93

Attempting to list the tables using psql:

#\dt

ERROR: operator does not exist: oid = oid

LINE 6: JOIN pg_catalog.pg_roles r ON r.oid = c.relowner

^

HINT: No operator matches the given name and argument type(s). You may need
to add explicit type casts.

Deron