Re: Deferred constraint trigger semantics - Mailing list pgsql-general

From David G. Johnston
Subject Re: Deferred constraint trigger semantics
Date
Msg-id CAKFQuwYOODg0425rLvTQ8EM3RcoiDiGEHYiBSJBAf4gXWOwOuA@mail.gmail.com
Whole thread Raw
In response to Deferred constraint trigger semantics  (Bryn Llewellyn <bryn@yugabyte.com>)
Responses Re: Deferred constraint trigger semantics
List pgsql-general
On Tue, May 10, 2022 at 5:47 PM Bryn Llewellyn <bryn@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)."


David J.

pgsql-general by date:

Previous
From: Bryn Llewellyn
Date:
Subject: Deferred constraint trigger semantics
Next
From: Bryn Llewellyn
Date:
Subject: Re: Deferred constraint trigger semantics