Re: Clarify how triggers relate to transactions
От | Laurenz Albe |
---|---|
Тема | Re: Clarify how triggers relate to transactions |
Дата | |
Msg-id | 1a565681fe54535d69e6418ef5ab55405b92beac.camel@cybertec.at обсуждение исходный текст |
Ответ на | Clarify how triggers relate to transactions (PG Doc comments form <noreply@postgresql.org>) |
Ответы |
Re: Clarify how triggers relate to transactions
Re: Clarify how triggers relate to transactions |
Список | pgsql-docs |
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 по дате отправления: