Re: ERROR: cache lookup failed for type - Mailing list pgsql-sql

From Tom Lane
Subject Re: ERROR: cache lookup failed for type
Date
Msg-id 15241.1439781395@sss.pgh.pa.us
Whole thread Raw
In response to ERROR: cache lookup failed for type  (Stuart <sfbarbee@gmail.com>)
Responses Re: ERROR: cache lookup failed for type
List pgsql-sql
Stuart <sfbarbee@gmail.com> writes:
> I have been using a particular function for years without issue but
> recently tried the Alpha releases of PostGreSQL.  I loaded the database
> into 9.5 Alpha1 release and did not have problems. After upgrading to
> Alpha2, I started getting this error on executing the function. I didn't
> reload the database this time as it should not be required.

>     ERROR:  cache lookup failed for type 1082
>     CONTEXT:  compilation of PL/pgSQL function "ds_stats" near line 1

That's odd.

> I dropped the function and can now not add it back to the database.

What happens when you try, exactly?

I assume the error was persistent across multiple sessions?  Have you
changed the schema (rowtype) of table documents_statistics lately?

Does reindexing pg_type make the error go away?  If so, what platform
and filesystem is this on?
        regards, tom lane



pgsql-sql by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: ERROR: cache lookup failed for type
Next
From: Stuart
Date:
Subject: Re: ERROR: cache lookup failed for type