RE: PL/pgSQL problems

From: Jeff Eckermann <jeckermann(at)verio(dot)net>
To: "'Keith Menard'" <kmmenard(at)home(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: RE: PL/pgSQL problems
Date: 2001-04-19 15:14:46
Message-ID: 08CD1781F85AD4118E0800A0C9B8580B094A3B@NEZU
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Browse pgsql-general by date

  From Date Subject
Next Message J.H.M. Dassen Ray 2001-04-19 15:26:40 Re: Debian packages for 7.1 ???
Previous Message Peter Eisentraut 2001-04-19 15:12:07 Re: newbie question -- oid