Re: Error “cache lookup failed for function”

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Albrecht Dreß <albrecht(dot)dress(at)arcor(dot)de>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Error “cache lookup failed for function”
Date: 2020-02-20 19:47:47
Message-ID: 19885.1582228067@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Albrecht =?iso-8859-1?b?RHJl3w==?= <albrecht(dot)dress(at)arcor(dot)de> writes:
> OK, but after fully stopping the daemon via systemctl (which of course disconnects all clients) and re-starting it, the cache is empty, isn't it? So the client after re-connecting /should/ find the proper function? In my case the full restart did *not* help, but produced the same error again afterwards! I didn't reboot the whole box, though.

Hm ... that's interesting, but it sounds like you've systematically
expunged all the evidence about what happened :-(

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ted Toth 2020-02-20 20:17:25 before insert for each row trigger on upsert
Previous Message Albrecht Dreß 2020-02-20 19:28:58 Re: Error “cache lookup failed for function”