X-Original-To: pgsql-performance@postgresql.org Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by postgresql.org (Postfix) with ESMTP id 60FA84762FA for ; Wed, 5 Mar 2003 10:20:54 -0500 (EST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.8/8.12.8) with ESMTP id h25FKfx6019294; Wed, 5 Mar 2003 10:20:41 -0500 (EST) To: Neil Conway Cc: Christopher Kings-Lynne , daniel alvarez , Richard Huxton , PostgreSQL Performance Subject: Re: OIDs as keys In-reply-to: <1046872498.10615.17.camel@tokyo> References: <200302261358.53730.dev@archonet.com> <24135.1046271575@www36.gmx.net> <29871.1046274964@sss.pgh.pa.us> <032301c2de14$c64ccf70$6500a8c0@fhp.internal> <8927.1046327718@sss.pgh.pa.us> <040a01c2de2d$dac03780$6500a8c0@fhp.internal> <9113.1046329568@sss.pgh.pa.us> <044801c2de30$93d71ca0$6500a8c0@fhp.internal> <9227.1046331043@sss.pgh.pa.us> <1046872498.10615.17.camel@tokyo> Comments: In-reply-to Neil Conway message dated "05 Mar 2003 08:54:58 -0500" Date: Wed, 05 Mar 2003 10:20:40 -0500 Message-ID: <19293.1046877640@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200303/30 X-Sequence-Number: 1328 Neil Conway writes: > Rather than specifying the use of OIDs by WITH OIDS clauses for each > CREATE TABLE in a dump, couldn't we do it by adding a SET command that > toggles the 'use_oids' GUC option prior to every CREATE TABLE? Seems better than cluttering the CREATE TABLE itself with them, I guess. regards, tom lane