Hi,
I have a question relation inherited tables and foreign key constraints:
Following situation:
Table Person, PK pers_id
Table Customer, PK kun_id, inherited from Person
Table Contact, FK pers_id from Person
I insert a record into Customer. "SELECT * FROM Person" gives now a part of
this new record. Now I try to insert a record into Contact, using pers_id from
the newly inserted record of Customer. pgsql rejects because of violence of
the foreign key constraint.
I understood inheritance that every record of Customer is a Person, too. But
this looks like I only could take a "pure" record of Person to fullfill this
constraint. Is this right?
Thanks in advance,
Verena