Python DB API - commit() v. execute("commit transaction")?

Gregory Ewing greg.ewing at canterbury.ac.nz
Fri Jun 2 04:15:42 EDT 2017


Frank Millman wrote:
> I never changed the 
> default, so all of the following assumes that autocommit is on.
> 
> I had many SELECT's, but I was not issuing any form of commit, so the 
> locks built up. I solved my problem by always committing.

Something is screwy when a feature called "autocommit" results in
you having to issue explicit commits.

-- 
Greg



More information about the Python-list mailing list