On Fri, Oct 28, 2022, at 9:58 AM, Marc-Andre Lemburg wrote: > If there is a pending transaction, though, there are three approaches > we could take: > > 1. The database module raises an exception, to force an explicit > .commit() or .rollback() by the programmer. > > 2. The module automatically commits the pending transaction, > since that's what autocommit is all about. > > 3. We leave these semantics open and up to the database module > to determine. > > My preference would be option 2, since this makes things clear for > everyone and is intuitive (well, at least for me :-)).
option 3 is likely what will occur in practice. it feels a little awkward for an attribute set operation to move forward with a transactional modification to the database server.
_______________________________________________ DB-SIG maillist - DB-SIG@python.org https://mail.python.org/mailman/listinfo/db-sig