From 5e45211a64149b3c659b90ff2de6fa982a5a93ed Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sat, 4 May 2024 14:17:33 +0200 Subject: Adding upstream version 15.5. Signed-off-by: Daniel Baumann --- doc/src/sgml/ref/commit.sgml | 112 +++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 112 insertions(+) create mode 100644 doc/src/sgml/ref/commit.sgml (limited to 'doc/src/sgml/ref/commit.sgml') diff --git a/doc/src/sgml/ref/commit.sgml b/doc/src/sgml/ref/commit.sgml new file mode 100644 index 0000000..5f244cd --- /dev/null +++ b/doc/src/sgml/ref/commit.sgml @@ -0,0 +1,112 @@ + + + + + COMMIT + + + + COMMIT + 7 + SQL - Language Statements + + + + COMMIT + commit the current transaction + + + + +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 + + + chained transactions + + + + + 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 ) as the just finished one. Otherwise, + no new transaction is started. + + + + + + + + Notes + + + Use 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 + + + + + + + -- cgit v1.2.3