Re: [GENERAL] inheritance and primary/foreign keys

2001-03-09 Thread Stephan Szabo
On Fri, 9 Mar 2001, Einar Karttunen wrote: > On Wed, 7 Mar 2001, Stephan Szabo wrote: > > > > You cannot safely reference tops of inheritance trees under 7.0 or 7.1 and > > have it reference the trees. > > > Is there anyway to emulate this? I want to have several types of persons Someone's been

Re: [GENERAL] inheritance and primary/foreign keys

2001-03-07 Thread Stephan Szabo
On Wed, 7 Mar 2001, Daniel J. Kressin wrote: > Question 1: If table A has as its primary key "a_pk" and table B > inherits table A, then table B also has as its primary key a_pk. Is > that correct? I don't believe so currently. > Question 2: If I want table C to have a foreign key on both A an

[GENERAL] inheritance and primary/foreign keys

2001-03-07 Thread Daniel J. Kressin
Question 1: If table A has as its primary key "a_pk" and table B inherits table A, then table B also has as its primary key a_pk. Is that correct? Question 2: If I want table C to have a foreign key on both A and B, is the following syntax correct? (I'm using 7.0.3) CREATE TABLE c (