>
> Maybe then you'll add a table basket that has a foreign key to the fruit
> table....... ;-)
From the inheritance link:
...
A serious limitation of the inheritance feature is that indexes (including unique constraints) and
foreign key constraints only apply to single tables, not to their inheritance children. This is
true on both the referencing and referenced sides of a foreign key constraint.
...
You can create a foreign key to the fruit table to a table basket, but this foreign key will only
work for fruit that was directly inserted into the fruit table. Any fruit inserted into the
Apples or Oranges table can not be referenced by the table basket. I believe that this limitation
in table inheritance will not work for Greg's requirements.
Having said this, it would make me very happy if I am wrong. I hate modeling data the hard way
when there is a better way of doing it. ;)
Regards,
Richard Broersma Jr.