Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
Comment: | Update the documentation to explain that the journal_mode must be set prior to the first transaction. CVSTrac ticket #3811. |
---|---|
Downloads: | Tarball | ZIP archive |
Timelines: | family | ancestors | descendants | both | trunk |
Files: | files | file ages | folders |
SHA1: |
3a4c37b08b682746540c3ec1ce5e97f2 |
User & Date: | drh 2009-04-20 13:29:44.000 |
Context
2009-04-20
| ||
17:43 | Update documentation to describe how pragma journal_mode will work as long as there is no pending transaction. (check-in: 8bb233e0af user: drh tags: trunk) | |
13:29 | Update the documentation to explain that the journal_mode must be set prior to the first transaction. CVSTrac ticket #3811. (check-in: 3a4c37b08b user: drh tags: trunk) | |
2009-04-17
| ||
12:30 | Added documentation on the SQLITE_HAVE_ISNAN compile-time option. (check-in: d1b62a10d5 user: drh tags: trunk) | |
Changes
Changes to pages/pragma.in.
︙ | ︙ | |||
366 367 368 369 370 371 372 373 374 375 376 377 378 379 | <p>The OFF journaling mode disables the rollback journal completely. No rollback journal is ever created and hence there is never a rollback journal to delete. The OFF journaling mode disables the atomic commit and rollback capabilities of SQLite. The [ROLLBACK] command no longer works. If the application crashes in the middle of a transaction when the OFF journaling mode is set, then the database file will very likely go corrupt.</p> <p>Note that the journal_mode for an [in-memory database] is either MEMORY or OFF and can not be changed to a different value. An attempt to change the journal_mode of an [in-memory database] to any setting other than MEMORY or OFF is silently ignored.</p> </li> | > > > > > > > > > > > > > | 366 367 368 369 370 371 372 373 374 375 376 377 378 379 380 381 382 383 384 385 386 387 388 389 390 391 392 | <p>The OFF journaling mode disables the rollback journal completely. No rollback journal is ever created and hence there is never a rollback journal to delete. The OFF journaling mode disables the atomic commit and rollback capabilities of SQLite. The [ROLLBACK] command no longer works. If the application crashes in the middle of a transaction when the OFF journaling mode is set, then the database file will very likely go corrupt.</p> <p>In order for a change in journal_mode to be effective, that change must occur prior to executing any transaction on the database file. Attempt to change the journal mode after the first transaction has been executed might report success and might report the new journal mode is set, when in reality the original journal mode could still be in force. It is undefined whether or not a journal_mode change is effective after one or more transactions have been run. The only reliable way to modify the journal mode is to change it prior to the first transaction. If an application must change the journal_mode after one or more transactions have occurred, the only reliable way to do so is to close and reopen the database connection.</p> <p>Note that the journal_mode for an [in-memory database] is either MEMORY or OFF and can not be changed to a different value. An attempt to change the journal_mode of an [in-memory database] to any setting other than MEMORY or OFF is silently ignored.</p> </li> |
︙ | ︙ |