Re: OID wraparound (was Re: pg_depend) - Mailing list pgsql-hackers

From Larry Rosenman
Subject Re: OID wraparound (was Re: pg_depend)
Date
Msg-id 20010718.21355900@ler-freebie.iadfw.net
Whole thread Raw
In response to Re: OID wraparound (was Re: pg_depend)  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: OID wraparound (was Re: pg_depend)
List pgsql-hackers
Didn't know about that one, at least from the reading of the docs...

Thanks,
You answered the question.  I knew OID's weren't unique, but they are 
likely to be able to distinguish between 2 rows in the same table. 

Maybe ctid needs to be documented better? 

LER

>>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<<

On 7/18/01, 4:32:28 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote regarding Re: 
OID wraparound (was Re: [HACKERS] pg_depend) :


> Bruce Momjian <pgman@candle.pha.pa.us> writes:
> >> Also, without OID's, how do you fix EXACT duplicate records that happen
> >> by accident?

> > How about tid's?  SELECT tid FROM tab1.

> "SELECT ctid", actually, but that is still the fallback.  (Actually
> it always was --- OIDs aren't necessarily unique either, Larry.)

>                       regards, tom lane


pgsql-hackers by date:

Previous
From: "Mikheev, Vadim"
Date:
Subject: RE: OID wraparound (was Re: pg_depend)
Next
From: teg@redhat.com (Trond Eivind Glomsrød)
Date:
Subject: Re: MySQL Gemini code