On 27 mai, 01:17, Sebastian Noack <[EMAIL PROTECTED]>
wrote:

[snip]

> Even if it is done by many parallel connections, because of
> transactions are managed by the DBMS too and ensure atomicity,
> consistency, isolation and durability of each transaction
>
[snip]

The problem is that DBMS don't use the same default isolation level.
Many DBMS use a read committed default, some a repeatable read and
very few a serializable level.
Some DBMS are even unable to support serializable.
The "for update" clause generally implied a repeatable read.

Read committed allow another transaction to update a record previously
read by your transaction.
Repeatable read allow phantom which mean that if you redo a select new
records can appear.

For more information on isoloation level you can read
http://en.wikipedia.org/wiki/Isolation_(computer_science)


JF
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"Django developers" group.
To post to this group, send email to django-developers@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/django-developers?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to