Dokumentaro de Gambaso
Compilation & Installation
Components
Documents
Indekso de Lingvo
Language Overviews
LeguMin
Lexicon
Component
Gambaso
Registro

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.