Have you modified the function since making the trigger?
If you drop/create the function to make any changes you need to 
drop/create objects that depend on that function (views, triggers, etc)

On Wed, 18 Apr 2001, Keith Menard wrote:

>     All,
> 
>     I am new to pgSQL so here goes. I am having a problem using the
> PL/pg/SQL language extension to create triggers. I get all the items
> installed including PL/pgSQL, the trigger and the function the trigger calls
> and I get the following error dring the firing of the trigger:
> 
> Apr 18 09:49:02 host postgres[2477]: ERROR:  fmgr_info: function 57216:
> cache lookup failed
> 
> Any help would be appreciated since I can find only scant docs on the
> PL/pgSQL extensions.
> 
> Keith Menard
> [EMAIL PROTECTED]
> 
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
> 


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Reply via email to