The following bug has been logged online:

Bug reference: 2754
Logged by: Roman Shterenzon
Email address: roman.shterenzon (AT) mobixell (DOT) com
PostgreSQL version: 8.0.3
Operating system: RHEL3
Description: cache lookup failed for function 8470229
Details:

We receive:
"ERROR: cache lookup failed for function 8470229"
When trying to insert into table, or even when doing
\d tablename
in the psql CLI.

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq