"David G. Johnston" <david.g.johnston@xxxxxxxxx> writes: > On Thursday, May 26, 2022, Matthias Apitz <guru@xxxxxxxxxxx> 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
