From: | Stéphane FILLON <fillons(at)offratel(dot)nc> |
---|---|
To: | "pgsql general" <pgsql-general(at)postgresql(dot)org> |
Subject: | Tr: CHECK CONSTRAINT |
Date: | 1999-08-04 17:50:47 |
Message-ID: | 000301bedfdb$401c9740$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 : dimanche 1 août 1999 18:15
Objet : CHECK CONSTRAINT
>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.
>
From | Date | Subject | |
---|---|---|---|
Next Message | Stéphane FILLON | 1999-08-04 17:51:17 | Tr: UNIQUE |
Previous Message | Stéphane FILLON | 1999-08-04 17:50:37 | Tr: DOMAIN DEFINITION |