On Tue, May 10, 2022 at 5:47 PM Bryn Llewellyn <b...@yugabyte.com> wrote:
> > INFO: trg fired. new.v = 80, n = 8 > > It 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)." https://www.postgresql.org/docs/current/trigger-definition.html David J.
