end7l
Commit the current transaction
Usage
END [ WORK | TRANSACTION ]
Inputs
- WORK
- TRANSACTION
-
Optional keywords. They have no effect.
Outputs
- COMMIT
-
Message returned if the transaction is successfully committed.
- NOTICE: COMMIT: no transaction in progress
-
If there is no transaction in progress.
Overview
END is a PostgreSQL extension, and is a synonym for the SQL92-compatible COMMIT [commit(l)].
Notes
The keywords WORK and TRANSACTION are noise and can be omitted.
Use ROLLBACK [rollback(l)] to abort a transaction.
Usage
To make all changes permanent:
END WORK;
Compatibility
SQL92
END is a PostgreSQL extension which provides functionality equivalent to COMMIT [commit(l)].
Releases
6 releases since Debian 1.2 (Rex); the text changed 4 times.