Re: [sqlite] Can an online backup happen during a nested transaction?

2010-05-11 Thread Dan Kennedy 

On May 12, 2010, at 2:53 AM, Shaun Seckman (Firaxis) wrote:

> Hello,
>
>I'm attempting to save a backup of my in-memory  
> database
> using the online backup routines.  I noticed that I cannot seem to  
> make
> backups of the database when there is a pending save point.  The error
> code is SQLITE_BUSY.  Is this the expected behavior?  Are there any  
> ways
> to make this work without committing the transaction?

sqlite3_busy_step() always returns SQLITE_BUSY if there is a
write transaction open on the source database handle. No way
around this at present.

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Can an online backup happen during a nested transaction?

2010-05-11 Thread Shaun Seckman (Firaxis) 
Hello,

I'm attempting to save a backup of my in-memory database
using the online backup routines.  I noticed that I cannot seem to make
backups of the database when there is a pending save point.  The error
code is SQLITE_BUSY.  Is this the expected behavior?  Are there any ways
to make this work without committing the transaction?

 

-Shaun

 

 

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users