The general rule about DEFERRABLE constraints : [NOT DEFERRABLE] is default, and means that every time a database modification statement is executed, the constraint is checked immediately afterwards, if the modification could violate the constraint. However, if we declare a constraint to be DEFERRABLE, then we have the option of having it wait until […]