On Thu, Jul 11, 2002 at 07:23:23PM +0200,
Andreas Schlegel <schlegel@software.b.uunet.de> wrote
a message of 37 lines which said:
> I just wrote my first function and trigger in Postgres an dit won't work :-(
>
> I get the error: "fmgr_info: function 541860: cache lookup failed"
It is not a syntax error. It is simply because the binding between the
trigger and the function is done once and stays in the cache after
(you probably changed the function after the trigger). You have to
drop the trigger and recreate it.