Have you dropped and recreated the function since creating the trigger? Try
dropping and recreating the trigger. Errors like this happen because
database objects (tables, functions etc) are referenced by object ids (oids)
behind the scenes. Recreating an object (like a function) will give it a
different oid, even with the same name.
> -----Original Message-----
> From: Keith Menard [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, April 18, 2001 3:51 PM
> To: [EMAIL PROTECTED]
> Subject: [GENERAL] PL/pgSQL problems
>
> 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 4: Don't 'kill -9' the postmaster
