Hi Scott, Thanks. In case it helps others, it is explained here:
http://stackoverflow.com/questions/6690458/innodb-select-for-update-statement-locking-all-rows-in-a-table Setting transaction to Read Committed did not work for me though, but creating an index on UpdateLockForFoo did the trick. Thanks! On Tuesday, April 3, 2012 4:42:12 PM UTC+1, Scott Ribe wrote: > > On Apr 2, 2012, at 4:33 PM, PierreW wrote: > > > My > > understanding was that :lock => true only locks a specific record, but > > it seems it is not the case and it locks the entire table. > > That depends on what kind of locking the underlying database offers. Which > with MySQL depends on the storage manager you're using. > > -- > Scott Ribe > [email protected] > http://www.elevated-dev.com/ > (303) 722-0567 voice > > > -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To view this discussion on the web visit https://groups.google.com/d/msg/rubyonrails-talk/-/RwdXaau3WIEJ. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
