On Apr 14, 2:49 am, Shawn <[email protected]> wrote: > I just executed multiple operations inside a transaction: > > db.transaction do > > # db op1 > # db op2 > # db op3 > ... > end > > op3 was an explicit SQL operation (db << sql_string), and it failed > due to a syntax error. However, operations 1 and 2 took effect did > not rollback. Why not?
Probably because the database doesn't support transactions for what you are doing. For example, MySQL's MyISAM table engine (the default I believe) doesn't support transactions, and a few databases including MySQL don't support transactions for schema modifications. Jeremy -- You received this message because you are subscribed to the Google Groups "sequel-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/sequel-talk?hl=en.
