Message132470
| Author |
torsten |
| Recipients |
asvetlov, dholth, ghaering, r.david.murray, scott.urban, torsten |
| Date |
2011年03月29日.07:39:29 |
| SpamBayes Score |
0.0005469911 |
| 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. |
|