Re: inheritance and foreign keys - Mailing list pgsql-general

From Stephan Szabo
Subject Re: inheritance and foreign keys
Date
Msg-id Pine.BSF.4.21.0011301534350.48480-100000@megazone23.bigpanda.com
Whole thread Raw
In response to inheritance and foreign keys  (Chris Jones <chris@mt.sri.com>)
List pgsql-general
On 30 Nov 2000, Chris Jones wrote:

> 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?

Not currently.  The foreign key code isn't terribly bright about
inheritance trees, and some of the supporting code isn't there yet
(inherited primary keys).


pgsql-general by date:

Previous
From: Chris Jones
Date:
Subject: inheritance and foreign keys
Next
From: Stephan Szabo
Date:
Subject: Re: strange query plans