This documentation is for an unsupported version of PostgreSQL.
You may want to view the same page for the
version, or one of the supported versions listed above instead.
COMMIT -- Commits the current
COMMIT [ WORK | TRANSACTION ]
- WORK, TRANSACTION
Optional keywords. They have no effect.
Message returned if the transaction is successfully
- NOTICE: COMMIT: no
transaction in progress
If there is no transaction in progress.
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
Use ROLLBACK to
abort a transaction.
To make all changes permanent:
SQL92 only specifies the two
forms COMMIT and COMMIT WORK. Otherwise full compatibility.