Return-Path: owner-postman Delivery-Date: Wed, 11 May 94 23:23:32 -0700 Return-Path: owner-postman Received: from localhost (localhost [127.0.0.1]) by nobozo.CS.Berkeley.EDU (8.6.4/8.6.3) with SMTP id TAA27320 for postgres-redist; Wed, 11 May 1994 19:16:31 -0700 Resent-From: POSTGRES mailing list Resent-Message-Id: <199405120216.TAA27320@nobozo.CS.Berkeley.EDU> Sender: owner-postman@postgres.Berkeley.EDU X-Return-Path: owner-postman Received: from faerie.CS.Berkeley.EDU (faerie.CS.Berkeley.EDU [128.32.149.14]) by nobozo.CS.Berkeley.EDU (8.6.4/8.6.3) with ESMTP id TAA27310 for ; Wed, 11 May 1994 19:16:31 -0700 Received: from localhost (localhost [127.0.0.1]) by faerie.CS.Berkeley.EDU (8.6.4/8.1B) with SMTP id TAA03074; Wed, 11 May 1994 19:16:16 -0700 Message-Id: <199405120216.TAA03074@faerie.CS.Berkeley.EDU> X-Authentication-Warning: faerie.CS.Berkeley.EDU: Host localhost didn't use HELO protocol From: aoki@postgres.Berkeley.EDU (Paul M. Aoki) To: Aaron Roydhouse Cc: postgres@postgres.Berkeley.EDU Subject: Re: Discovering the class from an object identifier Reply-To: aoki@postgres.Berkeley.EDU (Paul M. Aoki) In-reply-to: Your message of Thu, 12 May 1994 10:59:43 +1200 <199405112259.KAA04148@downstage.comp.vuw.ac.nz> Date: Wed, 11 May 94 19:16:16 -0700 X-Sender: aoki@postgres.Berkeley.EDU Resent-To: postgres-redist@postgres.Berkeley.EDU X-Mts: smtp Resent-Date: Wed, 11 May 94 19:16:31 -0700 Resent-XMts: smtp Aaron Roydhouse writes: > Given the oid of an instance, how can I discover the most specific > class the instance belongs to? > Alternatively, how can I retrieve an instance identified by an oid, > which knowing the classes it belongs to? > I've obviously trying to avoid querying every class in hope. the commercial derivative of postgres splits oids into a class identifier and an instance identifier, but postgres itself just assigned oids sequentially in a given database. -- Paul M. Aoki | CS Div., Dept. of EECS, UCB | aoki@postgres.Berkeley.EDU | Berkeley, CA 94720 | ...!uunet!ucbvax!aoki =============================================================================== To add/remove yourself from the POSTGRES mailing list: send mail with the subject line ADD or DEL to "postgres-request@postgres.Berkeley.EDU" If this fails, send mail to "post_questions@postgres.Berkeley.EDU" and a human will deal with it. DO NOT post to the "postgres" mailing list. ===============================================================================