<cnliou@eurosport.com> writes:
> Does foreign key constraints also fire in
> alphabetical order in 7.3?
Foreign key triggers will fire in alphabetical order along with other
triggers. This means they're firing based on a textual sort of the
OIDs assigned to the triggers, which will often but not always
correspond to creation order.
I'm having a hard time visualizing a situation where it's reasonable
to depend on FK trigger firing order, actually. Convince me why I
should care about this?
regards, tom lane