medium10 pts · first answer countstransactionsconstraints
Swapping two unique positions
A playlist has UNIQUE (playlist_id, position). Swapping positions 1 and 2 with two UPDATEs fails on the first one. What allows the swap inside one transaction?
Discussion 0
Join free to post in the discussion.
Related questions
- Durability in ACIDDatabase Administrator
- Why a write-ahead log existsDatabase Administrator
- What ROLLBACK undoesDatabase Administrator
- What C in ACID meansDatabase Administrator
- What I in ACID meansDatabase Administrator
- Statements without BEGINDatabase Administrator
- What a phantom read isDatabase Administrator
- PostgreSQL default isolationDatabase Administrator