Doug Currie <doug.currie-re5jqeeqqe8avxtiumw...@public.gmane.org> writes: > On Aug 24, 2010, at 10:57 AM, Nikolaus Rath wrote: > >> Nikolaus Rath >> <nikolaus-bth8mxji4b0-xmd5yjdbdmrexy1tmh2...@public.gmane.org> >> writes: >>> Still no one able to clarify the issues raised in this thread? >>> >>> Let me try to summarize what I still don't understand: >>> >>> - Will SQLite acquire and release an EXCLUSIVE lock while keeping a >>> SHARED lock if one executes a UPDATE query with one cursor while a >>> different cursor is in the middle of a SELECT query, >>> >>> -or- >>> >>> will the EXCLUSIVE lock be held until the SELECT query finishes? > > If you want the main thread to hold an exclusive lock until the work [...]
Thanks for the recipe, but that still doesn't really answer my question. Or did I miss something? Best, -Nikolaus -- »Time flies like an arrow, fruit flies like a Banana.« PGP fingerprint: 5B93 61F8 4EA2 E279 ABF6 02CF A9AD B7F8 AE4E 425C _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
