X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id E2C20D1B4A7 for ; Sat, 13 Dec 2003 21:08:25 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 37007-09 for ; Sat, 13 Dec 2003 17:08:05 -0400 (AST) Received: from mail.broadpark.no (mail.broadpark.no [217.13.4.2]) by svr1.postgresql.org (Postfix) with ESMTP id 2DC3CD1B4BE for ; Sat, 13 Dec 2003 17:07:58 -0400 (AST) Received: from balder.devoll.no (73.80-202-219.nextgentel.com [80.202.219.73]) by mail.broadpark.no (Postfix) with ESMTP id 29B0679A69 for ; Sat, 13 Dec 2003 22:08:04 +0100 (MET) Message-Id: <6.0.1.1.2.20031213220735.01c8dec0@mail.captech.no> X-Sender: balder@devoll.no@mail.captech.no X-Mailer: QUALCOMM Windows Eudora Version 6.0.1.1 Date: Sat, 13 Dec 2003 22:07:57 +0100 To: pgsql-sql@postgresql.org From: "Henning.Baldersheim@devoll.no" Subject: Re: INHERITS and Foreign keys Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii"; format=flowed X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200312/103 X-Sequence-Number: 16269 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