Clarify how triggers relate to transactions
The Post Office <noreply@postgresql.org>
From: PG Doc comments form <noreply@postgresql.org>
To: pgsql-docs@lists.postgresql.org
Cc: him@nathanmlong.com
Date: 2021-04-27T14:26:48Z
Lists: pgsql-hackers, pgsql-docs
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."
Commits
-
Doc: clarify how triggers relate to transactions.
- 95bc40f880a6 14.0 landed
- 469150a240dd 15.0 landed