Re: ERROR: cache lookup failed for type

Поиск
Список
Период
Сортировка
От Stuart
Тема Re: ERROR: cache lookup failed for type
Дата
Msg-id 55D15A62.70406@gmail.com
обсуждение исходный текст
Ответ на Re: ERROR: cache lookup failed for type  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: ERROR: cache lookup failed for type  (Stuart <sfbarbee@gmail.com>)
Re: ERROR: cache lookup failed for type  (Adrian Klaver <adrian.klaver@aklaver.com>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: ERROR: cache lookup failed for type
Следующее
От: Stuart
Дата:
Сообщение: Re: ERROR: cache lookup failed for type