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
