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

From Hiroshi Inoue
Subject Re: OID wraparound (was Re: pg_depend)
Date
Msg-id 3B567FE4.2417174@tpf.co.jp
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
Tom Lane wrote:
> 
> Hiroshi Inoue <Inoue@tpf.co.jp> writes:
> > As I mentioned already I'm implementing updatable cursors
> > in ODBC and have half done it. If OIDs would be optional
> > my trial loses its validity but I would never try another
> > implementation.
> 
> Could you use CTID instead of OID?
> 

I am using both.
TIDs for fast access and OIDs for identification.
Unfortunately TIDs are transient and they aren't
that reliable as for identification. But the
transience of TIDs are useful for row-versioning
fortunately. The combination of OID and TID has
been my plan since I introduced Tid scan.

regards,
Hiroshi Inoue


pgsql-hackers by date:

Previous
From: Philip Warner
Date:
Subject: Re: OID wraparound (was Re: pg_depend)
Next
From: Daniel Kalchev
Date:
Subject: Re: OID wraparound (was Re: pg_depend)