Really, there's no need for such determination. MyISAM will look at BEGIN, COMMIT and ROLLBACK statements and do the only thing that makes sense - ignore them. No syntax error will result.
Basically, you could have all code as transaction safe and still work with MyISAM tables. Usage of FULLTEXT-reliant predicates is more of a concern in the MyISAM vs InnoDB support debate. Regards, Chris <quote who="Christian G. Warden"> > On Thu, Aug 28, 2003 at 01:35:48PM +0200, Ilja Booij wrote: >> sorry, no transactions. I'd like for dbmail to use them, but currently >> there is MySQL ISAM table support. These ISAM tables do not support >> Transactions. >> >> Anyone have any thoughts on why we should keep support for ISAM tables >> in dbmail? Dropping this and going of innoDB only on MySQL seems like a >> good idea to me. > > Any reason why it can't be determined at runtime whether or not to wrap > queries in a transaction? > > xn > _______________________________________________ > Dbmail-dev mailing list > Dbmail-dev@dbmail.org > http://twister.fastxs.net/mailman/listinfo/dbmail-dev >
