Re: inheritance and foreign keys

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: Chris Jones <chris(at)mt(dot)sri(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: inheritance and foreign keys
Date: 2000-11-30 23:35:41
Message-ID: Pine.BSF.4.21.0011301534350.48480-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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).

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Alex Pilosov 2000-12-01 00:12:35 Re: Can PostGreSQL handle 100 user database?
Previous Message Stephan Szabo 2000-11-30 23:34:33 Re: strange query plans