Re: INHERITS and Foreign keys

From: "Henning(dot)Baldersheim(at)devoll(dot)no" <Henning(dot)Baldersheim(at)devoll(dot)no>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: INHERITS and Foreign keys
Date: 2003-12-13 21:07:57
Message-ID: 6.0.1.1.2.20031213220735.01c8dec0@mail.captech.no
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

At 20:55 12/13/2003, you wrote:

>On Sat, 13 Dec 2003, Henning(dot)Baldersheim(at)devoll(dot)no wrote:
>
> > Hi
> >
> > I have some problem with INHERITS and foreign keys. I do not know if I have
> > not got the clue or not. Anyway I have tried to simplify the problem so
> > that you can guide me on the right track.
>
>Foreign keys, unique and primary key constraints do not meaningfully
>inherit currently. At some point in the future, that's likely to change,
>but for now you're pretty much stuck with workarounds (for example, using
>a separate table to store the ids and triggers/rules on each of the tables
>in the hierarchy in order to keep the id table in date.)

Is there a time frame for this ? a patch, a month, a year, 7.5 or a beta
version ?

Thank you for the quick response.

Henning

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Michael Shapiro 2003-12-14 09:52:48 arrays in pl/pgsql
Previous Message Stephan Szabo 2003-12-13 19:55:17 Re: INHERITS and Foreign keys