liberapay/postgres.py

roll back when strict one fails

Closed this issue · 0 comments

If you do:

db.one("create table foo (bar text)")

you'll get a TooFew: Got -1 rows instead of 1. error, but the table will indeed be created. What would it be like to turn autocommit off and only commit db.one transactions when they returned exactly one row? What are the performance characteristics of autocommit?