PostgreSQL: Will DEFERRABLE INITIALLY DEFERRED prevent this race condition?

postgresql foreign-keys race-condition isolation-level deferrable-constraint