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:kmmenard@home.com]
> Sent: Wednesday, April 18, 2001 3:51 PM
> To: pgsql-general@postgresql.org
> 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
> menardk@tsainc.com
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)