Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Be sure to mention that PRAGMA foreign_keys is a no-op within a transaction. |
|---|---|
| Downloads: | Tarball | ZIP archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
a802dbe3fbf6d0979de534d400910211 |
| User & Date: | drh 2009-11-14 17:00:44.000 |
Context
|
2009-11-15
| ||
| 03:59 | Add start of html fts3 documentation. This is very much a work in progress. (check-in: 8c18d00b27 user: dan tags: trunk) | |
|
2009-11-14
| ||
| 17:00 | Be sure to mention that PRAGMA foreign_keys is a no-op within a transaction. (check-in: a802dbe3fb user: drh tags: trunk) | |
| 15:21 | Updates to the well-known-users page - added dropbox.com. Removed monotone and philips. (check-in: 419c5f2b1e user: drh tags: trunk) | |
Changes
Changes to pages/pragma.in.
| ︙ | ︙ | |||
264 265 266 267 268 269 270 271 272 273 274 275 276 277 |
as the main database.</p>
</li>
<tcl>Subsection foreign_keys</tcl>
<li><p><b>PRAGMA foreign_keys;
<br>PRAGMA foreign_keys = </b><i>boolean</i><b>;</b></p>
<p>Query, set, or clear the enforcement of [foreign key constraints].
<p>Changing this setting affects the execution of all statements prepared
using the database connection, including those prepared before the
setting was changed. Any existing statements prepared using the legacy
[sqlite3_prepare()] interface may fail with an [SQLITE_SCHEMA] error
after this setting is changed.
| > > > > | 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 279 280 281 |
as the main database.</p>
</li>
<tcl>Subsection foreign_keys</tcl>
<li><p><b>PRAGMA foreign_keys;
<br>PRAGMA foreign_keys = </b><i>boolean</i><b>;</b></p>
<p>Query, set, or clear the enforcement of [foreign key constraints].
<p>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].
<p>Changing this setting affects the execution of all statements prepared
using the database connection, including those prepared before the
setting was changed. Any existing statements prepared using the legacy
[sqlite3_prepare()] interface may fail with an [SQLITE_SCHEMA] error
after this setting is changed.
|
| ︙ | ︙ |