Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp> 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