> So how do you propose to have consistency and isolation if SELECT does not > create an automatic transaction if no explicit transaction exists?
I think this is a misunderstanding which might explain your first email reply. I do not propose any change for sqlite, but I wasted 2 days debugging and reading every page in sqlite documentation (locks, transactions, isolation, error description) did not help me. So I just want the documentation to be improved. I would change the error description for SQLITE_BUSY_SNAPSHOT so that it no longer says "read transaction" but instead says "read transaction or ongoing select statement". And the first sentence in "transactions" should be changed to indicated that select statement also create implicit read transactions. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
