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

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

From: Dirk Lutzebäck <lutzeb(at)aeccom(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Alvaro Herrera <alvherre(at)commandprompt(dot)com>, pgsql-admin(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org, pgsql-bugs(at)postgresql(dot)org, Sven Geisler <sgeisler(at)aeccom(dot)com>, pavel rabaev <pavel(at)aeccom(dot)com>
Subject: Re: How to set the global OID counter? COPY WITH OIDS does
Date: 2006-06-09 14:41:01
Message-ID: 4489887D.6080505@aeccom.com (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-bugspgsql-general
This is not a large object. We are seeing rows with duplicate oids 
because the OID counter is not changed after the dump (exported with 
--oids) is being loaded.
How does 8.1 prevent to allocate duplicate OIDs?

Regards,

Dirk

Tom Lane wrote:
> Alvaro Herrera <alvherre(at)commandprompt(dot)com> writes:
>   
>> Dirk Lutzebäck 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: Colin FreasDate: 2006-06-09 14:49:49
Subject: Re: How to set the global OID counter? COPY WITH OIDS does
Previous:From: Tom LaneDate: 2006-06-09 14:26:39
Subject: Re: How to set the global OID counter? COPY WITH OIDS does not set global OID counter?

pgsql-bugs by date

Next:From: Francisco CalmDate: 2006-06-09 14:47:51
Subject: BUG #2474: cp: cannot access ~/archivedir/00000001.history
Previous:From: Tom LaneDate: 2006-06-09 14:26:39
Subject: Re: How to set the global OID counter? COPY WITH OIDS does not set global OID counter?

pgsql-general by date

Next:From: Colin FreasDate: 2006-06-09 14:49:49
Subject: Re: How to set the global OID counter? COPY WITH OIDS does
Previous:From: A.M.Date: 2006-06-09 14:37:03
Subject: Re: Fabian Pascal and RDBMS deficiencies in fully

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