Re: OIDS problem - Mailing list pgsql-admin

From Jim C. Nasby
Subject Re: OIDS problem
Date
Msg-id 20060113193034.GL9017@pervasive.com
Whole thread Raw
In response to OIDS problem  (Szabolcs BALLA <szballa@confinsystems.com>)
Responses Re: OIDS problem  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
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

pgsql-admin by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Re: Vacuum is needed or not?
Next
From: Tom Lane
Date:
Subject: Re: OIDS problem