"Christopher Maier" <maier(at)med(dot)unc(dot)edu> writes:
> ... Based on debugging messages I added
> to the triggers, it looks like the before row triggers fire for ALL
> the rows first, THEN all the after row triggers fire.
That's correct. After triggers are queued up and fired at end of
statement.
regards, tom lane