#transactions
2 snippets tagged with #transactions
sqlintermediate
Optimistic Locking with Version Column
Prevent lost updates in concurrent environments using a version column for optimistic concurrency control.
#concurrency#locking
sqlintermediate
Deferred Foreign Key Constraints
Defer constraint checking to transaction commit for circular references and batch operations.
#constraints#transactions