Home > mailing lists

Re: existing row not found by SELECT ... WHERE CTID = ? - Mailing list pgsql-general

From	David G. Johnston
Subject	Re: existing row not found by SELECT ... WHERE CTID = ?
Date	May 26, 2022 18:24:12
Msg-id	CAKFQuwbrHi0ndyCfuSZLto9saOBw-Rd=EdtufCOD=0_3iiZy2A@mail.gmail.com Whole thread Raw
In response to	existing row not found by SELECT ... WHERE CTID = ? (Matthias Apitz <guru@unixarea.de>)
Responses	Re: existing row not found by SELECT ... WHERE CTID = ?
List	pgsql-general

On Thursday, May 26, 2022, Matthias Apitz <guru@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.

David J.

From: Matthias Apitz
Date: 26 May 2022, 18:12:44
Subject: Re: existing row not found by SELECT ... WHERE CTID = ?

From: Tom Lane
Date: 26 May 2022, 19:02:35
Subject: Re: existing row not found by SELECT ... WHERE CTID = ?