Re: Inheritance and foreign keys

Not possible - yet.

Am 25. Mai 2017 13:48:59 MESZ schrieb Jayadevan M <maymala(dot)jayadevan(at)gmail(dot)com>:
>Hi,
>
>I designed three tables so that one table inherits another, and the
>third
>table references the parent table. If a record is inserted into the
>third
>table and the value does exist in the parent table indirectly, because
>it
>is present in the inherited table, I still get an error.
>Is some option available while creating the foreign key so that it will
>consider the data in the child tables also while doing a constraint
>validation?
>
>create table myt(id serial primary key);
>create table mytc (like myt);
>alter table mytc inherit myt;
>insert into myt values(1);
>insert into mytc values(2);
> select * from myt;
> id
>----
> 1
> 2
>
>create table a (id integer references myt(id));
>insert into a values(2);
>ERROR: insert or update on table "a" violates foreign key constraint
>"a_id_fkey"
>DETAIL: Key (id)=(2) is not present in table "myt".
>
>
>Regards,
>Jayadevan

--
Diese Nachricht wurde von meinem Android-Mobiltelefon mit K-9 Mail gesendet.