Horton

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

Dirk Lutzebäck <lutzeb@aeccom.com>

View thread
From: Dirk Lutzebäck <lutzeb@aeccom.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Alvaro Herrera <alvherre@commandprompt.com>, pgsql-admin@postgresql.org, pgsql-general@postgresql.org, pgsql-bugs@postgresql.org, Sven Geisler <sgeisler@aeccom.com>, pavel rabaev <pavel@aeccom.com>
Date: 2006-06-09T14:41:01Z
Lists: pgsql-bugs 
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@commandprompt.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
>