Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: OID wraparound (was Re: pg_depend)
Date
Msg-id 13136.995491948@sss.pgh.pa.us
Whole thread Raw
In response to Re: OID wraparound (was Re: pg_depend)  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: OID wraparound (was Re: pg_depend)
List pgsql-hackers
Tree view 
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: Bruce Momjian
Date:
Subject: Re: OID wraparound (was Re: pg_depend)
Next
From: "Mikheev, Vadim"
Date:
Subject: RE: OID wraparound (was Re: pg_depend)