sqlite3 is sqlite 2?

2010-03-14 Thread Laszlo Nagy
gand...@ubuntu:~$ python Python 2.6.2 (release26-maint, Apr 19 2009, 01:56:41) [GCC 4.3.3] on linux2 Type help, copyright, credits or license for more information. import sqlite3 sqlite3.version '2.4.1' Is it possible to install a real sqlite version 3 somehow? I really need it because I have

Re: sqlite3 is sqlite 2?

2010-03-14 Thread Ryan Kelly
On Fri, 2010-03-12 at 06:48 +0100, Laszlo Nagy wrote: gand...@ubuntu:~$ python Python 2.6.2 (release26-maint, Apr 19 2009, 01:56:41) [GCC 4.3.3] on linux2 Type help, copyright, credits or license for more information. import sqlite3 sqlite3.version '2.4.1' Is it possible to install a

Re: sqlite3 is sqlite 2?

2010-03-14 Thread John Bokma
Laszlo Nagy gand...@shopzeus.com writes: gand...@ubuntu:~$ python Python 2.6.2 (release26-maint, Apr 19 2009, 01:56:41) [GCC 4.3.3] on linux2 Type help, copyright, credits or license for more information. import sqlite3 sqlite3.version '2.4.1' Is it possible to install a real sqlite

sqlite savepoint problem (was: Re: sqlite3 is sqlite 2?)

2010-03-14 Thread Laszlo Nagy
That's the sqlite *bindings* version: sqlite3.version '2.4.1' sqlite3.sqlite_version '3.6.16' Thanks. I tried it and RELEASE command didn't work: import sqlite3 conn = sqlite3.connect(':memory:') with conn: ... conn.execute(BEGIN) ... conn.execute(create table a ( i

Re: sqlite savepoint problem (was: Re: sqlite3 is sqlite 2?)

2010-03-14 Thread Ryan Kelly
On Fri, 2010-03-12 at 07:46 +0100, Laszlo Nagy wrote: import sqlite3 conn = sqlite3.connect(':memory:') with conn: ... conn.execute(BEGIN) ... conn.execute(create table a ( i integer)) ... conn.execute(insert into a values (1)) ... conn.execute(savepoint sp1) ...