Re: Error“cache lookup failed for function”
От | Albrecht Dreß |
---|---|
Тема | Re: Error“cache lookup failed for function” |
Дата | |
Msg-id | PFPD7MHF.3YTVSZTQ.N5T3PKAJ@KXEKA4CS.MSLFYEKD.WB7M4VLP обсуждение исходный текст |
Ответ на | Re: Error “cache lookup failed for function” (Tom Lane <tgl@sss.pgh.pa.us>) |
Ответы |
Re: Error “cache lookup failed for function”
Re: Error “cache lookup failed for function” |
Список | pgsql-general |
Am 20.02.20 19:32 schrieb(en) Tom Lane: > This is, actually, not very surprising. You dropped the old function while clients were using it. The new function isa completely unrelated object, even if it happens to have the same name. Yes, I agree that this was not a too clever approach… > It does seem a bit annoying that something in plpgsql is apparently doing a fresh catalog lookup to find information thatlikely was already cached at the start of function execution. OK, but after fully stopping the daemon via systemctl (which of course disconnects all clients) and re-starting it, the cacheis empty, isn't it? So the client after re-connecting /should/ find the proper function? In my case the full restartdid *not* help, but produced the same error again afterwards! I didn't reboot the whole box, though. This led me to the assumption that the database was “somehow” damaged. Thanks, Albrecht.
Вложения
В списке pgsql-general по дате отправления: