Gaetano Mendola <[EMAIL PROTECTED]> writes: > I don't know how the check for the data integrity is implemented but if > is a trigger
It isn't -- trigger firing order is irrelevant to the original question. > 1) Create table > 2) create a before insert trigger: trigger_a > 3) create a before insert trigger: trigger_b > > test=# insert into test values ( 10 ); > NOTICE: TRIGGER A > NOTICE: TRIGGER B > INSERT 3416835 1 The firing order of triggers in PostgreSQL is documented: it is done alphabetically. When this was discussed, the consensus was that the "fire by creation order" part of the spec is not very useful, so we decided to deviate from it deliberately. -Neil ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
