Received: from mailout05.sul.t-online.com (mailout05.sul.t-online.com [194.25.134.82]) by hub.org (8.10.1/8.10.1) with ESMTP id e6LCjih84002 for ; Fri, 21 Jul 2000 08:45:45 -0400 (EDT) Received: from fwd03.sul.t-online.com by mailout05.sul.t-online.com with smtp id 13FcBO-0006s7-04; Fri, 21 Jul 2000 14:45:38 +0200 Received: from hot.jw.home (340000654369-0001@[62.224.110.75]) by fwd03.sul.t-online.com with esmtp id 13FcBH-0eB43EC; Fri, 21 Jul 2000 14:45:31 +0200 Received: (from wieck@localhost) by hot.jw.home (8.8.5/8.8.5) id NAA04499; Fri, 21 Jul 2000 13:57:17 +0200 From: JanWieck@t-online.de (Jan Wieck) Message-Id: <200007211157.NAA04499@hot.jw.home> Subject: Re: using OID as primary key In-Reply-To: <3978385E.2182D8B4@imsd.uni-mainz.de> from Markus Wagner at "Jul 21, 2000 01:47:43 pm" To: wagner@imsd.uni-mainz.de Date: Fri, 21 Jul 2000 13:57:17 +0200 (MEST) CC: pgsql-sql Reply-To: Jan Wieck X-Mailer: ELM [version 2.4ME+ PL68 (25)] MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Sender: 340000654369-0001@t-dialin.net X-Archive-Number: 200007/203 Markus Wagner wrote: > Hi, > > are there any disadvantages of using OID as the primary key for any > table? > What about referencing external tuples using their OIDs? > > e. g.: > CREATE TABLE thistable > ... > field NUMERIC REFERENCES OtherTable (oid) > > Which data type should I use to reference OIDs? > > Will I run into problems later if I do my things this way? Currently OID is not supported for references. Has to do with some checks done in the RI triggers, using SPI functions. We're thinking about a solution... Jan -- #======================================================================# # It's easier to get forgiveness for being wrong than for being right. # # Let's break this rule - forgive me. # #================================================== JanWieck@Yahoo.com #