Skip site navigation (1) Skip section navigation (2)

How to set the global OID counter? COPY WITH OIDS does not set global OID counter?

From: Dirk Lutzebäck <lutzeb(at)aeccom(dot)com>
To: pgsql-admin(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org, pgsql-bugs(at)postgresql(dot)org
Cc: tgl(at)sss(dot)pgh(dot)pa(dot)us
Subject: How to set the global OID counter? COPY WITH OIDS does not set global OID counter?
Date: 2006-06-09 13:25:55
Message-ID: 448976E3.50209@aeccom.com (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-bugspgsql-general
Hi,

how can one set the global OID counter in 8.1.X? We think it would work 
in 8.0.X using the COPY WITH OIDS command but this does not work in 
8.1.X anymore.

We have the problem that we made a dump using 'pg_dump -o' in 8.0.X, 
created a new database in 8.1.X and read back in but the global OID 
counter stayed at 40.000 so OIDs will be allocated again!

Thanks for help,

Dirk

Responses

pgsql-admin by date

Next:From: Mohamed FazilDate: 2006-06-09 13:30:51
Subject: Database port changing issue
Previous:From: Thomas LeBlancDate: 2006-06-08 19:19:17
Subject: remove

pgsql-bugs by date

Next:From: Rojas, Fernando (CIAT)Date: 2006-06-09 13:48:58
Subject: Error Starting Back END
Previous:From: kah_hang_angDate: 2006-06-09 09:29:08
Subject: Re: statement stuck when the connection grew up to 45 or more

pgsql-general by date

Next:From: Roman NeuhauserDate: 2006-06-09 13:33:31
Subject: Re: Fabian Pascal and RDBMS deficiencies in fully implementing
Previous:From: pobox@verysmall.orgDate: 2006-06-09 13:19:38
Subject: Re: 010.pgsql.sh does not react

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group