Re: [sqlite] Crash while creating a table

2005-10-01 Thread denys
G. Roderick Singleton a écrit : On Sat, 2005-10-01 at 22:19 +0200, denys wrote: Hi all, I'm trying to create a table but I always get an "assertion failed" crash :-( Here is the statement: CREATE TABLE Media (id INTEGER PRIMARY KEY, keywords TEXT, original INTEGER, used INTEGER,

Re: [sqlite] Crash while creating a table

2005-10-01 Thread drh
denys <[EMAIL PROTECTED]> wrote: > > Here is the statement: > CREATE TABLE Media (id INTEGER PRIMARY KEY, keywords TEXT, original > INTEGER, used INTEGER, picture TEXT, note INTEGER, comment BLOB, note > INTEGER, type INTEGER, idSpec INTEGER); > > Assertion failed: pCol->zType==0, file

Re: [sqlite] Crash while creating a table

2005-10-01 Thread Lawrence Chitty
denys wrote: Hi all, I'm trying to create a table but I always get an "assertion failed" crash :-( Here is the statement: CREATE TABLE Media (id INTEGER PRIMARY KEY, keywords TEXT, original INTEGER, used INTEGER, picture TEXT, note INTEGER, comment BLOB, note INTEGER, type INTEGER, idSpec

Re: [sqlite] Crash while creating a table

2005-10-01 Thread G. Roderick Singleton
On Sat, 2005-10-01 at 22:19 +0200, denys wrote: > Hi all, > > I'm trying to create a table but I always get an "assertion failed" > crash :-( > > Here is the statement: > CREATE TABLE Media (id INTEGER PRIMARY KEY, keywords TEXT, original > INTEGER, used INTEGER, picture TEXT, note INTEGER,

[sqlite] Crash while creating a table

2005-10-01 Thread denys
Hi all, I'm trying to create a table but I always get an "assertion failed" crash :-( Here is the statement: CREATE TABLE Media (id INTEGER PRIMARY KEY, keywords TEXT, original INTEGER, used INTEGER, picture TEXT, note INTEGER, comment BLOB, note INTEGER, type INTEGER, idSpec INTEGER);

[sqlite] How to speed up SQLite

2005-10-01 Thread pippi pohopper
I'm experimenting with SQLite and found there's a big difference in speed depending on the setting of PRAGMA SYNCHRONOUS. I understand that settings other than"2" for this parameter don't guarantee that data is safely stored on disk when che COMMIT statement terminates. I wonder if it is