[sqlite] can't drop a temp table because database table is locked

2018-03-07 Thread Nir
xists TEMP_TABLE_NAME;] database table is locked6 is this a known issue? is there a workaround for this? i'm using sqlite version 3.17.0. Thanks, Nir -- Sent from: http://sqlite.1065341.n5.nabble.com/ ___ sqlite-users mailing list sq

Re: [sqlite] can't drop a temp table because database table is locked

2018-03-07 Thread Nir
If I understand you correctly then all I need to do in order for the database not to be locked would be to reset a prepared query right after I retrieve the needed data. after reseting I can either drop a temp table or bind another value to my prepared statement and rerun a query. right? Is there

[sqlite] sqlite 3.2.8 segmentation fault

2007-06-10 Thread Rachmel, Nir (Nir)
ere it frees a pointer twice? Is there some kind of known race condition that causes a double free? Is this a known issue? Is there more information I can gather to better understand this error? Thanks in advance, Nir.

RE: [sqlite] sqlite 3.2.8 segmentation fault

2007-06-11 Thread Rachmel, Nir (Nir)
/sqlite_new/avaya_build_target' make: *** [build] Error 2 Any ideas as to what is the problem? Thanks, Nir. -Original Message- From: Joe Wilson [mailto:[EMAIL PROTECTED] Sent: Sunday, June 10, 2007 6:10 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] sqlite 3.2.8 segment

[sqlite] Sqlite 3.4.0 - problem with prompt

2007-08-16 Thread Rachmel, Nir (Nir)
27;-DHAVE_READLINE=0'; export LIBREADLINE='' (however this worked just find with 3.2.8!!) I would appreciate your help, Thanks, Nir.

RE: [sqlite] Sqlite 3.4.0 - problem with prompt

2007-08-16 Thread Rachmel, Nir (Nir)
Tried without this line - it still doesn't work. Any ideas? Thanks, Nir. -Original Message- From: Joe Wilson [mailto:[EMAIL PROTECTED] Sent: Thursday, August 16, 2007 4:16 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Sqlite 3.4.0 - problem with prompt You want to e

RE: [sqlite] Sqlite 3.4.0 - problem with prompt

2007-08-19 Thread Rachmel, Nir (Nir)
message from the Makefile: /home/rachmel/build/target/root/usr/local/include: file not recognized: Is a directory Thanks, Nir. -Original Message- From: John Stanton [mailto:[EMAIL PROTECTED] Sent: Friday, August 17, 2007 12:46 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Sqlite 3.

RE: [sqlite] Sqlite 3.4.0 - problem with prompt

2007-08-19 Thread Rachmel, Nir (Nir)
OK, got it solved. Just changed the generated Makefile manually, and bypassed the configure script. Thanks for the help. Nir. -Original Message- From: Rachmel, Nir (Nir) [mailto:[EMAIL PROTECTED] Sent: Sunday, August 19, 2007 11:01 AM To: sqlite-users@sqlite.org Subject: RE: [sqlite

[sqlite] can't open db when path length extends 512 characters (on linux)

2017-01-30 Thread Nir Paz
Hi All, I get the next error: SQLITE_CANTOPEN when calling sqlite3_open_v2 with filename exceeding 512 characters. Linux doesn't have that limit, my thought is to change the define of MAX_PATHNAME, is there a better option? Thanks, Nir ___ s