Home > def > transaction 
 fr de es it nl pl pt pt_BR mk sq ca hu cs tr ar fa id vi ko ja ru zh zh_TW eo
Previous  Next  Edit  Rename  Undo  Refresh  Search  Administration  
Documentation
History
 
transaction
A transaction is a series of changes to a database which either all must succeed or all must fail, for example, when transferring money from a checking account to a savings account, either the money can first be added to the savings account, then subtracted from the checking account, or first subtracted from the checking account, then added to the savings account. If for some reason one of these fails, the other must not be completed.

A transaction is started with the DB.Begin method, is done when either it is completed by use of the DB.Commit method, or fails by use of the DB.Rollback method.

Within MySQL, transactions can only be executed with transaction safe tables: BDB and InnoDB. The other MySQL table types (ISAM, MyISAM and HEAP) commit immediately.

PostgreSQL does not support nested transactions, so only the first call to DB.Begin and the last call to DB.Commit or DB.Rollback are effective.