Re[2]: [PEAR-DEV] mysql and transactions

On Thursday, July 26, 2001, 10:14:52 PM, in message "[PEAR-DEV] mysql and transactions", Tomas wrote: TVVC> Oleg Rekutin wrote: >> >> Yes. Note, however, that MySQL has only two table types that >> support transactions: BDB and InnoDB. The rest are >> non-transaction-safe tables. While I see no big problem with >> imlpementing somethign like DB_mysql::commit () as >> $this->query("COMMIT"), I wonder what should the proper action be >> in case of non-transaction-safe tables, which are probably the >> kinds of tables in use in 90% of MySQL installations today (blind >> guess, but you get the idea). TVVC> The mysql extension (as all others) has the feature array with the TVVC> transactions field. To avoid problems the guys who knows that their TVVC> tables support transactions will want to set this param to true to be TVVC> able to use transaction methods. :-? Isn't that too much of a hack? The DB reports that it can't do transactions and suddenly the programmer says: "well, I'm gonna make you do them by changing your capabilities flags! There, you can do transactions now." - Oleg