Re: OID wraparound (was Re: [HACKERS] pg_depend)

[Larry Rosenman]

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 <[EMAIL PROTECTED]> wrote regarding Re: 
OID wraparound (was Re: [HACKERS] pg_depend) :


> Bruce Momjian <[EMAIL PROTECTED]> 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

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://www.postgresql.org/search.mpl