Re: [sqlite] PRAGMA temp_store confusion

2008-07-01 Thread Mihai Limbasan
Roger Binns wrote: Where is the appropriate place to discuss 3.6 issues? For example in my case I have very strong feelings about error codes vs return values in the VFS api. The sqlite-dev mailing list would be a good place. ___ sqlite-users

Re: [sqlite] PRAGMA temp_store confusion

2008-06-30 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 D. Richard Hipp wrote: > http://www.sqlite.org/draft/doc/35to36.html Where is the appropriate place to discuss 3.6 issues? For example in my case I have very strong feelings about error codes vs return values in the VFS api. Roger -BEGIN

Re: [sqlite] PRAGMA temp_store confusion

2008-06-30 Thread Shawn Wilsher
On Mon, Jun 30, 2008 at 6:41 PM, D. Richard Hipp <[EMAIL PROTECTED]> wrote: > The default TEMP_STORE is 1, not 0. The default "PRAGMA temp_store" > is 0. TEMP_STORE=1 means that temporary storage defaults to a file > but can be overridden by the temp_store pragma. Alright, cool. > Temporary

Re: [sqlite] PRAGMA temp_store confusion

2008-06-30 Thread D. Richard Hipp
On Jun 30, 2008, at 4:48 PM, Shawn Wilsher wrote: > Hey all, > > Over at mozilla we are looking into using more temporary tables, and > likely want them all to be in memory as opposed to files. I was > looking at http://sqlite.org/pragma.html#pragma_temp_store, and > noticed the table, which

[sqlite] PRAGMA temp_store confusion

2008-06-30 Thread Shawn Wilsher
Hey all, Over at mozilla we are looking into using more temporary tables, and likely want them all to be in memory as opposed to files. I was looking at http://sqlite.org/pragma.html#pragma_temp_store, and noticed the table, which seems to imply that if TEMP_STORE is either zero or not defined,