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

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 (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-bugspgsql-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

pgsql-admin by date

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

pgsql-bugs by date

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

pgsql-general by date

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

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