The transaction_conflict test in its previous form would deadlock
because PostgreSQL locks tables/rows instead of aborting on every
conflict. The fix is to force a rollback by first reading and then
updating in both transactions, which would result in a lost update
otherwise.