[DB-SIG] autocommit support in pep-249
mike_mp at zzzcomputing.com
Wed Sep 14 19:25:46 CEST 2011
On Sep 14, 2011, at 12:56 PM, Joshua D. Drake wrote:
> No. What I am saying is, the begin() is optional. If you look at my example, if PostgreSQL is in autocommit mode, the only way to start a transaction is to execute a query to start the transaction (BEGIN or START TRANSACTION). From a, "it would be nice if" perspective, I would like to have the option of using .begin() to start a transaction. That seems to jive better with proper coding.
"proper" on postgresql sure. On Oracle, there is no BEGIN. I like that the DBAPI tries to simplify this disconnect with a consistent, moderately coarse-grained facade rather than confusing users and burdening DBAPI authors with two ways to do it.
More information about the DB-SIG