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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
Cc: Dirk Lutzebäck <lutzeb(at)aeccom(dot)com>, pgsql-admin(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org, pgsql-bugs(at)postgresql(dot)org
Subject: Re: How to set the global OID counter? COPY WITH OIDS does not set global OID counter?
Date: 2006-06-09 14:26:39
Message-ID: 9780.1149863199@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-bugs pgsql-general

Alvaro Herrera <alvherre(at)commandprompt(dot)com> writes:
> Dirk Lutzebck wrote:
>> 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)

Possibly more to the point: why do you think you need to mess with the
counter? 8.1 is smart enough not to assign conflicting OIDs to large
objects.

regards, tom lane

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Dirk Lutzebäck 2006-06-09 14:41:01 Re: How to set the global OID counter? COPY WITH OIDS does
Previous Message Chris Browne 2006-06-09 14:22:40 Re: Database port changing issue

Browse pgsql-bugs by date

  From Date Subject
Next Message Dirk Lutzebäck 2006-06-09 14:41:01 Re: How to set the global OID counter? COPY WITH OIDS does
Previous Message Alvaro Herrera 2006-06-09 14:00:15 Re: How to set the global OID counter? COPY WITH OIDS does not set global OID counter?

Browse pgsql-general by date

  From Date Subject
Next Message Greg 2006-06-09 14:33:46 Problem with silent install of PgSQL on Windows
Previous Message Nis Jorgensen 2006-06-09 14:07:17 Re: Fabian Pascal and RDBMS deficiencies in fully implementing