Re: Antw: many-many mapping between unique tables - Mailing list pgsql-sql

From Josh Berkus
Subject Re: Antw: many-many mapping between unique tables
Date
Msg-id 39EB1C14.74DE9333@agliodbs.com
Whole thread Raw
In response to Re: Antw: many-many mapping between unique tables  (Indraneel Majumdar <indraneel@www.cdfd.org.in>)
Responses Re: Antw: many-many mapping between unique tables
List pgsql-sql
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
informationtechnology      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


pgsql-sql by date:

Previous
From: Indraneel Majumdar
Date:
Subject: Re: Antw: many-many mapping between unique tables
Next
From: KuroiNeko
Date:
Subject: Re: Antw: many-many mapping between unique tables