From: Stephan Szabo <sszabo@megazone.bigpanda.com>
To: Henning.Baldersheim@devoll.no <Henning.Baldersheim@devoll.no>
Cc: pgsql-sql@postgresql.org
Subject: Re: INHERITS and Foreign keys
Date: Sat, 13 Dec 2003 11:55:17 -0800 (PST)
Message-ID: <20031213115043.C11737@megazone.bigpanda.com> (raw)
In-Reply-To: <6.0.1.1.2.20031213200950.01d7b640@mail.captech.no>
References: <20031213190142.C41B4B9C05E@svr5.postgresql.org>
<6.0.1.1.2.20031213200950.01d7b640@mail.captech.no>
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.)
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: sszabo@megazone.bigpanda.com, Henning.Baldersheim@devoll.no
Subject: Re: INHERITS and Foreign keys
In-Reply-To: <20031213115043.C11737@megazone.bigpanda.com>
* 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