Demian Lessa <demian(at)lessa(dot)org> 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