Tr: CHECK CONSTRAINT

Started by Stéphane FILLONalmost 27 years ago1 messagesgeneral
Jump to latest
#1Stéphane FILLON
fillons@offratel.nc

-----Message d'origine-----
De : St�phane FILLON <fillons@offratel.nc>
� : pgsql sql <pgsql-sql@postgresql.org>; pgsql admin
<pgsql-admin@postgresql.org>
Date : dimanche 1 ao�t 1999 18:15
Objet : CHECK CONSTRAINT

Show quoted text

I have 2 tables ART and MTF as follow:

create table art(
artid int4 primary key,
mtfid int4, -- can be null or foreign key with MTF

constraint ck_mtfid check(mtfid is null or fk_mtfid(mtfid))
);

create table mtf(
mtfid int4 primary key
);

create function fk_mtfid(int4) returns bool as '
declare
result int4;

begin
select mtfid into result from mtf where mtfid = $1;

if found then
return true;
else
return false;
end if;
end;
' language 'plpgsql';

The function works fine when I run it at the psql prompt, but when I tried
to insert some tuple in ART I have the following error:

"ERROR: init_fcache: Cache lookup failed for procedure 273568"

Best Regards,

Stephane.