Postgres Pro
Downloads
Home   >   mailing lists

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

From Alvaro Herrera
Subject Re: Restoring Backup With OIDs As Primary Key
Date
Msg-id 20080826141622.GB4920@alvh.no-ip.org
Whole thread Raw
In response to Restoring Backup With OIDs As Primary Key  ("Ben C" <ben.c@ect.com.au>)
List pgsql-admin
Tree view 
Ben C wrote:

> Is there a way to increment the OID by changing a value in the system tables?

Not a system table, but you can with pg_resetxlog -o.

--
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

pgsql-admin by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: Restoring Backup With OIDs As Primary Key
Next
From: Rommel the iCeMAn
Date:
Subject: Re: Problem with reinstall of PostgreSQL 8.3