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