X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 22C2654F7B for ; Thu, 24 Feb 2005 14:11:19 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 38196-10 for ; Thu, 24 Feb 2005 14:11:13 +0000 (GMT) Received: from poweredge.attiksystem.ch (adsl-soholight-4-c59-p029.vtx.ch [212.147.59.29]) by svr1.postgresql.org (Postfix) with ESMTP id 2704954C87 for ; Thu, 24 Feb 2005 14:11:10 +0000 (GMT) Subject: Postgresql inheritance workaround MIME-Version: 1.0 Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: quoted-printable Date: Thu, 24 Feb 2005 15:11:19 +0100 Content-class: urn:content-classes:message X-MimeOLE: Produced By Microsoft Exchange V6.0.6487.1 Message-ID: <6C0CF58A187DA5479245E0830AF84F4208053A@poweredge.attiksystem.ch> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Postgresql inheritance workaround Thread-Index: AcUaerYS8IB8Wn8sT3KM8yMOQEs4Ug== From: "Philippe Lang" To: X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.05 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200502/301 X-Sequence-Number: 20411 Hi, Because of the actual limitations of Postgresql inheritance mecanism regarding constraints, I'm not willing to use it in my project, although it's exactly the kind of idea I need: In an order and manufacturing management system, several different items can be ordered, each of them with specific input parameters. Every item has its own table of "specific parameters", now, what is the best use of PK/FK in order to maintain integrity between the order lines and the items specific parameters tables? Has anyone already done that before? Thanks for your help, and for Posgresql by the way, which is really great... ---------------------------------- Philippe Lang Attik System