On Fri, May 26, 2023 at 12:49 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Just to clarify, there's no way for SELECT FROM foo WHERE ctid = NEW.ctid > to return a row that ordinary wouldn't be visible right? There's no magic > going on with the qual on ctid that skips a visibility check right?
No, a ctid test isn't magic in that way; nodeTidscan.c applies the same snapshot check as any other relation scan.