X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 5927BDAFA1 for ; Tue, 22 Nov 2005 11:42:38 -0400 (AST) 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 65092-04 for ; Tue, 22 Nov 2005 15:42:41 +0000 (GMT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from worleyco.com (unknown [70.158.54.226]) by svr1.postgresql.org (Postfix) with ESMTP id 7D4C2DA81C for ; Tue, 22 Nov 2005 11:42:35 -0400 (AST) Received: from [192.168.4.32] (unknown [192.168.4.32]) by worleyco.com (Postfix) with ESMTP id 0D6071382D0 for ; Tue, 22 Nov 2005 09:42:42 -0600 (CST) Message-ID: <43833C70.2050607@hardgeus.com> Date: Tue, 22 Nov 2005 09:42:40 -0600 From: John McCawley User-Agent: Mozilla Thunderbird 1.0.6 (X11/20050716) X-Accept-Language: en-us, en MIME-Version: 1.0 To: "Pgsql-sql@postgresql.org" Subject: Re: Foreign key to 2 tables problem References: <1132673053.5701.9.camel@Panoramix> <43833B3D.2020407@hardgeus.com> In-Reply-To: <43833B3D.2020407@hardgeus.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0 required=5 tests=[AWL=0.000] X-Spam-Score: 0 X-Spam-Level: X-Archive-Number: 200511/199 X-Sequence-Number: 23450 > However, if customers or suppliers can have multiple accounts, you are > going to need an intermediate table, as suggested by Neil. Scratch that. If accounts can have multiple owners you'll need an intermediate table.