Not possible - yet. Am 25. Mai 2017 13:48:59 MESZ schrieb Jayadevan M <maymala.jayade...@gmail.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.
