On Wed, 9 May 2018 at 11:13 Simon Slavin <slav...@bigfraud.org> wrote:

> On 8 May 2018, at 1:12pm, Simon Slavin <slav...@bigfraud.org> wrote:
> > 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.
> On 9 May 2018, at 1:50am, Donald Shepherd <donald.sheph...@gmail.com>
> wrote:
> > Having just tested that (for alternate purposes), it doesn't work.  The
> > sqlite3_backup_step calls following a "BEGIN IMMEDIATE" instruction
> > returned SQLITE_LOCKED.
> Oops.  I assume you did the lock using the same connetion that was calling
> the backup API.  In which case I apologise for the incorrect information.
> Simon.

I did mean to mention that I made sure I ran it on the same connection, so

To be honest I expected it to work too so I already had it on my list of
test cases.

Donald Shepherd.
sqlite-users mailing list

Reply via email to