On Fri, 2010-08-06 at 10:28 +0300, Heikki Linnakangas wrote: > > SQL:2011 makes no mention of how MERGE should react to statement level > > triggers. MERGE is not a trigger action even. Given considerable > > confusion in this area, IMHO we should just say the MERGE does not call > > statement triggers at all, of any kind. > > IMO the UPDATE/DELETE/INSERT actions should fire the respective > statement level triggers, but the MERGE itself should not.
When, and how? If an UPDATE is mentioned 5 times, do we call the trigger 5 times? What happens if none of the UPDATEs are ever executed? Best explain exactly what you mean. -- Simon Riggs www.2ndQuadrant.com PostgreSQL Development, 24x7 Support, Training and Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers