Re: Trigger and Function Question - Mailing list pgsql-novice

From Tom Lane
Subject Re: Trigger and Function Question
Date
Msg-id 19103.987656284@sss.pgh.pa.us
Whole thread Raw
In response to Trigger and Function Question  ("Jeff Umstead" <jumstead@timlsoftware.com>)
List pgsql-novice
"Jeff Umstead" <jumstead@timlsoftware.com> writes:
> I get the following error:

> 010418.22:47:10.789 [29762] ERROR:  fmgr_info: function 25479: cache
> lookup failed

Looks like you deleted and recreated the function, without also deleting
and recreating the trigger that refers to it.  Now the trigger is
referring to a no-longer-existent function OID ... remake the trigger
and try again.

            regards, tom lane

pgsql-novice by date:

Previous
From: "Jeff Umstead"
Date:
Subject: Trigger and Function Question
Next
From: Shay Moreno
Date:
Subject: Re: Trigger and Function Question