Add support for "PRAGMA writable_schema=RESET".

FossilOrigin-Name: a51b305bd068f8d8e85b9fc38d61cdf5957f3a2ad2eb2e77015547910088e681

1 files changed, 8 insertions, 0 deletions

diff --git a/src/pragma.c b/src/pragma.c
index 8bac04726..b997408b9 100644
--- a/src/pragma.c
+++ b/src/pragma.c
@@ -1117,6 +1117,14 @@ void sqlite3Pragma(
       }else{
         db->flags &= ~mask;
         if( mask==SQLITE_DeferFKs ) db->nDeferredImmCons = 0;
+        if( (mask & SQLITE_WriteSchema)!=0
+         && sqlite3_stricmp(zRight, "reset")==0
+        ){
+          /* "PRAGMA writable_schema=RESET" turns schema writing off, just
+          ** like "PRAGMA writable_schema=OFF, but also causes the schema
+          ** to be reloaded. */
+          sqlite3ResetAllSchemasOfConnection(db);
+        }
       }
 
       /* Many of the flag-pragmas modify the code generated by the SQL