Received: from davinci.ethosmedia.com (davinci.ethosmedia.com [209.10.40.250]) by hub.org (8.10.1/8.11.0) with ESMTP id e9GFHaW88909 for ; Mon, 16 Oct 2000 11:17:36 -0400 (EDT) (envelope-from josh@agliodbs.com) Received: from [63.195.55.98] (HELO agliodbs.com) by davinci.ethosmedia.com (CommuniGate Pro SMTP 3.3) with ESMTP id 1100317 for pgsql-sql@postgresql.org; Mon, 16 Oct 2000 08:17:34 -0700 Message-ID: <39EB1C14.74DE9333@agliodbs.com> Date: Mon, 16 Oct 2000 08:17:40 -0700 From: Josh Berkus Reply-To: josh@agliodbs.com Organization: Aglio Database Solutions X-Mailer: Mozilla 4.73 [en] (Win98; I) X-Accept-Language: en MIME-Version: 1.0 To: sqllist Subject: Re: Antw: many-many mapping between unique tables References: Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200010/147 X-Sequence-Number: 1809 Mr. Majumdar, > > Sorry for splitting mails. Is there some way of using the oid of each > row to do the mapping instead of creating two more columns of integers? > The third table can then be like this: > > create table T3( > T1 oid, > T2 oid > ); Please reference two things: 1. Look in the list archives for the last 4 weeks and you will read a long discussion on the risks/limitations of using an OID as the primary key on very large tables. (Subject: Object-Relational Database Design). 2. For how to use OIDs, please look in Bruce Momjian's excellent PGSQL book-in-progress, available on the Postgresql.org website. (Chapter 7, I believe). -Josh Berkus -- ______AGLIO DATABASE SOLUTIONS___________________________ Josh Berkus Complete information technology josh@agliodbs.com and data management solutions (415) 436-9166 for law firms, small businesses fax 436-0137 and non-profit organizations. pager 338-4078 San Francisco