Re: Clarify how triggers relate to transactions

On Wed, 2021-04-28 at 13:24 +0200, Laurenz Albe wrote:
> On Tue, 2021-04-27 at 14:26 +0000, PG Doc comments form wrote:
> > 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

Here is a proposed patch for this.

Yours,
Laurenz Albe