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 C2D7F9FA61D for ; Fri, 9 Jun 2006 11:50:01 -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 46174-04 for ; Fri, 9 Jun 2006 11:49:52 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from wx-out-0102.google.com (wx-out-0102.google.com [66.249.82.198]) by postgresql.org (Postfix) with ESMTP id 5DC019F9316 for ; Fri, 9 Jun 2006 11:49:52 -0300 (ADT) Received: by wx-out-0102.google.com with SMTP id h30so519688wxd for ; Fri, 09 Jun 2006 07:49:50 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:references; b=U+ULZuZQja32qCazp11wiUepGpiGGkJIe/FumH9A4N1YBeijd4r7s327Gd6tvuDMJbQdIVomK4FB8vsxWufmp2gLEXcunX12stNsvzKoFPjY/pWxnaIMu/WcACWk9McbLUsVzlH8vcdhNrnPlBkYJcPU3LOGBW6NTl98uTIdD4A= Received: by 10.70.29.3 with SMTP id c3mr3590477wxc; Fri, 09 Jun 2006 07:49:49 -0700 (PDT) Received: by 10.70.72.7 with HTTP; Fri, 9 Jun 2006 07:49:49 -0700 (PDT) Message-ID: Date: Fri, 9 Jun 2006 10:49:49 -0400 From: "Colin Freas" To: pgsql-admin@postgresql.org Subject: Re: How to set the global OID counter? COPY WITH OIDS does In-Reply-To: <4489887D.6080505@aeccom.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_39910_17815010.1149864589836" References: <448976E3.50209@aeccom.com> <20060609140015.GF19659@surnet.cl> <9780.1149863199@sss.pgh.pa.us> <4489887D.6080505@aeccom.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/72 X-Sequence-Number: 22034 ------=_Part_39910_17815010.1149864589836 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: quoted-printable Content-Disposition: inline this is an important enough question that no one who asks it has to provide an answer as to why they're doing it. i can imagine many situations where this would be useful, not the least of which is reliability testing. and ESPECIALLY since OID's apparently roll over at 2^32. what happens if you have more than 4 billion rows in the database? that's totally unrelated to setting the oid counter though. come on. give it up! how do you do it? colin On 6/9/06, Dirk Lutzeb=E4ck wrote: > > 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 --oi= ds) > is being loaded. > How does 8.1 prevent to allocate duplicate OIDs? > > Regards, > > Dirk > > Tom Lane wrote: > > Alvaro Herrera = writes: > > Dirk Lutzeb=E4ck 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. > > =09=09=09regards, tom lane > > > ------=_Part_39910_17815010.1149864589836 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline
this is an important enough question that no one who asks it has to pro= vide an answer as to why they're doing it.

i can imagine many situat= ions where this would be useful, not the least of which is reliability test= ing.  and ESPECIALLY since OID's apparently roll over at 2^32.  w= hat happens if you have more than 4 billion rows in the database? =20

that's totally unrelated to setting the oid counter though.  c= ome on.  give it up!  how do you do it?

colin

= On 6/9/06, Dirk L= utzeb=E4ck < lutzeb@aeccom.com> wrote:
=20
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 <al=
vherre@commandprompt.com> writes:
Dirk Lutzeb=E4ck wrote:
how can one set the global OID counter in 8.1.X? We think it wou=
ld work 
in 8.0.X using the COPY WITH OIDS command but this does not wor= k 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 t=
he
counter? 8.1 is smart enough not to assign conflicting OIDs to large=
objects.

=09=09=09regards, tom lane


------=_Part_39910_17815010.1149864589836--