pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Henning.Baldersheim@devoll.no <Henning.Baldersheim@devoll.no>
To: pgsql-sql@postgresql.org
Subject: Re: INHERITS and Foreign keys
Date: Sat, 13 Dec 2003 22:07:57 +0100
Message-ID: <6.0.1.1.2.20031213220735.01c8dec0@mail.captech.no> (raw)

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

>On Sat, 13 Dec 2003, Henning.Baldersheim@devoll.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





view thread (5+ messages)  latest in thread

Message-ID: <6.0.1.1.2.20031213220735.01c8dec0@mail.captech.no>
Permalink:  ../6.0.1.1.2.20031213220735.01c8dec0@mail.captech.no/
Also on:    postgresql.org/message-id/6.0.1.1.2.20031213220735.01c8dec0@mail.captech.no

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: Henning.Baldersheim@devoll.no
  Subject: Re: INHERITS and Foreign keys
  In-Reply-To: <6.0.1.1.2.20031213220735.01c8dec0@mail.captech.no>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox