"David G. Johnston" <david.g.johnston@xxxxxxxxx> writes: > On Thu, May 26, 2016 at 8:50 AM, Thomas Güttler < > guettliml@xxxxxxxxxxxxxxxxxx> wrote: >> OK, timing of constraint triggers is explained. >> But I think the docs don't state the timing of normal AFTER triggers. > â??Through omission. It's not *that* bad. See https://www.postgresql.org/docs/9.5/static/trigger-definition.html Triggers are also classified according to whether they fire before, after, or instead of the operation. These are referred to as BEFORE triggers, AFTER triggers, and INSTEAD OF triggers respectively. Statement-level BEFORE triggers naturally fire before the statement starts to do anything, while statement-level AFTER triggers fire at the very end of the statement. These types of triggers may be defined on tables or views. Row-level BEFORE triggers fire immediately before a particular row is operated on, while row-level AFTER triggers fire at the end of the statement (but before any statement-level AFTER triggers). ... regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
