Hello, a question from beginner please :
In this transaction (with wal-mode) : BEGIN TRANSACTION INSERT INTO.... SELECT last_insert_rowid() COMMIT Are we sure that another process is not going to create another row between my "INSERT" and "SELECT LAST ROWID"? The "LAST ROWID" is it for sure the id of "INSERT INTO" of the transaction? In fact, is the lock that starts with INSERT is set to COMMIT? Or the write lock is it only when the INSERT? (so no lock between INSERT and COMMIT) Thank you olivier _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users