Fixable? cache lookup failed for type - Mailing list pgsql-novice

From Michael Guerin
Subject Fixable? cache lookup failed for type
Date
Msg-id 41CF11DD.20909@rentec.com
Whole thread Raw
List pgsql-novice
db.DbException: select * into temp table t from fnGetCompositeIds2(7164980592);
...
Caused by: org.postgresql.util.PSQLException: ERROR: cache lookup failed for type 2720001893


I'm getting this error in my database and I'm trying to resolve it.  So far, I've re-indexed all tables, clustered all
tables,and recreated all user types and functions.  I'm in the process of doing a pg_dump/restore, although I'd prefer
notto do this since this is going to take most of the day. 

-michael



pgsql-novice by date:

Previous
From: "Iain"
Date:
Subject: Re: [PERFORM] Postgres version change - pg_dump
Next
From: Adam
Date:
Subject: Problems installing on Linux