hard20 pts · first answer countstransactionsconstraintsrow-locks
INSERT hangs on another session
Session A inserts email = 'x@y.in' into a table with a unique index and has not committed. Session B inserts the same email. What happens to B?
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