Historical version. PostgreSQL 6.5 has reached end of support. See the current manual.
COMMIT
Name
COMMIT — Commits the current transactionCOMMIT [ WORK | TRANSACTION ]
Inputs
None.
Outputs
- 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.
Notes
The keywords WORK and TRANSACTION are noise and can be omitted.
Use ROLLBACK [source reference unavailable] [source chapter] to abort a transaction.
Usage
To make all changes permanent:
COMMIT WORK;
Compatibility
SQL92
Full compatibility.
Report a documentation issue
Read the upstream documentation. For corrections, first check the current manual.
Historical source references (1)
Some targets are absent from this original edition. Those references are marked in the text; the original URI remains available here.
sql-rollback.htm#SQL-ROLLBACK-TITLE