Re: PL/pgSQL problems - Mailing list pgsql-general

From Stephan Szabo
Subject Re: PL/pgSQL problems
Date
Msg-id Pine.BSF.4.21.0104190827340.86771-100000@megazone23.bigpanda.com
Whole thread Raw
In response to PL/pgSQL problems  ("Keith Menard" <kmmenard@home.com>)
List pgsql-general
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
> 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)
>


pgsql-general by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: client ssl
Next
From: "mike"
Date:
Subject: Re: PHP and pgsql 7.1