Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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



pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group