Syntax options:

    OFF | DEFERRED

    This option causes constraint evaluation to be deferred until
    commit time, when the transaction completes. OFF is synonymous
    with DEFERRED.