COMMIT (l)
Commits the current transaction
SYNOPSIS
COMMIT [ WORK | TRANSACTION ]
WORK
TRANSACTION
Optional keywords. They have no effect.
END
Message returned if the transaction is successfully committed.
NOTICE EndTransactionBlock and not inprogress/abort state
If there is no transaction in progress.
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.
The keywords WORK and TRANSACTION are noise and can be omitted.
Use rollback(l)
to abort a transaction.
USAGE
COMMIT WORK;
COMPATIBILITY
|