Re: [sqlite] Multiple Threads with a DROP command

2006-06-15 Thread drh
"James Butts" <[EMAIL PROTECTED]> wrote: > > In the main thread, I open a connection to database and create a timer > function and start a worker thread. The worker thread establishes its own > separate connection to database. The worker thread creates a table and then > signals the main thre

Re: [sqlite] Multiple Threads with a DROP command

2006-06-15 Thread James Butts
On 6/15/06, James Butts <[EMAIL PROTECTED]> wrote: > > In the main thread, I open a connection to database and create a timer > function and start a worker thread. The worker thread establishes its own > separate connection to database. The worker thread creates a table and > then signals the ma

Re: [sqlite] Multiple Threads with a DROP command

2006-06-15 Thread Jay Sprenkle
On 6/15/06, James Butts <[EMAIL PROTECTED]> wrote: In the main thread, I open a connection to database and create a timer function and start a worker thread. The worker thread establishes its own separate connection to database. The worker thread creates a table and then signals the main th

[sqlite] Multiple Threads with a DROP command

2006-06-15 Thread James Butts
I have a problem involving multiple threads and trying to create a table after its been dropped. Perhaps I'm doing something wrong. Here is the jist. In the main thread, I open a connection to database and create a timer function and start a worker thread. The worker thread establishes its o