Re: Clarify how triggers relate to transactions

Поиск
Список
Период
Сортировка
От Nathan Long
Тема Re: Clarify how triggers relate to transactions
Дата
Msg-id CAOyE-6ZsrpJT2HRBRzGoixZDvRUYZnrvgRXFfZYs1WRW+rpZKQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Clarify how triggers relate to transactions  (Laurenz Albe <laurenz.albe@cybertec.at>)
Ответы Re: Clarify how triggers relate to transactions  ("Euler Taveira" <euler@eulerto.com>)
Список pgsql-docs
Gotcha. Where would I go to make the PR?

On Wed, Apr 28, 2021, 7:24 AM Laurenz Albe <laurenz.albe@cybertec.at> wrote:
On Tue, 2021-04-27 at 14:26 +0000, PG Doc comments form wrote:
> The following documentation comment has been logged on the website:
>
> Page: https://www.postgresql.org/docs/13/sql-createtrigger.html
> Description:
>
> https://www.postgresql.org/docs/current/sql-createtrigger.html mentions the
> word "transaction" only once, in reference specifically to constraint
> triggers: "They can be fired either at the end of the statement causing the
> triggering event, or at the end of the containing transaction; in the latter
> case they are said to be deferred."
>
> If I understand correctly, it would be helpful to add this sentence or a
> corrected version of it: "Triggers always execute in the same transaction as
> the triggering event, and if a trigger fails, the transaction is rolled
> back."

Good idea in principle, but I'd put that information on
https://www.postgresql.org/docs/current/trigger-definition.html

Yours,
Laurenz Albe

В списке pgsql-docs по дате отправления:

Предыдущее
От: Laurenz Albe
Дата:
Сообщение: Re: Clarify how triggers relate to transactions
Следующее
От: PG Doc comments form
Дата:
Сообщение: Wrong type for the left argument of the operator "|/" and "||/" in chapter 9.3