Subject: Re: ERROR: cache lookup failed for type
To: Tom Lane <tgl@sss.pgh.pa.us>, adrian.klaver@aklaver.com
References: <55D131B0.6010500@gmail.com> <15241.1439781395@sss.pgh.pa.us>
Cc: "pgsql-sql@postgresql.org" <pgsql-sql@postgresql.org>
From: Stuart <sfbarbee@gmail.com>
Message-ID: <55D15A62.70406@gmail.com>
Date: Mon, 17 Aug 2015 07:52:02 +0400
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:38.0) Gecko/20100101
 Thunderbird/38.2.0
MIME-Version: 1.0
In-Reply-To: <15241.1439781395@sss.pgh.pa.us>
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
Precedence: bulk
Sender: pgsql-sql-owner@postgresql.org

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


-- 
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql