> Le 30 janv. 2020 à 15:05, Peng Yu <pengyu...@gmail.com> a écrit : > > https://www.sqlite.org/tempfiles.html > > The above page says that there should be a journal file. > > "The PERSIST journal mode foregoes the deletion of the journal file > and instead overwrites the rollback journal header with zeros, which > prevents other processes from rolling back the journal and thus has > the same effect as deleting the journal file, though without the > expense of actually removing the file from disk." > > But I don't see it. Does anybody why I don't see the journal file? > What does "normal" printed mean? > > $ sqlite3 /tmp/dbfile -header -separator $'\t' <<EOF > pragma locking_mode=persist;
Minor confusion between the pragma locking_mode and pragma journal_mode. You want pragma journal_mode=persist here, not pragma locking_mode=persist, which does not exists. ⏤ Best Regards, Meilleures salutations, Met vriendelijke groeten, Mit freundlichen Grüßen, Olivier Mascia _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
