Re: Order of trigger execution: AFTER DELETE ON EACH ROW doesn't appear to be working properly

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Christopher Maier" <maier(at)med(dot)unc(dot)edu>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Order of trigger execution: AFTER DELETE ON EACH ROW doesn't appear to be working properly
Date: 2008-10-13 18:30:11
Message-ID: 19331.1223922611@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

"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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Adrian Klaver 2008-10-13 19:08:10 Re: Order of trigger execution: AFTER DELETE ON EACH ROW doesn't appear to be working properly
Previous Message Christopher Maier 2008-10-13 18:21:15 Re: Problem with delete trigger: how to allow only triggers to delete a row?