Re: [sqlite] Inconsistent error: "temporary storage cannot be changed from within a transaction"

On Thu, Jul 17, 2008 at 12:53 PM, D. Richard Hipp <[EMAIL PROTECTED]> wrote: > > The error only occurs if the temp_store value really is trying to > change. If the new temp_store value is the same as the old, no error > is generated. Are you sure you had not already issued the PRAGMA once > befo

Re: [sqlite] Inconsistent error: "temporary storage cannot be changed from within a transaction"

On Jul 17, 2008, at 12:11 PM, Samuel Neff wrote: > We're inconsistently getting this error: > >PRAGMA temp_store = MEMORY > ---> System.Data.SQLite.SQLiteException: SQLite error > temporary storage cannot be changed from within a transaction > > We now realize that we are in fact issuing the

[sqlite] Inconsistent error: "temporary storage cannot be changed from within a transaction"

We're inconsistently getting this error: PRAGMA temp_store = MEMORY ---> System.Data.SQLite.SQLiteException: SQLite error temporary storage cannot be changed from within a transaction We now realize that we are in fact issuing the PRAGMA inside a transaction, but the weird thing is it works