Postgresql, Autocommit, Oracle.
when you encounter an error: psql -U postgres demo ### PostgreSQL 11.4 drop table if exists DEMO; start transaction; create table DEMO(n,t) as select 1 n,current_timestamp t; alter table DEMO add unique(n); select * from DEMO; insert into DEMO values (2,current_timestamp); select * from DEMO;