From: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
---|---|
To: | him(at)nathanmlong(dot)com, pgsql-docs(at)lists(dot)postgresql(dot)org |
Subject: | Re: Clarify how triggers relate to transactions |
Date: | 2021-04-28 11:24:53 |
Message-ID: | 1a565681fe54535d69e6418ef5ab55405b92beac.camel@cybertec.at |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-docs pgsql-hackers |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Nathan Long | 2021-04-28 17:18:40 | Re: Clarify how triggers relate to transactions |
Previous Message | PG Doc comments form | 2021-04-27 14:26:48 | Clarify how triggers relate to transactions |
From | Date | Subject | |
---|---|---|---|
Next Message | Amit Kapila | 2021-04-28 11:31:47 | Re: Replication slot stats misgivings |
Previous Message | Masahiko Sawada | 2021-04-28 11:21:21 | Re: Replication slot stats misgivings |