View Single Post

   
  #1 (permalink)  
Old 04-10-2008, 11:02 AM
=?UTF-8?B?RGlyayBMdXR6ZWLDpGNr?=
 
Posts: n/a
Default How to set the global OID counter? COPY WITH OIDS does not set globalOID counter?

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

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

Reply With Quote