constraint check ordering
I have a procedure which wraps inserts into this table. If a particular constraint -- eg, primary key -- is violated, the procedure will handle the exception and do an update instead of an insert. If a different unique constraint is violated, it can't handle the exception, and will raise it back to the caller. In this case, the order that the constraints are checked, and the specific error raised, determines the behavior of this procedure. The only thing I can find is that it seems to check the order in which the indexes are created. Is there anything more specific than this?