Difference between RESTRICT and NO ACTION

The difference only arises when you define a constraint as DEFERRABLE with an INITIALLY DEFERRED or INITIALLY IMMEDIATE mode.

See SET CONSTRAINTS.