Re: [sqlite] sqlite3 save points and roll back error

2010-02-03 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 lakshmi pathi wrote: > sqlite3.OperationalError: no such savepoint: pt pysqlite does all sorts of stuff behind the scenes trying to manage transactions for you by default. I believe you can set isolation_level to None to disable that. Else use APSW

[sqlite] sqlite3 save points and roll back error

2010-02-03 Thread lakshmi pathi
Hi all, I'm working on a sqlite3 with python program.Here is the code snippet def save_point(self): self.db.execute("savepoint pt;") print "Save point created" self.cursor.execute("insert into STK values(33)") self.db.execute("r