"David G. Johnston" <david.g.johns...@gmail.com> writes:
> On Thursday, May 26, 2022, Matthias Apitz <g...@unixarea.de> wrote:
>> Is there any way to get with the old CTID to the row, for example with
>> the old CTID to the new one which the row now has after the update of the
>> row?
> No, there is no link between old and new in the main table.
There is a forward link from the old CTID to the new, but we don't
provide any user-accessible way to use it. I wonder though if the
OP should be considering using SELECT FOR UPDATE in his cursor,
so that it'd automatically chain up to the newest row version.
regards, tom lane
