diff options
author | Thomas G. Lockhart <lockhart@fourpalms.org> | 1998-05-13 05:34:00 +0000 |
---|---|---|
committer | Thomas G. Lockhart <lockhart@fourpalms.org> | 1998-05-13 05:34:00 +0000 |
commit | 7402eda97c4d1903f4c63b3a05af749b740d5e91 (patch) | |
tree | c7aaebaaf37268bee6219186c1362ac6d9b11580 /doc/src/sgml/ref/commit.sgml | |
parent | 2608ec8169d450a981ef2108005c95ffed3e8c37 (diff) | |
download | postgresql-7402eda97c4d1903f4c63b3a05af749b740d5e91.tar.gz postgresql-7402eda97c4d1903f4c63b3a05af749b740d5e91.zip |
First files for reference pages.
Diffstat (limited to 'doc/src/sgml/ref/commit.sgml')
-rw-r--r-- | doc/src/sgml/ref/commit.sgml | 179 |
1 files changed, 179 insertions, 0 deletions
diff --git a/doc/src/sgml/ref/commit.sgml b/doc/src/sgml/ref/commit.sgml new file mode 100644 index 00000000000..63c9dbdc4e1 --- /dev/null +++ b/doc/src/sgml/ref/commit.sgml @@ -0,0 +1,179 @@ +<REFENTRY ID="SQL-COMMIT-1"> + <REFMETA> + <REFENTRYTITLE> + COMMIT + </REFENTRYTITLE> + <REFMISCINFO>SQL - Language Statements</REFMISCINFO> + </REFMETA> + <REFNAMEDIV> + <REFNAME> + COMMIT + </REFNAME> + <REFPURPOSE> + Commits the current transaction + </REFPURPOSE> + + + <REFSYNOPSISDIV> + <REFSYNOPSISDIVINFO> + <DATE>1998-04-15</DATE> + </REFSYNOPSISDIVINFO> + <SYNOPSIS> + COMMIT [ WORK ] + </SYNOPSIS> + + <REFSECT2 ID="R2-SQL-COMMIT-1"> + <REFSECT2INFO> + <DATE>1998-04-15</DATE> + </REFSECT2INFO> + <TITLE> + Inputs + </TITLE> + <PARA> + </PARA> + <VARIABLELIST> + <VARLISTENTRY> + <TERM> + </TERM> + <LISTITEM> + <PARA> + <VARIABLELIST> + <VARLISTENTRY> + <TERM> + <ReturnValue>None</ReturnValue> + </TERM> + <LISTITEM> + <PARA> + </PARA> + </LISTITEM> + </VARLISTENTRY> + </variablelist> + </LISTITEM> + </VARLISTENTRY> + </VARIABLELIST> + + </REFSECT2> + + <REFSECT2 ID="R2-SQL-COMMIT-2"> + <REFSECT2INFO> + <DATE>1998-04-15</DATE> + </REFSECT2INFO> + <TITLE> + Outputs + </TITLE> + <PARA> + </PARA> + <VARIABLELIST> + <VARLISTENTRY> + <TERM> + </TERM> + <LISTITEM> + <PARA> + <VARIABLELIST> + <VARLISTENTRY> + <TERM> + <ReturnValue>END</ReturnValue> + </TERM> + <LISTITEM> + <PARA> +Message returned if the transaction is successfully committed. + </PARA> + </LISTITEM> + </VARLISTENTRY> + <VARLISTENTRY> + <TERM> + <ReturnValue>NOTICE EndTransactionBlock and not inprogress/abort state +</ReturnValue> + </TERM> + <LISTITEM> + <PARA> +If there is no transaction in progress. + </PARA> + </LISTITEM> + </VARLISTENTRY> + </variablelist> + </LISTITEM> + </VARLISTENTRY> + </VARIABLELIST> + </REFSECT2> + </REFSYNOPSISDIV> + + <REFSECT1 ID="R1-SQL-COMMIT-1"> + <REFSECT1INFO> + <DATE>1998-04-15</DATE> + </REFSECT1INFO> + <TITLE> + Description + </TITLE> + <PARA> + 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. + </PARA> + + <REFSECT2 ID="R2-SQL-COMMIT-3"> + <REFSECT2INFO> + <DATE>1998-04-15</DATE> + </REFSECT2INFO> + <TITLE> + Notes + </TITLE> + <PARA> + The keyword WORK is noise and can be omitted. + </PARA> + <para> + Refer to ROLLBACK statements to abort a transaction. + </para> + </REFSECT2> + </refsect1> + + <REFSECT1 ID="R1-SQL-COMMIT-2"> + <TITLE> + Usage + </TITLE> + <PARA> +To make all changes permanent: + </PARA> + <ProgramListing> + COMMIT WORK; + </ProgramListing> + </REFSECT1> + + <REFSECT1 ID="R1-SQL-COMMIT-3"> + <TITLE> + Compatibility +</TITLE> + <PARA> + </PARA> + + <REFSECT2 ID="R2-SQL-COMMIT-4"> + <REFSECT2INFO> + <DATE>1998-04-15</DATE> + </REFSECT2INFO> + <TITLE> + SQL92 + </TITLE> + <PARA> + Full compatibility. + </PARA> + </refsect2> + </refsect1> +</REFENTRY> + + +<!-- Keep this comment at the end of the file +Local variables: +mode: sgml +sgml-omittag:t +sgml-shorttag:t +sgml-minimize-attributes:nil +sgml-always-quote-attributes:t +sgml-indent-step:1 +sgml-indent-data:t +sgml-parent-document:nil +sgml-default-dtd-file:"../reference.ced" +sgml-exposed-tags:nil +sgml-local-catalogs:"/usr/lib/sgml/catalog" +sgml-local-ecat-files:nil +End: +--> |