PHP Manual

PEAR Manual

Smarty Manual

PostgreSQL

MySQL Manual

Perl Manual

postgresql 8.2devel documentation
prevfast backwardfast forwardnext

commit

name

commit -- commit the current transaction

synopsis

commit [ work | transaction ]

description

commit commits the current transaction. all changes made by the transaction become visible to others and are guaranteed to be durable if a crash occurs.

parameters

work
transaction

optional key words. they have no effect.

notes

use rollback to abort a transaction.

issuing commit when not inside a transaction does no harm, but it will provoke a warning message.

examples

to commit the current transaction and make all changes permanent: 

commit;

compatibility

the sql standard only specifies the two forms commit and commit work. otherwise, this command is fully conforming.

see also

begin, rollback
prevhomenext
commentupcommit prepared