[sqlite] auto commits

[Will Leshner]

I have a question about modifying an SQLite database when not in an explicit transaction. My understanding is that in that case SQLite automatically begins a transaction at the beginning of the command and then automatically commits the database (and thus closes the transaction) at the end of the command. So, for example, if I do an UPDATE without first doing a BEGIN TRANSACTION, then at the end of the UPDATE, my database will automatically be committed and I don't then need to call COMMIT. First I just want to make sure that my understanding is correct. Second, I've been told that such behavior doesn't match the SQL standard (even though there are other database engines, such as PostgreSQL, that also work that way). So my question is, what does the standard have to say about automatic commits outside of transactions and does SQLite follow the standard?

Thanks.

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]