Resent-From: POSTGRES mailing list <postman@postgres.Berkeley.EDU>
Resent-Message-Id: <199401031721.JAA24974@nobozo.CS.Berkeley.EDU>
Sender: owner-postman@postgres.Berkeley.EDU
Date: Mon, 3 Jan 94 12:21:51 EST
From: vayda@erim.org (Alan Vayda)
Message-Id: <9401031721.AA21673@csd630a.erim.org>
To: postgres@postgres.Berkeley.EDU
Subject: Using object IDs to link objects
Resent-To: postgres-dist@postgres.Berkeley.EDU
Resent-Date: Mon, 03 Jan 94 09:21:29 -0800
Resent-XMts: smtp

I'm relatively new to POSTGRES and would like some suggestions on the
use of object ID's for linking class instances together. 
Here is a simplified version of my problem:

I have two classes, for example a book class and a page class.
Each book instance is related to a number of page instances.
I need to determine the related book instance from a page instance and
all of the related page instances from a book instance.
It seems that all that is required is to do one of the following:
1. add a list of page instance OIDs to each book instance
2. add a book instance OID to each page instance

The difficulty is with the mechanics of creating the instances with
append commands.  I don't know how to collect the OIDs so that they
can be stored in the related instances.  

Alan Vayda
vayda@erim.org
ERIM
PO Box 134001
Ann Arbor, MI 48113-4001