Re: [sqlite] INSERT after creating an INDEX

2007-09-13 Thread drh
Frank Fiedler <[EMAIL PROTECTED]> wrote: >assert(sqlite3_step(drop_table_stmt) == SQLITE_DONE); I don't know what is wrong with your program, but I do see that you are misusing assert() - misusing it rather badly. An assert() statement is intended to express an invariant. It is intended to e

Re: [sqlite] INSERT after creating an INDEX

2007-09-13 Thread Frank Fiedler
Hi Simon, On 3.4.2 built from amalgamation on XP using Visual Studio I can follow your scenario without problems. I used command line shell and tcl shell. More detail will help (version etc). Ok...let's try the next level of detail: - We are using sqlite 3.4.0 on linux (Redhat Enterprise 3,

Re: [sqlite] INSERT after creating an INDEX

2007-09-13 Thread Simon Davies
Hi Frank, On 3.4.2 built from amalgamation on XP using Visual Studio I can follow your scenario without problems. I used command line shell and tcl shell. More detail will help (version etc). Rgds, Simon On 13/09/2007, Frank Fiedler <[EMAIL PROTECTED]> wrote: > Hello everybody, > > I have a pro

[sqlite] INSERT after creating an INDEX

2007-09-13 Thread Frank Fiedler
Hello everybody, I have a problem inserting elements into a data base (from process1 accessing the data base) after creating an INDEX on a table (from another process accessing the data base). I have the following setup: - I have two processes accessing a single sqlite data base. process1 ac