Re: PL/pgSQL problems

Thanks for the input. Dropping and recreating both the trigger function and
the trigger did the trick.

KM

"Keith Menard" <kmmenard(at)home(dot)com> wrote in message
news:9bkuoc$1qbm$1(at)news(dot)tht(dot)net(dot)(dot)(dot)
> 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(at)tsainc(dot)com
>
>