When I drop a function, then add it again (for example making changes to
the function code) it doesn't appear to break anything even though there
are tables with triggers that reference that function. At least not
immediately, but eventually If I do it enough times I will get this error:
PostgreSQL query failed: ERROR: fmgr_info: function 128137: cache lookup
failed
Is there an explanation for why it seems intermittent? More importantly, is
there a way to resolve this without actually redefining the trigger
referencing the function by updating a table value in one of the system tables?
Thanks.
