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.