Re: OIDs, CTIDs, updateable cursors and friends - Mailing list pgsql-hackers

From Tom Lane
Subject Re: OIDs, CTIDs, updateable cursors and friends
Date
Msg-id 2262.1077206474@sss.pgh.pa.us
Whole thread Raw
In response to Re: OIDs, CTIDs, updateable cursors and friends  ("Zeugswetter Andreas SB SD" <ZeugswetterA@spardat.at>)
List pgsql-hackers
"Zeugswetter Andreas SB SD" <ZeugswetterA@spardat.at> writes:
> IIRC the ctid access follows the chain up to the currently valid 
> tuple ?

No.

I think Hiroshi or someone put in a function you can use to follow the
chain, but a simple "WHERE ctid = whatever" won't do it.  In any case,
if you're not holding an open transaction then you have to be prepared
to have the dead tuple vacuumed out from under you, in which case you'd
not be able to follow the chain anyway.
        regards, tom lane


pgsql-hackers by date:

Previous
From: "Zeugswetter Andreas SB SD"
Date:
Subject: Re: [PATCHES] NO WAIT ...
Next
From: Bruce Momjian
Date:
Subject: Re: [PATCHES] NO WAIT ...