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
Views: Raw Message | Whole Thread | Download mbox
Thread:
Lists: pgsql-admin pgsql-bugs pgsql-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

Browse pgsql-admin by date

  From Date Subject
Next Message Mohamed Fazil 2006-06-09 13:30:51 Database port changing issue
Previous Message Thomas LeBlanc 2006-06-08 19:19:17 remove

Browse pgsql-general by date

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

Browse pgsql-bugs by date

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