Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Add documentation of the SQLITE_DEFAULT_FOREIGN_KEY compile-time parameter. |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
d606802b48281cff49cad1d6ee76cb55 |
| User & Date: | drh 2010-12-16 17:20:17 |
Context
|
2010-12-17
| ||
| 17:49 | Add entries to the download.in page for snapshot shells for windows. (check-in: 02ac129c98 user: drh tags: trunk) | |
|
2010-12-16
| ||
| 17:20 | Add documentation of the SQLITE_DEFAULT_FOREIGN_KEY compile-time parameter. (check-in: d606802b48 user: drh tags: trunk) | |
| 17:19 | Fix a detail of the case_sensitive_like pragma documentation to more accurately describe what really happens. (check-in: 78d484e889 user: drh tags: trunk) | |
Changes
Changes to pages/compile.in.
65 66 67 68 69 70 71 72 73 74 75 76 77 78 |
be able to read and write database files created by newer versions
of SQLite, the default file format is set to 1 for maximum
compatibility.
The file format for a new database can be set at runtime using
the [PRAGMA legacy_file_format] command.
}
COMPILE_OPTION {SQLITE_DEFAULT_JOURNAL_SIZE_LIMIT=<i><bytes></i>} {
This option sets the size limit on rollback journal files in
[journal_mode pragma | persistent journal mode]. When this
compile-time option is omitted there is no upper bound on the
size of the rollback journal file. The journal file size limit
can be changed at run-time using the [journal_size_limit pragma].
|
> > > > > > > > > > |
65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 |
be able to read and write database files created by newer versions of SQLite, the default file format is set to 1 for maximum compatibility. The file format for a new database can be set at runtime using the [PRAGMA legacy_file_format] command. } COMPILE_OPTION {SQLITE_DEFAULT_FOREIGN_KEYS=<i><0 or 1></i>} { This macro determines whether enforcement of [foreign key constraints] is enabled or disabled by default for new database connections. Each database connection can always turn enforcement of foreign key constraints on and off and run-time using the [foreign_keys pragma]. Enforcement of foreign key constraints is normally off by default, but if this compile-time parameter is set to 1, enforcement of foreign key constraints will be on by default. } COMPILE_OPTION {SQLITE_DEFAULT_JOURNAL_SIZE_LIMIT=<i><bytes></i>} { This option sets the size limit on rollback journal files in [journal_mode pragma | persistent journal mode]. When this compile-time option is omitted there is no upper bound on the size of the rollback journal file. The journal file size limit can be changed at run-time using the [journal_size_limit pragma]. |