Why does PostgreSQL check a DEFERRABLE INITIALLY IMMEDIATE constraint after each statement?
I run the following SQL that never commits the transaction: rollback; begin; create table testing_stuff ( id serial, num integer NOT NULL unique deferrable initially immediate ); insert into testing_stuff (num) values (2), (1); -- no issues with deferrable even…