Postgresql, Autocommit, Oracle.
insert into DEMO values (1,current_timestamp); select * from DEMO; rollback; select * from DEMO; \q ERROR: current transaction is aborted, commands ignored until end of transaction block Here I rolled back. But I can also commit to terminate the transaction, but it will rollback anyway: # commit;