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
>
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 |