Domain constraint must be NOT DEFERRABLE

  Explanation:  You tried to specify that a domain constraint's
  evaluation is DEFERRABLE either by explicit syntax or by taking
  the default evaluation.

  User Action:  Either specify NOT DEFERRABLE or choose a dialect
  that defaults to the NOT DEFERRABLE constraint evaluation.