Re: [sqlite] Table locked - why?

2007-08-31 Thread Yves Goergen
On 31.08.2007 10:45 CE(S)T, Yves Goergen wrote: > Maybe I should retry it with a plain SQLite console and figure out > whether the bug is in the .NET wrapper (just as the previous one I've > found...). Stay tuned... When I do that from an SQLite console, it works as expected. So I'll head over to

Re: [sqlite] Table locked - why?

2007-08-31 Thread Yves Goergen
On 31.08.2007 06:03 CE(S)T, Dan Kennedy wrote: > On Fri, 2007-08-31 at 00:09 +0200, Yves Goergen wrote: >> CREATE TEMPORARY TABLE attached_db.temp_table > > I'm not sure where that table is created - in the temporary > namespace or as part of attached_db. Checking... > > SQLite version

Re: [sqlite] Table locked - why?

2007-08-31 Thread Yves Goergen
On 31.08.2007 00:50 CE(S)T, Virgilio Alexandre Fornazin wrote: > Did you closed the cursor opened at 'select *...' ? > Thats probably the reason you have getting a 'table is locked' error. I'm using the .NET wrapper to SQLite that should handle all API internals for me. Even disposing the

Re: [sqlite] Table locked - why?

2007-08-31 Thread Yves Goergen
On 31.08.2007 00:23 CE(S)T, RaghavendraK 70574 wrote: > Pls see if u hv an open sqlite3 terminal.sometimes this can also > cause a prob with begin tx and just kept it open. Really, I don't. Trust me. :) -- Yves Goergen "LonelyPixel" <[EMAIL PROTECTED]> Visit my web laboratory at

Re: [sqlite] Table locked - why?

2007-08-30 Thread Dan Kennedy
On Fri, 2007-08-31 at 00:09 +0200, Yves Goergen wrote: > On 30.08.2007 22:55 CE(S)T, Ken wrote: > > BEGIN TRANSACTION; > > CREATE TEMPORARY TABLE attached_db.temp_table (...); > > INSERT INTO attached_db.temp_table SELECT * FROM attached_db.table1; > > > > /* Add a comit */ > > COMMIT; > >

RE: [sqlite] Table locked - why?

2007-08-30 Thread Virgilio Alexandre Fornazin
Friday, August 31, 2007 3:41 am Subject: Re: [sqlite] Table locked - why? > On 30.08.2007 23:00 CE(S)T, [EMAIL PROTECTED] wrote: > > Probably another thread or process is reading from the database > > and does not want you to drop the table out from under it. > > Surely not. This da

Re: [sqlite] Table locked - why?

2007-08-30 Thread RaghavendraK 70574
2007 3:41 am Subject: Re: [sqlite] Table locked - why? > On 30.08.2007 23:00 CE(S)T, [EMAIL PROTECTED] wrote: > > Probably another thread or process is reading from the database > > and does not want you to drop the table out from under it. > > Surely not. This da

Re: [sqlite] Table locked - why?

2007-08-30 Thread Yves Goergen
On 30.08.2007 23:00 CE(S)T, [EMAIL PROTECTED] wrote: > Probably another thread or process is reading from the database > and does not want you to drop the table out from under it. Surely not. This database is there for testing and development purposes only and my application is the only one that

Re: [sqlite] Table locked - why?

2007-08-30 Thread Yves Goergen
On 30.08.2007 22:55 CE(S)T, Ken wrote: > BEGIN TRANSACTION; > CREATE TEMPORARY TABLE attached_db.temp_table (...); > INSERT INTO attached_db.temp_table SELECT * FROM attached_db.table1; > > /* Add a comit */ > COMMIT; Error: cannot commit transaction - SQL statements in progress > DROP TABLE

Re: [sqlite] Table locked - why?

2007-08-30 Thread drh
Yves Goergen <[EMAIL PROTECTED]> wrote: > Hi, > > I want to modify the structure of a table, particularly remove a column. > Since SQLite won't help me with that, I'll need to go the hard way by > copying all data to a temp table, then re-creating the table with the > new structure and copying

Re: [sqlite] Table locked - why?

2007-08-30 Thread Ken
BEGIN TRANSACTION; CREATE TEMPORARY TABLE attached_db.temp_table (...); INSERT INTO attached_db.temp_table SELECT * FROM attached_db.table1; /* Add a comit */ COMMIT; DROP TABLE attached_db.table1; -- Error: Table is locked Yves Goergen <[EMAIL PROTECTED]> wrote: Hi, I want to modify the