From: | "Verena Ruff" <lists(at)triosolutions(dot)at> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | Inheritance, foreign key constraint |
Date: | 2005-06-12 21:44:08 |
Message-ID: | 20050612213630.M14028@webmail.netmonic.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Volkan YAZICI | 2005-06-13 07:37:19 | Steps taken through while transmitting binary data |
Previous Message | stig erikson | 2005-06-12 10:17:12 | allowing ',' (comma) in float8 |