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".