Received: from mc-qout2.whowhere.com (nytoday.whowhere.com [209.1.236.38]) by hub.org (8.10.1/8.11.0) with SMTP id e9GMnaW60799 for ; Mon, 16 Oct 2000 18:49:37 -0400 (EDT) (envelope-from kparker@eudoramail.com) Received: from Unknown/Local ([?.?.?.?]) by shared1-mail.whowhere.com; Mon Oct 16 15:49:18 2000 To: pgsql-sql@hub.org Date: Mon, 16 Oct 2000 15:49:18 -0700 From: "K Parker" Message-ID: Mime-Version: 1.0 X-Sent-Mail: off Reply-To: kparker@eudoramail.com X-Mailer: MailCity Service Subject: Re: many-to-many mapping X-Sender-Ip: 209.191.185.54 Organization: QUALCOMM Eudora Web-Mail (http://www.eudoramail.com:80) Content-Type: text/plain; charset=us-ascii Content-Language: en Content-Transfer-Encoding: 7bit X-Archive-Number: 200010/151 X-Sequence-Number: 1813 Am I the only one who's nervous about these two tables referencing each other like this? I would have a concern that this is being imposed, perhaps, by some external format that the data arrives in, and that a decently normalized design will have a simple all-key table containing nothing but serial # id's from both primary tables. Join 18 million Eudora users by signing up for a free Eudora Web-Mail account at http://www.eudoramail.com