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--