On Nov 10, 2009, at 11:55 AM, Craig Kimerer wrote:
> That only works if you have transactions disabled for your
> database. If your connections are using transactions, you still
> have the race condition.
The example you give isn't exactly the same as the suggestion. In the
suggestion, it includes a comparison of the bid amount in the WHERE
clause:
UPDATE bid = new_bid WHERE id = id and bid < new_bid;
That's what makes it work. Lacking that, you're absolutely right, the
race condition remains.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Django users" group.
To post to this group, send email to django-users@googlegroups.com
To unsubscribe from this group, send email to
django-users+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/django-users?hl=en
-~----------~----~----~----~------~----~------~--~---
