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

[Tom Lane]

Hiroshi Inoue <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
>> 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.

Hmm ... within a transaction I think they'd be reliable enough,
but for long-term ID I agree they're not.  What behavior do you
need exactly; do you need to be able to find the updated version
of a row you originally inserted?  What would it take to use a
user-defined primary key instead of OID?

                        regards, tom lane

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

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