Path: csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!feeder.erje.net!eu.feeder.erje.net!feeds.phibee-telecom.net!newsfeed.xs4all.nl!newsfeed2a.news.xs4all.nl!xs4all!newsgate.cistron.nl!newsgate.news.xs4all.nl!post.news.xs4all.nl!not-for-mail
Return-Path: <python-python-list@m.gmane.org>
X-Original-To: python-list@python.org
Delivered-To: python-list@mail.python.org
X-Spam-Status: OK 0.003
X-Spam-Evidence: '*H*': 0.99; '*S*': 0.00; '"""': 0.07; 'feature,': 0.09; 'happens.': 0.09; 'received:80.91': 0.09; 'received:80.91.229': 0.09; 'received:gmane.org': 0.09; 'received:list': 0.09; 'python': 0.11; '>that': 0.16; 'message- id:@4ax.com': 0.16; 're-read': 0.16; 'really?': 0.16; 'received:80.91.229.3': 0.16; 'received:plane.gmane.org': 0.16; 'url:peps': 0.16; 'commit': 0.19; 'thu,': 0.19; 'specifies': 0.24; 'url:dev': 0.24; 'url:home': 0.24; 'pending': 0.26; 'header:X -Complaints-To:1': 0.27; 'void': 0.31; 'interface': 0.32; 'url:python': 0.33; 'transaction': 0.35; 'but': 0.35; '+0200,': 0.36; 'method': 0.36; 'charset:us-ascii': 0.36; 'url:org': 0.36; 'should': 0.36; 'turn': 0.37; 'implement': 0.38; 'initially': 0.38; 'nov': 0.38; 'to:addr:python-list': 0.38; 'anything': 0.39; 'to:addr:python.org': 0.39; 'received:org': 0.40; 'back': 0.62; 'transactions': 0.91; 'received:108': 0.93
X-Injected-Via-Gmane: http://gmane.org/
To: python-list@python.org
From: Dennis Lee Bieber <wlfraed@ix.netcom.com>
Subject: Re: Db transactions and locking
Date: Thu, 27 Nov 2014 12:46:13 -0500
Organization: IISS Elusive Unicorn
References: <m56u4s$baa$1@ger.gmane.org>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Gmane-NNTP-Posting-Host: adsl-108-79-223-64.dsl.klmzmi.sbcglobal.net
X-Newsreader: Forte Agent 6.00/32.1186
X-No-Archive: YES
X-BeenThere: python-list@python.org
X-Mailman-Version: 2.1.15
Precedence: list
List-Id: General discussion list for the Python programming language <python-list.python.org>
List-Unsubscribe: <https://mail.python.org/mailman/options/python-list>, <mailto:python-list-request@python.org?subject=unsubscribe>
List-Archive: <http://mail.python.org/pipermail/python-list/>
List-Post: <mailto:python-list@python.org>
List-Help: <mailto:python-list-request@python.org?subject=help>
List-Subscribe: <https://mail.python.org/mailman/listinfo/python-list>, <mailto:python-list-request@python.org?subject=subscribe>
Newsgroups: comp.lang.python
Message-ID: <mailman.16376.1417110374.18130.python-list@python.org>
Lines: 27
NNTP-Posting-Host: 2001:888:2000:d::a6
X-Trace: 1417110374 news.xs4all.nl 2844 [2001:888:2000:d::a6]:48806
X-Complaints-To: abuse@xs4all.nl
Xref: csiph.com comp.lang.python:81643

On Thu, 27 Nov 2014 12:24:39 +0200, "Frank Millman" <frank@chagford.com>
declaimed the following:


>All Python database adaptors that I have used start a transaction when you 
>open a cursor. I have just re-read DB-API 2.0, and I cannot see anything 
>that specifies this behaviour, but AFAICT this is what happens.
>

	Really?

https://www.python.org/dev/peps/pep-0249/
"""
.commit ()

    Commit any pending transaction to the database.

    Note that if the database supports an auto-commit feature, this must be
initially off. An interface method may be provided to turn it back on.

    Database modules that do not support transactions should implement this
method with void functionality.
"""
-- 
	Wulfraed                 Dennis Lee Bieber         AF6VN
    wlfraed@ix.netcom.com    HTTP://wlfraed.home.netcom.com/