> > On 22 Sep 2014, at 1:13pm, Paul <de...@ukr.net> wrote: > > > The only thing I am worried about is whether > > > > pragma user_version=n; > > > > respects transactions and will be rolled back automatically in case > > if something happens between that statement and COMMIT. > > SQLite version 3.8.5 2014-08-15 22:37:57 > Enter ".help" for usage hints. > sqlite> pragma user_version; > 0 > sqlite> pragma user_version=1; > sqlite> pragma user_version; > 1 > sqlite> BEGIN; > sqlite> pragma user_version=2; > sqlite> pragma user_version; > 2 > sqlite> END; > sqlite> pragma user_version; > 2 > sqlite> BEGIN; > sqlite> pragma user_version=3; > sqlite> pragma user_version; > 3 > sqlite> ROLLBACK; > sqlite> pragma user_version; > 2 > sqlite> > > It would appear that that PRAGMA is transaction-compliant and > transaction-safe. > > Simon.
Thanks, Simon. My head is too slow today. I don't know why I din't came up with such a simple idea to experiment with CLI :/ I can also use strace to see if sqlite does any writes to file system if I create transaction but do only selects. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
