Horton

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

Alvaro Herrera <alvherre@commandprompt.com>

View thread
From: Alvaro Herrera <alvherre@commandprompt.com>
To: Dirk Lutzebäck <lutzeb@aeccom.com>
Cc: pgsql-admin@postgresql.org, pgsql-general@postgresql.org, pgsql-bugs@postgresql.org, tgl@sss.pgh.pa.us
Date: 2006-06-09T14:00:15Z
Lists: pgsql-bugs 
Dirk Lutzebäck wrote:
> 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.

pg_resetxlog -o
(Postmaster stopped of course)

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support