X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 04A469FA621; Fri, 9 Jun 2006 11:41:10 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 46527-01; Fri, 9 Jun 2006 11:41:04 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- X-Greylist: from auto-whitelisted by SQLgrey- X-Greylist: from auto-whitelisted by SQLgrey- Received: from mail.aeccom.com (port-83-236-156-26.static.qsc.de [83.236.156.26]) by postgresql.org (Postfix) with ESMTP id 9F5279FA61D; Fri, 9 Jun 2006 11:41:04 -0300 (ADT) Received: from localhost (localhost.localdomain [127.0.0.1]) by mail.aeccom.com (Postfix) with ESMTP id 322E01CA6A; Fri, 9 Jun 2006 16:41:03 +0200 (CEST) Received: from mail.aeccom.com ([127.0.0.1]) by localhost (gate6.aeccom.com [127.0.0.1]) (amavisd-new, port 10024) with LMTP id 09528-02-11; Fri, 9 Jun 2006 16:41:02 +0200 (CEST) Received: from [192.168.2.12] (cayambe.core.aeccom.com [192.168.2.12]) by mail.aeccom.com (Postfix) with ESMTP id 319B71CA69; Fri, 9 Jun 2006 16:41:02 +0200 (CEST) Message-ID: <4489887D.6080505@aeccom.com> Date: Fri, 09 Jun 2006 16:41:01 +0200 From: =?ISO-8859-1?Q?Dirk_Lutzeb=E4ck?= Organization: AEC/communications GmbH User-Agent: Thunderbird 1.5 (X11/20051201) MIME-Version: 1.0 To: Tom Lane CC: Alvaro Herrera , pgsql-admin@postgresql.org, pgsql-general@postgresql.org, pgsql-bugs@postgresql.org, Sven Geisler , pavel rabaev Subject: Re: How to set the global OID counter? COPY WITH OIDS does References: <448976E3.50209@aeccom.com> <20060609140015.GF19659@surnet.cl> <9780.1149863199@sss.pgh.pa.us> In-Reply-To: <9780.1149863199@sss.pgh.pa.us> Content-Type: multipart/alternative; boundary="------------020701080809010700060307" X-Virus-Scanned: amavisd-new at aeccom.com X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/71 X-Sequence-Number: 22033 This is a multi-part message in MIME format. --------------020701080809010700060307 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit 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 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 > --------------020701080809010700060307 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit 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
  

--------------020701080809010700060307--