Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-sql by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group