Received: from yara.imsd.uni-mainz.de (yara.IMSD.Uni-Mainz.DE [134.93.144.68]) by hub.org (8.10.1/8.10.1) with ESMTP id e6LBrCh71229 for ; Fri, 21 Jul 2000 07:53:13 -0400 (EDT) Received: (from smap@localhost) by yara.imsd.uni-mainz.de (8.9.3/8.9.3/lxs_5.2) id NAA18348 for ; Fri, 21 Jul 2000 13:52:32 +0200 Received: from hermes.imsd.uni-mainz.de(134.93.64.80) by yara.imsd.uni-mainz.de via smap (V2.1/2.1+anti-relay+anti-spam) id xma018345; Fri, 21 Jul 00 13:52:26 +0200 Received: from imsd.uni-mainz.de (unverified [134.93.64.47]) by hermes.imsd.uni-mainz.de (EMWAC SMTPRS 0.83) with SMTP id ; Fri, 21 Jul 2000 13:47:50 +0200 Message-ID: <3978385E.2182D8B4@imsd.uni-mainz.de> Date: Fri, 21 Jul 2000 13:47:43 +0200 From: Markus Wagner Reply-To: wagner@imsd.uni-mainz.de Organization: IMSD X-Mailer: Mozilla 4.73 [en] (WinNT; I) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-sql Subject: using OID as primary key Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200007/202 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? Thanks, Markus