From szballa@confinsystems.com Fri Jan 13 10:05:41 2006 X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id BB4CB9DD662 for ; Fri, 13 Jan 2006 06:05:41 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 62217-08 for ; Fri, 13 Jan 2006 06:05:43 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from galagonx.fixdial.interware.hu (galagonx.fixdial.interware.hu [195.70.45.31]) by postgresql.org (Postfix) with ESMTP id 72C979DD66C for ; Fri, 13 Jan 2006 06:05:39 -0400 (AST) Received: from szballa.intra ([172.20.80.68]) by galagonx.fixdial.interware.hu with esmtp (Exim 3.36 #1 (Debian)) id 1ExLoS-0000f7-00 for ; Fri, 13 Jan 2006 11:05:40 +0100 Subject: OIDS problem From: Szabolcs BALLA To: pgsql-admin@postgresql.org Content-Type: multipart/alternative; boundary="=-sFanBTx8TFu9ugHLJn8s" Date: Fri, 13 Jan 2006 11:05:38 +0100 Message-Id: <1137146738.4305.12.camel@bh> Mime-Version: 1.0 X-Mailer: Evolution 2.0.4 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.031 required=5 tests=[AWL=0.030, HTML_MESSAGE=0.001] X-Spam-Score: 0.031 X-Spam-Level: X-Archive-Number: 200601/156 X-Sequence-Number: 20244 --=-sFanBTx8TFu9ugHLJn8s Content-Type: text/plain Content-Transfer-Encoding: 7bit Hi, I have already upgraded our server from 7.4 to 8.1. My problem is the next: some of our queries use OIDS but I restored the databases without OIDS. Is it possible to set the OIDS without dump and restore? Thanks Szabek --=-sFanBTx8TFu9ugHLJn8s Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: 7bit Hi,

I have already upgraded our server from 7.4 to 8.1. 
My problem is the next: some of our queries use OIDS but I restored the databases without OIDS.
Is it possible to set the OIDS without dump and restore?

Thanks
Szabek --=-sFanBTx8TFu9ugHLJn8s-- From jnasby@pervasive.com Fri Jan 13 19:30:43 2006 X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 2DF069DD73F for ; Fri, 13 Jan 2006 15:30:43 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 73043-03 for ; Fri, 13 Jan 2006 15:30:39 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from noel.decibel.org (noel.decibel.org [67.100.216.10]) by postgresql.org (Postfix) with ESMTP id 748599DD72E for ; Fri, 13 Jan 2006 15:30:35 -0400 (AST) Received: by noel.decibel.org (Postfix, from userid 1001) id CE0B93982E; Fri, 13 Jan 2006 13:30:34 -0600 (CST) Date: Fri, 13 Jan 2006 13:30:34 -0600 From: "Jim C. Nasby" To: Szabolcs BALLA Cc: pgsql-admin@postgresql.org Subject: Re: OIDS problem Message-ID: <20060113193034.GL9017@pervasive.com> References: <1137146738.4305.12.camel@bh> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <1137146738.4305.12.camel@bh> X-Operating-System: FreeBSD 6.0-RELEASE amd64 X-Distributed: Join the Effort! http://www.distributed.net User-Agent: Mutt/1.5.11 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.088 required=5 tests=[AWL=0.088] X-Spam-Score: 0.088 X-Spam-Level: X-Archive-Number: 200601/164 X-Sequence-Number: 20252 On Fri, Jan 13, 2006 at 11:05:38AM +0100, Szabolcs BALLA wrote: > Hi, > > I have already upgraded our server from 7.4 to 8.1. > My problem is the next: some of our queries use OIDS but I restored the > databases without OIDS. > Is it possible to set the OIDS without dump and restore? No; the tables are now missing the OID fields. You'll need to dump and restore. You should also change your application... IIRC the intention is to eventually remove OIDs from user tables. -- Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461 From tgl@sss.pgh.pa.us Fri Jan 13 19:50:09 2006 X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 83F929DD73E for ; Fri, 13 Jan 2006 15:50:09 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 77875-01 for ; Fri, 13 Jan 2006 15:50:04 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 264D99DD73F for ; Fri, 13 Jan 2006 15:49:59 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id k0DJnusS012704; Fri, 13 Jan 2006 14:49:56 -0500 (EST) To: "Jim C. Nasby" cc: Szabolcs BALLA , pgsql-admin@postgresql.org Subject: Re: OIDS problem In-reply-to: <20060113193034.GL9017@pervasive.com> References: <1137146738.4305.12.camel@bh> <20060113193034.GL9017@pervasive.com> Comments: In-reply-to "Jim C. Nasby" message dated "Fri, 13 Jan 2006 13:30:34 -0600" Date: Fri, 13 Jan 2006 14:49:56 -0500 Message-ID: <12703.1137181796@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.087 required=5 tests=[AWL=0.087] X-Spam-Score: 0.087 X-Spam-Level: X-Archive-Number: 200601/165 X-Sequence-Number: 20253 "Jim C. Nasby" writes: > You should also change your application... IIRC the intention > is to eventually remove OIDs from user tables. There is no such plan --- defaulting to WITHOUT OIDS is as far as we intend to go. regards, tom lane