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