Index: doc/src/sgml/ref/create_trigger.sgml =================================================================== RCS file: /cvsroot/pgsql/doc/src/sgml/ref/create_trigger.sgml,v retrieving revision 1.42 diff -c -c -r1.42 create_trigger.sgml *** doc/src/sgml/ref/create_trigger.sgml 1 Nov 2005 21:09:50 -0000 1.42 --- doc/src/sgml/ref/create_trigger.sgml 9 Dec 2005 19:38:27 -0000 *************** *** 241,253 **** function that executes the desired commands. SQL specifies that multiple triggers should be fired in time-of-creation order. PostgreSQL uses ! name order, which was judged more convenient to work with. --- 241,265 ---- function that executes the desired commands. + SQL specifies that multiple triggers should be fired in time-of-creation order. PostgreSQL uses ! name order, which was judged to be more convenient. ! ! ! ! SQL specifies that BEFORE DELETE triggers on cascaded ! deletes fire after the cascaded DELETE completes. ! The PostgreSQL behavior is for BEFORE ! DELETE to always fire before the delete action, even a cascading ! one. This is considered more consistent. There is also unpredictable ! behavior when BEFORE triggers modify rows that are later ! to be modified by referential actions. This can lead to contraint violations ! or stored data that does not honor the referential constraint.