Fixable? cache lookup failed for type

From: Michael Guerin <guerin(at)rentec(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Fixable? cache lookup failed for type
Date: 2004-12-26 19:32:45
Message-ID: 41CF11DD.20909@rentec.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 not to do this since this is going to take most of the day.

-michael

Browse pgsql-novice by date

  From Date Subject
Next Message Adam 2004-12-27 16:33:22 Problems installing on Linux
Previous Message brew 2004-12-24 07:09:43 Re: Front end?