Postgresql, Autocommit, Oracle.
alter table DEMO add unique(n); select * from DEMO; insert into DEMO values (2,current_timestamp); select * from DEMO; insert into DEMO values (1,current_timestamp); select * from DEMO; quit ERROR: current transaction is aborted That’s different in PostgreSQL where the transaction cannot continue