Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Update pragma documentation to describe the parameters to the wal_checkpoint pragma that follow from the addition of sqlite3_wal_checkpoint_v2(). |
|---|---|
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
aefb07aa9004f48e951e980cef64bf8e |
| User & Date: | drh 2011-02-10 20:25:25 |
Context
|
2011-02-10
| ||
| 20:30 | Update the index page and the change log for 3.7.6. check-in: a7fc545076 user: drh tags: trunk | |
| 20:25 | Update pragma documentation to describe the parameters to the wal_checkpoint pragma that follow from the addition of sqlite3_wal_checkpoint_v2(). check-in: aefb07aa90 user: drh tags: trunk | |
|
2011-02-05
| ||
| 17:00 | Update the description of fts4aux in fts3.in to account for recent changes. check-in: 8e18201f14 user: dan tags: trunk | |
Changes
Changes to pages/pragma.in.
1033 1034 1035 1036 1037 1038 1039 1040 1041 1042 1043 1044 1045 1046 1047 1048 1049 1050 1051 1052 1053 1054 1055 |
executes normally after the listing is printed.
This feature is used for debugging SQLite itself. See the
<a href="vdbe.html#trace">VDBE documentation</a> for more
information.</p>
}
Pragma wal_checkpoint {
<p><b>PRAGMA </b><i>database</i><b>.wal_checkpoint;</b></p>
<p>^If the [write-ahead log] is enabled (via the [journal_mode pragma]),
this pragma causes a checkpoint operation to run on database
<i>database</i>, or on all attached databases if <i>database</i>
is omitted. ^If [write-ahead log] is disabled, this pragma is a
harmless no-op.</p>
<p>^Invoking this pragma is equivalent to calling the
[sqlite3_wal_checkpoint()] C interface.</p>
}
Pragma wal_autocheckpoint {
<p><b>PRAGMA wal_autocheckpoint;<br>
PRAGMA wal_autocheckpoint=</b><i>N</i><b>;</b></p>
|
| > > > > > > > > |
1033 1034 1035 1036 1037 1038 1039 1040 1041 1042 1043 1044 1045 1046 1047 1048 1049 1050 1051 1052 1053 1054 1055 1056 1057 1058 1059 1060 1061 1062 1063 |
executes normally after the listing is printed.
This feature is used for debugging SQLite itself. See the
<a href="vdbe.html#trace">VDBE documentation</a> for more
information.</p>
}
Pragma wal_checkpoint {
<p><b>PRAGMA </b><i>database</i><b>.wal_checkpoint;</b><br>
<b>PRAGMA </b><i>database</i><b>.wal_checkpoint(PASSIVE);</b><br>
<b>PRAGMA </b><i>database</i><b>.wal_checkpoint(FULL);</b><br>
<b>PRAGMA </b><i>database</i><b>.wal_checkpoint(RESET);</b>
</p>
<p>^If the [write-ahead log] is enabled (via the [journal_mode pragma]),
this pragma causes a checkpoint operation to run on database
<i>database</i>, or on all attached databases if <i>database</i>
is omitted. ^If [write-ahead log] is disabled, this pragma is a
harmless no-op.</p>
<p>^Invoking this pragma is equivalent to calling the
[sqlite3_wal_checkpoint_v2()] C interface with a
[SQLITE_CHECKPOINT_PASSIVE | 3rd parameter]
corresponding to the argument of the PRAGMA. ^Invoking this
pragma without an argument is equivalent to calling the
[sqlite3_wal_checkpoint()] C interface.</p>
}
Pragma wal_autocheckpoint {
<p><b>PRAGMA wal_autocheckpoint;<br>
PRAGMA wal_autocheckpoint=</b><i>N</i><b>;</b></p>
|