Postgres Pro
Downloads
Home   >   mailing lists

36.1 Overview of Trigger Behavior - Mailing list pgsql-docs

From Dmitry Igrishin
Subject 36.1 Overview of Trigger Behavior
Date
Msg-id CAAfz9KNqLXAkygKatsTZTopNhKaCKfLiGkhrqTvEuP-OW_dtRg@mail.gmail.com
Whole thread Raw
Responses Re: 36.1 Overview of Trigger Behavior  (Peter Eisentraut <peter.eisentraut@2ndquadrant.com>)
List pgsql-docs
Tree view
Subparagraph 8:
I suggest to replace
"BEFORE row-level triggers to execute"
with
"row-level BEFORE triggers to execute"
for consistency.

Subparagraph 14:
While WHEN can be used with INSERT too, I suggest to replace
"However, in an AFTER trigger, the WHEN condition is
evaluated just after the row update occurs, and it determines
whether an event is queued to fire the trigger at the end of
statement."
with
"However, in an AFTER trigger, the WHEN condition is
evaluated just after the row inserted or updated, and it determines
whether an event is queued to fire the trigger at the end of
statement."

--
// Dmitry.

pgsql-docs by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Minor typo in rules.sgml
Next
From: Dmitry Igrishin
Date:
Subject: 36.2 Visibility of Data Changes