Author torsten
Recipients asvetlov, dholth, ghaering, r.david.murray, scott.urban, torsten
Date 2011-03-29.07:39:29
SpamBayes Score 0.000546991
Marked as misclassified No
Message-id <1301384370.53.0.687542654255.issue10740@psf.upfronthosting.co.za>
In-reply-to
Content
> Torsten basically you are suggesting that PRAGMA would never work at all with my 'do not strcmp() the sql at all, always begin a transaction' approach?

No. Most pragmas should still work and getting the current setting of a pragma should also work.

I was only referring to http://www.sqlite.org/pragma.html#pragma_foreign_keys

Quote:

> This pragma is a no-op within a transaction; foreign key constraint enforcement may only be enabled or disabled when there is no pending BEGIN or SAVEPOINT.

I did not see such a restriction for other pragmas though I admit that I did not reread the list in full.
History
Date User Action Args
2011-03-29 07:39:30torstensetrecipients: + torsten, ghaering, r.david.murray, asvetlov, dholth, scott.urban
2011-03-29 07:39:30torstensetmessageid: <1301384370.53.0.687542654255.issue10740@psf.upfronthosting.co.za>
2011-03-29 07:39:29torstenlinkissue10740 messages
2011-03-29 07:39:29torstencreate