Re: [sqlite] Lock type for SAVEPOINT

Nikolaus Rath <Nikolaus@xxxxxxxx> wrote:
> When there is no transaction active and I issue a SAVEPOINT command,
> does that start an IMMEDIATE, EXCLUSIVE or DEFERRED transaction?

http://sqlite.org/lang_savepoint.html

"When a SAVEPOINT is the outer-most savepoint and it is not within a 
BEGIN...COMMIT then the behavior is the same as BEGIN DEFERRED 
TRANSACTION"

> And
> is there any way I can influence this?

Start your transaction with BEGIN.

Igor Tandetnik



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