Gaetano Mendola <mendola@bigfoot.com> 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