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

From Stuart
Subject Re: ERROR: cache lookup failed for type
Date
Msg-id 55D15A62.70406@gmail.com
Whole thread Raw
In response to Re: ERROR: cache lookup failed for type  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: ERROR: cache lookup failed for type  (Stuart <sfbarbee@gmail.com>)
Re: ERROR: cache lookup failed for type  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-sql
Adrian, Tom,
  I reloaded the database and the problem doesn't happen anymore.
Thanks for the suggestion.

Tom - to answer your questions,

On 08/17/2015 07:16 AM, Tom Lane wrote:
>> I dropped the function and can now not add it back to the database.
> 
> What happens when you try, exactly?

The same error occurred

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

No there were no changes to the table schema.  All dbase objects were
loaded via

pg_dumpall > file.sql

upgrade postgres

psql template1 -f file.sql

Yes the problem was persistent across multiple sessions

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

No, I didn't try reindexing pg_type

The filesystem is XFS


Thanks,

Stuart



pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: ERROR: cache lookup failed for type
Next
From: Stuart
Date:
Subject: Re: ERROR: cache lookup failed for type