On Tue, 8 May 2018 at 22:12 Simon Slavin <[email protected]> wrote:
> On 8 May 2018, at 10:56am, R Smith <[email protected]> wrote: > > > Thank you for clarifying - but it is still my understanding that the DB > is not locked (if only in WAL mode), so the backup API, even with -1, > either must ignore changes, or restart. My proposed flag is to lock rather > than restart or ignore. > > You can lock the database yourself, using BEGIN EXCLUSIVE or BEGIN > IMMEDIATE depending on which you want. Then do all the backup stuff, then > COMMIT or ROLLBACK without having changed anything. > > Simon. > Having just tested that (for alternate purposes), it doesn't work. The sqlite3_backup_step calls following a "BEGIN IMMEDIATE" instruction returned SQLITE_LOCKED. Regards, Donald Shepherd. _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
