In addtion to what miritika wrote, this type of constraint checking is more useful when two tables are joined with foreign key relationship (parent-child) and data is entered in both at same time.

Default value of DEFERRABLE constraint is INITIALLY IMMEDIATE.

gtm