Gaetano Mendola <[EMAIL PROTECTED]> writes: > Well, it is. If the data integrity was done with a system trigger > created at table creation time the firing order is relevant.
Right, but the data integrity check is _not_ done via a system trigger. Hence, "trigger firing order is irrelevant to the original question", as I said earlier. > Good to hear. So, why the standard is there ? According to the docs, "PostgreSQL development tends to aim for conformance with the latest official version of the standard where such conformance does not contradict traditional features or common sense." The previous consensus seemed to be that being non-conformant with the standard in this area was worth it. I'm not particularly attached to the current behavior though, so feel free to restate your case for changing the trigger firing order on -bugs. -Neil ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])