Thanks for the input. Dropping and recreating both the trigger function and
the trigger did the trick.
KM
"Keith Menard" <kmmenard@home.com> wrote in message
news:9bkuoc$1qbm$1@news.tht.net...
> 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
>
>