Re: Restoring Backup With OIDs As Primary Key - Mailing list pgsql-admin

From Andrew Sullivan
Subject Re: Restoring Backup With OIDs As Primary Key
Date
Msg-id 20080826141251.GP10936@commandprompt.com
Whole thread Raw
In response to Restoring Backup With OIDs As Primary Key  ("Ben C" <ben.c@ect.com.au>)
List pgsql-admin
On Tue, Aug 26, 2008 at 01:30:23PM +1000, Ben C wrote:
>
> Is there a way to increment the OID by changing a value in the system tables?

I don't think so, but I just tried creating a table in 8.3 with a
column named "oid", and it worked.  Maybe you can load in your data
that way, so that you don't need to change your application.  (I'd
test it a little more carefully for side effects than I just did, mind.)

A
--
Andrew Sullivan
ajs@commandprompt.com
+1 503 667 4564 x104
http://www.commandprompt.com/

pgsql-admin by date:

Previous
From: "Ben C"
Date:
Subject: Restoring Backup With OIDs As Primary Key
Next
From: Alvaro Herrera
Date:
Subject: Re: Restoring Backup With OIDs As Primary Key