Re: [GENERAL] PL/PGSQL

Hi Jens,

You have this kind of message, when you have changed your function
insert_history() without drop-ing and recreating your trigger.

When you change you function, your function get another OID and the trigger
still get the old one who doesn't more exist.

I hope that my english is not to french.......Sorry :-)

Best Regards,
Stephane FILLON.

-----Message d'origine-----
De : Jens Felber <jfe(at)gek-online(dot)de>
À : pgsql-general(at)postgreSQL(dot)org <pgsql-general(at)postgreSQL(dot)org>
Date : lundi 23 août 1999 18:40
Objet : [GENERAL] PL/PGSQL

>Hi pgsql list-members
>
>I'm new at this list an want some answers for the following problem:
>
>On every time, when my trigger is called I get
>the Message:
>
>ERROR: fmgr_info: function 87776 : cache lookup failure
>
>What means this - or where are described ERROR-Messages at the
Documentation.
>
>What I've done:
>
>create table test1 (x int2, free bool);
>create table history (x
>int2);
>
>create function insert_history () returns opaque as
> 'select x into history from test1 where free=\'t\';'
>language 'plpgsql';
>
>create trigger ins1 after update on test1 for each row execute procedure
>insert_history();
>
>
>by and thanks
>Jens
>
>GEK CONSULTING GmbH
>An den Teichen 5
>09224 Mittelbach
>
>Tel.: (0371) 80 88 260
>Fax.: (0371) 80 88 266
>EMail: J(dot)Felber(at)gek-consulting(dot)de
> jfe(at)gek-online(dot)de
>
>************
>