python点保存没反应_在python sqlite3中使用保存点

我正在尝试将保存点与python 2.6中内置的sqlite3模块一起使用.每次我尝试释放或回滚保存点时,我总是收到一个OperationalError：没有这样的保存点.我错过了什么？

python version: 2.6.4 (r264:75821M,Oct 27 2009,19:48:32)

[GCC 4.0.1 (Apple Inc. build 5493)]

PySQLite version: 2.4.1

sqlite3 version: 3.6.11

Traceback (most recent call last):

File "spDemo.py",line 21,in

从这段代码：

import sys

import sqlite3

print 'python version:',sys.version

print 'PySQLite version:',sqlite3.version

print 'sqlite3 version:',sqlite3.sqlite_version

print

conn = sqlite3.connect('db_spDemo.db')

conn.isolation_level = "DEFERRED"

with conn:

conn.execute("create table example (A,B);")

with conn:

conn.execute("insert into example values (?,?);",(0,200))

conn.execute("savepoint spTest;")

conn.execute("insert into example values (?,(1,201))

conn.execute("insert into example values (?,(2,202))

conn.execute("release savepoint spTest;")

conn.execute("insert into example values (?,(5,205))