Transaction across changes in multiple tables
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?
Solution
That will work if you turn on Single Session Mode in data source settings:
- Django atomic transaction unit test failing (commits not being rolled back)
- Are pragma statements undone by rolling back transactions?
- JPA - When to use getTransaction() when persisting objects
- Postgres / SQL pattern for atomic SELECT and UPDATE or INSERT within a transaction
- Why does database not read from newly inserted data when a single query is doing both write and read?
- Handling race conditions between transactions
- Hibernate Query executed in @RestController out of @Transactional context
- Google BigQuery InsertAll with Transaction?
- Cleaning up after changing the isolation level in JPA / EclipsLink EntityManager
- Plaid Transaction Sync, Access Token Rotation and Cursor Position
- Disabling transaction on spring testing test method
- Atomikos library has incompatibility packages (from javax.transaction to jakarta.transaction)
- Spring Transaction Management @Transactional behavior
- Nested SQL transactions in Active Record - risks?
- Tutorial for Payway to integrate in iPhone app?
- Circular dependency on TransactionManager Bean in Spring Batch
- Ignite Factory<TransactionManager> is ignored
- Apache Ignite throws Failed to deserialize object with given class loader on startup ( Client - Server )
- What happens to an uncommitted transaction when the connection is closed?
- Pipeline, watch() and multi() in redis. How do they really work?
- Optimistic vs. Pessimistic locking
- Does Spring @Transactional attribute work on a private method?
- How to use a Transaction with a lifetime specified with the Query's execute function?
- Mongodb v4.0 Transaction, MongoError: Transaction numbers are only allowed on a replica set member or mongos
- Multiple node instances with a single database
- Mysterious TransactionConflict in TransactionCanceledException
- How do I "ROLLBACK TO" a "SAVEPOINT"?
- how to calculate database transaction count per second and database growth
- within a procedure how to know if i am in a transaction
- How to simulate lost update in MySQL?