Received: from localhost (unknown [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id 83E12650060
	for <pgsql-admin-postgresql.org@postgresql.org>;
	Tue, 26 Aug 2008 00:45:18 -0300 (ADT)
Received: from postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 39158-03-2 for
	<pgsql-admin-postgresql.org@postgresql.org>;
	Tue, 26 Aug 2008 00:44:36 -0300 (ADT)
Received: from mx3.hub.org (mx3.hub.org [206.223.169.73])
	by postgresql.org (Postfix) with ESMTP id B710164FD15
	for <pgsql-admin@postgresql.org>; Tue, 26 Aug 2008 00:41:40 -0300 (ADT)
X-Greylist: delayed 00:09:07.227163 by SQLgrey-1.7.6
Received: from ect.com.au (unknown [210.11.58.40])
	by mx3.hub.org (Postfix) with ESMTP id ACDC137B553
	for <pgsql-admin@postgresql.org>; Tue, 26 Aug 2008 00:41:39 -0300 (ADT)
X-MimeOLE: Produced By Microsoft Exchange V6.5.7226.0
Content-class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----_=_NextPart_001_01C9072C.12B0D8E8"
Subject: Restoring Backup With OIDs As Primary Key 
Date: Tue, 26 Aug 2008 13:30:23 +1000
Message-ID: <7DA06115D1591D41A33328B737C1F4122F309E@svrect1.ect.local>
X-MS-Has-Attach: 
X-MS-TNEF-Correlator: 
Thread-Topic: Restoring Backup With OIDs As Primary Key 
Thread-Index: AckHLBKiWUnF6Lz2RQ2Niwn2uKXUKA==
From: "Ben C" <ben.c@ect.com.au>
To: <pgsql-admin@postgresql.org>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.001 tagged_above=0 required=5
	tests=HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 200808/165
X-Sequence-Number: 30010

This is a multi-part message in MIME format.

------_=_NextPart_001_01C9072C.12B0D8E8
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hello,

I am trying to restore from a backup db that used oids as primary keys * =
... when I do this the max oid value in the new database is around the =
1700 mark where as the database I am pulling in is around 20,000,000 . =
which means any new data added to the dataabse is going to be clobbered.

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

thanks in advance

* at the time this was implemented way back at 7.x, from what I had read =
it seemed like acceptable practice :/

------_=_NextPart_001_01C9072C.12B0D8E8
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
6.5.7226.0">
<TITLE>Restoring Backup With OIDs As Primary Key </TITLE>
</HEAD>
<BODY>
<!-- Converted from text/plain format -->

<P><FONT SIZE=3D2>Hello,<BR>
<BR>
I am trying to restore from a backup db that used oids as primary keys * =
... when I do this the max oid value in the new database is around the =
1700 mark where as the database I am pulling in is around 20,000,000 . =
which means any new data added to the dataabse is going to be =
clobbered.<BR>
<BR>
Is there a way to increment the OID by changing a value in the system =
tables?<BR>
<BR>
thanks in advance<BR>
<BR>
* at the time this was implemented way back at 7.x, from what I had read =
it seemed like acceptable practice :/</FONT>
</P>

</BODY>
</HTML>
------_=_NextPart_001_01C9072C.12B0D8E8--