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 89F43D1B462 for ; Sat, 13 Dec 2003 19:55:39 +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 31853-06 for ; Sat, 13 Dec 2003 15:55:18 -0400 (AST) Received: from megazone.bigpanda.com (megazone.bigpanda.com [64.147.171.210]) by svr1.postgresql.org (Postfix) with ESMTP id F0E00D1B460 for ; Sat, 13 Dec 2003 15:55:10 -0400 (AST) Received: by megazone.bigpanda.com (Postfix, from userid 1001) id 19C1D35484; Sat, 13 Dec 2003 11:55:17 -0800 (PST) Received: from localhost (localhost [127.0.0.1]) by megazone.bigpanda.com (Postfix) with ESMTP id 184513544A; Sat, 13 Dec 2003 11:55:17 -0800 (PST) Date: Sat, 13 Dec 2003 11:55:17 -0800 (PST) From: Stephan Szabo To: "Henning.Baldersheim@devoll.no" Cc: pgsql-sql@postgresql.org Subject: Re: INHERITS and Foreign keys In-Reply-To: <6.0.1.1.2.20031213200950.01d7b640@mail.captech.no> Message-ID: <20031213115043.C11737@megazone.bigpanda.com> References: <20031213190142.C41B4B9C05E@svr5.postgresql.org> <6.0.1.1.2.20031213200950.01d7b640@mail.captech.no> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200312/102 X-Sequence-Number: 16268 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.)