public inbox for [email protected]
help / color / mirror / Atom feed36.1 Overview of Trigger Behavior
2+ messages / 2 participants
[nested] [flat]
* 36.1 Overview of Trigger Behavior
@ 2015-08-11 09:51 Dmitry Igrishin <[email protected]>
0 siblings, 1 reply; 2+ messages in thread
From: Dmitry Igrishin @ 2015-08-11 09:51 UTC (permalink / raw)
To: pgsql-docs
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.
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: 36.1 Overview of Trigger Behavior
@ 2016-04-29 17:07 Peter Eisentraut <[email protected]>
parent: Dmitry Igrishin <[email protected]>
0 siblings, 0 replies; 2+ messages in thread
From: Peter Eisentraut @ 2016-04-29 17:07 UTC (permalink / raw)
To: Dmitry Igrishin <[email protected]>; pgsql-docs
On 08/11/2015 05:51 AM, Dmitry Igrishin wrote:
> Subparagraph 8:
> I suggest to replace
> "BEFORE row-level triggers to execute"
> with
> "row-level BEFORE triggers to execute"
> for consistency.
Fixed that one. Wasn't so sure about the one below.
>
> 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."
--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
--
Sent via pgsql-docs mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2016-04-29 17:07 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2015-08-11 09:51 36.1 Overview of Trigger Behavior Dmitry Igrishin <[email protected]>
2016-04-29 17:07 ` Peter Eisentraut <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox