Postgres Pro
Downloads
Home   >   mailing lists

Thread: PL/pgSQL problems

PL/pgSQL problems

From
"Keith Menard"
Date:
    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

RE: PL/pgSQL problems

From
Jeff Eckermann
Date:
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)

Re: PL/pgSQL problems

From
Stephan Szabo
Date:
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)
>

Re: PL/pgSQL problems

From
"Keith Menard"
Date:
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
>
>