Tr: Cache lookup failed with FUNCTION + TRIGGER

From: Stéphane FILLON <fillons(at)offratel(dot)nc>
To: "pgsql general" <pgsql-general(at)postgreSQL(dot)org>
Subject: Tr: Cache lookup failed with FUNCTION + TRIGGER
Date: 1999-08-04 17:50:06
Message-ID: 000101bedfdb$3e92ea00$c40a8280@portable
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


-----Message d'origine-----
De : Stéphane FILLON <fillons(at)offratel(dot)nc>
À : pgsql sql <pgsql-sql(at)postgresql(dot)org>; pgsql admin
<pgsql-admin(at)postgresql(dot)org>
Date : mercredi 4 août 1999 14:21
Objet : Cache lookup failed with FUNCTION + TRIGGER

>I have one table client :
>
>create table client(
> nocli int4,
> ....
>);
>
>create function client() returns opaque as '
>begin
> if new.nocli ISNULL then
> raise exception "nocli null";
> end if;
>end;
>' language 'plpgsql';
>
>create trigger client before insert on client
>for each row execute procedure client();
>
>When I try to insert a tuple in client I have the following error:
>
>"ERROR: fmgr_info: function 149857: cache lookup failed"
>
>Where does this come from ? That's not the first time that I have this kind
>of message!!
>
>Please H E L P !!!!
>
>RedHat 5.2
>PostgreSQL 6.5.1
>
>
>Regards,
>
>Stephane FILLON
>

Browse pgsql-general by date

  From Date Subject
Next Message Stéphane FILLON 1999-08-04 17:50:37 Tr: DOMAIN DEFINITION
Previous Message Stéphane FILLON 1999-08-04 17:49:53 Tr: DUMP database for sample