Documentation Source Text

Check-in [9523519a73]
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Correction to the PRAGMA secure_delete documentation.
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: 9523519a73fad290e1fca261e1e83191c37a19ae
User & Date: drh 2010-02-13 15:43:27
Context
2010-02-15
13:41
Editorial changes to the unlock-notify application note. check-in: e5ce924181 user: drh tags: trunk
2010-02-13
15:43
Correction to the PRAGMA secure_delete documentation. check-in: 9523519a73 user: drh tags: trunk
2010-02-12
19:58
Update the secure_delete pragma documentation to conform to the latest implementation. check-in: e4d2cd7fd1 user: drh tags: trunk
Changes
Hide Diffs Unified Diffs Ignore Whitespace Patch

Changes to pages/pragma.in.

639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
       <br>PRAGMA </b><i>database</i><b>.secure_delete =
               </b><i>boolean</i></p>
    <p>Query or change the secure-delete setting.)^ ^When secure-delete
    on, SQLite overwrites deleted content with zeros.  ^The default
    setting is determined by the [SQLITE_SECURE_DELETE]
    compile-time option.

    <p>
    ^This pragma sets or clears the secure-delete flag when the pragma is
    prepared, not when the resulting prepared statement is run.  ^The
    prepared statement for this pragma merely returns the value of the
    secure-delete setting at the time the statement was prepared.  One should
    not retain or reuse the prepared statement for this pragma.

    <p>
    ^When there are [ATTACH | attached databases] and no database
    is specified in the pragma, all databases have their secure-delete
    setting altered and the return value is the value of the main database.
    ^The secure-delete setting for newly attached databases is the setting
    of the main database at the time the ATTACH command is evaluated.

    <p>
    ^When multiple database connections share the same cache, changing
    the secure-delete flag on one database connection changes it for them
    all.







<
<
<
<
<
<
<



|







639
640
641
642
643
644
645







646
647
648
649
650
651
652
653
654
655
656
       <br>PRAGMA </b><i>database</i><b>.secure_delete =
               </b><i>boolean</i></p>
    <p>Query or change the secure-delete setting.)^ ^When secure-delete
    on, SQLite overwrites deleted content with zeros.  ^The default
    setting is determined by the [SQLITE_SECURE_DELETE]
    compile-time option.








    <p>
    ^When there are [ATTACH | attached databases] and no database
    is specified in the pragma, all databases have their secure-delete
    setting altered.
    ^The secure-delete setting for newly attached databases is the setting
    of the main database at the time the ATTACH command is evaluated.

    <p>
    ^When multiple database connections share the same cache, changing
    the secure-delete flag on one database connection changes it for them
    all.