From: Andrew Sullivan <ajs@commandprompt.com>
To: pgsql-admin@postgresql.org
Subject: Re: Restoring Backup With OIDs As Primary Key
Date: Tue, 26 Aug 2008 10:12:52 -0400
Message-ID: <20080826141251.GP10936@commandprompt.com> (raw)
In-Reply-To: <7DA06115D1591D41A33328B737C1F4122F309E@svrect1.ect.local>
References: <7DA06115D1591D41A33328B737C1F4122F309E@svrect1.ect.local>
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/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: ajs@commandprompt.com
Subject: Re: Restoring Backup With OIDs As Primary Key
In-Reply-To: <20080826141251.GP10936@commandprompt.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox