On Apr 3, 7:52 pm, PierreW <[email protected]> wrote: > Hi Scott, > > Thanks. In case it helps others, it is explained here: > > http://stackoverflow.com/questions/6690458/innodb-select-for-update-s... > > Setting transaction to Read Committed did not work for me though, but > creating an index on UpdateLockForFoo did the trick. > InnoDB's row level locks are actually index-range locks - if there is no index for the column you are using to select the records to lock then this will result in locking the whole table.
Fred -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. 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.
