Обсуждение: inheritance and foreign keys

Do inheritance and foreign keys work together?  I can't seem to get
them to.

Specifically, I want to create a table A which has sub-tables A*, and
I want to create a table B which references the primary key from A*,
not from A.

Is this possible?

Chris

--
----------------------------------------------------- chris@mt.sri.com
Chris Jones                                    SRI International, Inc.

Wednesday, November 29, 2000, 7:06:55 PM, Chris Jones wrote:

CJ> Do inheritance and foreign keys work together?  I can't seem to get
CJ> them to.

CJ> Specifically, I want to create a table A which has sub-tables A*, and
CJ> I want to create a table B which references the primary key from A*,
CJ> not from A.

CJ> Is this possible?


I'm afraid not yet...
Anyone can foresee when the supporting code  (inherited
primary keys) will be available? (Anyone is developing it?)

regards
Nico