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



---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend