Databases · Middle · Question 66 of 75

What must an application do when using the Serializable isolation level in PostgreSQL?

✓Correct answer: Be ready to retry transactions that fail with a serialization error (SQLSTATE 40001)
2Run all transactions from one connection
3Nothing; serializable transactions never fail

Explanation

PostgreSQL detects dangerous patterns and aborts one transaction instead of blocking. A retry loop around the whole transaction is required.

Further reading

PostgreSQL: Transaction isolation ↗

Test yourself

Take the Databases · Middle quiz: questions and options are shuffled, and you get a review of your mistakes at the end.