Demian Lessa <demian@xxxxxxxxx> writes: > What I'm trying to figure out is how postgre identifies the *exact* set > of constraints to enforce for each of the different commands above, and > the order in which these are performed (since some checks are way more > expensive than others). Triggers on the same event are fired in alphabetical order by "tgname". I don't believe any particular ordering is enforced among CHECK constraints --- but they all happen before any triggers fire. regards, tom lane
