Re: [GENERAL] Inheritance and foreign keys

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