From 7c084d148f314504c2bab794b1999d1fd9314400 Mon Sep 17 00:00:00 2001 From: Peter Eisentraut Date: Tue, 15 Apr 2003 13:25:08 +0000 Subject: Bring SQL ref pages to consistent format, part 1. --- doc/src/sgml/ref/commit.sgml | 185 ++++++++++++++++--------------------------- 1 file changed, 70 insertions(+), 115 deletions(-) (limited to 'doc/src/sgml/ref/commit.sgml') diff --git a/doc/src/sgml/ref/commit.sgml b/doc/src/sgml/ref/commit.sgml index 77c56238ebb..a84c61a9011 100644 --- a/doc/src/sgml/ref/commit.sgml +++ b/doc/src/sgml/ref/commit.sgml @@ -1,5 +1,5 @@ @@ -8,141 +8,96 @@ PostgreSQL documentation COMMIT SQL - Language Statements + - - COMMIT - - - commit the current transaction - + COMMIT + commit the current transaction - - 1999-07-20 - - + COMMIT [ WORK | TRANSACTION ] - - - - - 1998-09-08 - - - Inputs - - - - - - WORK - TRANSACTION - - - Optional keywords. They have no effect. - - - - - - - - - - 1998-09-08 - - - Outputs - - - - - - -COMMIT - - - - Message returned if the transaction is successfully committed. - - - - - -WARNING: COMMIT: no transaction in progress - - - - If there is no transaction in progress. - - - - - - + - - - 1998-09-08 - - - Description - + + 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. + - - - 1998-09-08 - - - Notes - - - The keywords WORK and TRANSACTION are noise and can be omitted. - + + Parameters - - Use - to abort a transaction. - - + + + WORK + TRANSACTION + + + Optional key words. They have no effect. + + + + + + + Diagnostics + + + + COMMIT + + + Message returned if the transaction was successfully committed. + + + + + + WARNING: COMMIT: no transaction in progress + + + Message if there is no transaction in progress. + + + + + + + + Notes - - - Usage - - To make all changes permanent: - -COMMIT WORK; - + Use to + abort a transaction. + + + + + Examples + + + To commit the current transaction and make all changes permanent: + +COMMIT; + - - - Compatibility - + + Compatibility - - - 1998-09-08 - - - SQL92 - - - SQL92 only specifies the two forms COMMIT - and COMMIT WORK. Otherwise full compatibility. - - + + The SQL standard only specifies the two forms + COMMIT and COMMIT + WORK. Otherwise, this command is fully conforming. + -- cgit v1.2.3