In DataGrip, I made multiple changes in multiple tables in my database by clicking around with the mouse. I would like to commit all those changes in a single transaction. The Tx: Manual setting on top seems to only commit changes in a transaction from the one table that is on my screen. Is there a better way of achieving this than copying all the changes I did in a script, and then add begin and end and execute the script?
Transaction across changes in multiple tables
33 Views Asked by karlosss At
1
That will work if you turn on Single Session Mode in data source settings: