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. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
