From 6eb9c5a5657d1fe77b55cc261450f3538d35a94d Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sat, 4 May 2024 14:19:15 +0200 Subject: Adding upstream version 13.4. Signed-off-by: Daniel Baumann --- doc/src/sgml/html/sql-commit.html | 28 ++++++++++++++++++++++++++++ 1 file changed, 28 insertions(+) create mode 100644 doc/src/sgml/html/sql-commit.html (limited to 'doc/src/sgml/html/sql-commit.html') diff --git a/doc/src/sgml/html/sql-commit.html b/doc/src/sgml/html/sql-commit.html new file mode 100644 index 0000000..7d5b720 --- /dev/null +++ b/doc/src/sgml/html/sql-commit.html @@ -0,0 +1,28 @@ + +COMMIT
COMMIT
Prev UpSQL CommandsHome Next

COMMIT

COMMIT — commit the current transaction

Synopsis

+COMMIT [ WORK | TRANSACTION ] [ AND [ NO ] CHAIN ]
+

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. +

AND CHAIN

+ If AND CHAIN is specified, a new transaction is + immediately started with the same transaction characteristics (see SET TRANSACTION) as the just finished one. Otherwise, + no new transaction is started. +

Notes

+ Use ROLLBACK to + abort a transaction. +

+ Issuing COMMIT when not inside a transaction does + no harm, but it will provoke a warning message. COMMIT AND + CHAIN when not inside a transaction is an error. +

Examples

+ To commit the current transaction and make all changes permanent: +

+COMMIT;
+

Compatibility

+ The command COMMIT conforms to the SQL standard. The + form COMMIT TRANSACTION is a PostgreSQL extension. +

See Also

BEGIN, ROLLBACK
Prev Up Next
COMMENT Home COMMIT PREPARED
\ No newline at end of file -- cgit v1.2.3