On Tue, May 10, 2022 at 5:47 PM Bryn Llewellyn <bryn@xxxxxxxxxxxx> wrote:
INFO: trg fired. new.v = 80, n = 8It shows the expected "new" value each time it fires. And yet the query reflects the table content on statement completion. This seems to be very strange.
From the documentation:
"Row-level BEFORE triggers fire immediately before a particular row is operated on, while row-level AFTER triggers fire at the end of the statement (but before any statement-level AFTER triggers)."
David J.
