Re: Deferred constraint trigger semantics

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Deferred constraint trigger semantics
Дата
Msg-id CAKFQuwYOODg0425rLvTQ8EM3RcoiDiGEHYiBSJBAf4gXWOwOuA@mail.gmail.com
обсуждение исходный текст
Ответ на Deferred constraint trigger semantics  (Bryn Llewellyn <bryn@yugabyte.com>)
Ответы Re: Deferred constraint trigger semantics
Список 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 по дате отправления:

Предыдущее
От: Bryn Llewellyn
Дата:
Сообщение: Deferred constraint trigger semantics
Следующее
От: Bryn Llewellyn
Дата:
Сообщение: Re: Deferred constraint trigger semantics