Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id 9F082475C91 for ; Mon, 10 Jun 2002 11:26:54 -0400 (EDT) Received: from matrix.gatewaynet.com (unknown [217.19.69.50]) by postgresql.org (Postfix) with ESMTP id AD1104759E2 for ; Mon, 10 Jun 2002 10:39:08 -0400 (EDT) Received: from localhost (achill@localhost) by matrix.gatewaynet.com (8.11.6/8.11.6) with ESMTP id g5AEeKt11909; Mon, 10 Jun 2002 17:40:20 +0300 Date: Mon, 10 Jun 2002 17:40:20 +0300 (EEST) From: Achilleus Mantzios To: Matt Cc: pgsql-sql@postgresql.org Subject: Re: multiple primary keys and reference In-Reply-To: <3D0110C1.5020908@weilpublishing.com> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Archive-Number: 200206/111 X-Sequence-Number: 8076 CREATE TABLE Parts( PartNo varchar(20) NOT NULL, machtypesid int4 NOT NULL, BestPrice decimal(100,2), Comment text, PRIMARY KEY (PartNo,machtypesid)); CREATE TABLE MachDefs( defid serial NOT NULL UNIQUE PRIMARY KEY, Description text, PartNo varchar(20), MachTypeID int4 NOT NULL, FOREIGN KEY (PartNo,MachTypeID) REFERENCES Parts (PartNo,machtypesid)); -- Achilleus Mantzios S/W Engineer IT dept Dynacom Tankers Mngmt tel: +30-10-8981112 fax: +30-10-8981877 email: achill@matrix.gatewaynet.com mantzios@softlab.ece.ntua.gr