Wait for Commit

BEGIN;

SET CONSTRAINTS ALL DEFERRED;

INSERT INTO child table something that doesn’t exist in parent but it’s constraint by FK;

INSERT INTO parent the same value; --(or updates)

COMMIT;