Re: [sqlite] means for explicitly escalating a transaction from RESERVED to PENDING/EXCLUSIVE

2006-05-05 Thread drh
"Pat Wibbeler" <[EMAIL PROTECTED]> wrote: > Is there a means for explicitly escalating an existing transaction from > RESERVED to EXCLUSIVE (either through issuing sql statements or the C > API)? > No there isn't. If you need to prevent other processes from reading the database (presumably to

[sqlite] means for explicitly escalating a transaction from RESERVED to PENDING/EXCLUSIVE

2006-05-04 Thread Pat Wibbeler
Is there a means for explicitly escalating an existing transaction from RESERVED to EXCLUSIVE (either through issuing sql statements or the C API)? I'm using the following locking strategy: * Read only transactions start with a BEGIN and allow sqlite to escalate to SHARED on read. * Transactions