aboutsummaryrefslogtreecommitdiff
path: root/src
diff options
context:
space:
mode:
authordan <Dan Kennedy>2025-03-05 19:39:02 +0000
committerdan <Dan Kennedy>2025-03-05 19:39:02 +0000
commitfc9b5d2a95fa28d81c72ab4e3bdaa08a65b223e0 (patch)
tree12f5cb391cb7e7bb9ce3b3ee06060429ec973ce2 /src
parentbee4fb401eb2b8ef7138b3cea2a53b4e12f5e2ed (diff)
downloadsqlite-fc9b5d2a95fa28d81c72ab4e3bdaa08a65b223e0.tar.gz
sqlite-fc9b5d2a95fa28d81c72ab4e3bdaa08a65b223e0.zip
Have the recover module add "PRAGMA foreign_keys = off" to SQL output. Have the shell tool add ".dbconfig defensive off".
FossilOrigin-Name: dcfe3d3292851aa48a085a2c68623b049e2786c8dc7154ccc78508443973b5a1
Diffstat (limited to 'src')
-rw-r--r--src/shell.c.in1
1 files changed, 1 insertions, 0 deletions
diff --git a/src/shell.c.in b/src/shell.c.in
index 1717f76d4..f4451d292 100644
--- a/src/shell.c.in
+++ b/src/shell.c.in
@@ -8183,6 +8183,7 @@ static int recoverDatabaseCmd(ShellState *pState, int nArg, char **azArg){
sqlite3_recover_config(p, SQLITE_RECOVER_ROWIDS, (void*)&bRowids);
sqlite3_recover_config(p, SQLITE_RECOVER_FREELIST_CORRUPT,(void*)&bFreelist);
+ sqlite3_fprintf(pState->out, ".dbconfig defensive off\n");
sqlite3_recover_run(p);
if( sqlite3_recover_errcode(p)!=SQLITE_OK ){
const char *zErr = sqlite3_recover_errmsg(p);