"...postgres-fd-implementation.git" did not exist on "d62c25d452d48dc56ae90b9a9e74f9d6859f430a"
commit_prepared.sgml 2.39 KB
Newer Older
1
<!--
2
$PostgreSQL: pgsql/doc/src/sgml/ref/commit_prepared.sgml,v 1.3 2006/09/16 00:30:17 momjian Exp $
3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67
PostgreSQL documentation
-->

<refentry id="SQL-COMMIT-PREPARED">
 <refmeta>
  <refentrytitle id="sql-commit-prepared-title">COMMIT PREPARED</refentrytitle>
  <refmiscinfo>SQL - Language Statements</refmiscinfo>
 </refmeta>

 <refnamediv>
  <refname>COMMIT PREPARED</refname>
  <refpurpose>commit a transaction that was earlier prepared for two-phase commit</refpurpose>
 </refnamediv>

 <indexterm zone="sql-commit-prepared">
  <primary>COMMIT PREPARED</primary>
 </indexterm>

 <refsynopsisdiv>
<synopsis>
COMMIT PREPARED <replaceable class="PARAMETER">transaction_id</replaceable>
</synopsis>
 </refsynopsisdiv>

 <refsect1>
  <title>Description</title>

  <para>
   <command>COMMIT PREPARED</command> commits a transaction that is in 
   prepared state.
  </para>
 </refsect1>

 <refsect1>
  <title>Parameters</title>

  <variablelist>
   <varlistentry>
    <term><replaceable class="PARAMETER">transaction_id</replaceable></term>
    <listitem>
     <para>
      The transaction identifier of the transaction that is to be
      committed.
     </para>
    </listitem>
   </varlistentry>
  </variablelist>
 </refsect1>

 <refsect1>
  <title>Notes</title>

  <para>
   To commit a prepared transaction, you must be either the same user that
   executed the transaction originally, or a superuser.  But you do not
   have to be in the same session that executed the transaction.
  </para>

  <para>
   This command cannot be executed inside a transaction block. The prepared
   transaction is committed immediately.
  </para>

  <para>
   All currently available prepared transactions are listed in the
68 69
   <link linkend="view-pg-prepared-xacts"><structname>pg_prepared_xacts</structname></link>
   system view.
70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95
  </para>
 </refsect1>

 <refsect1 id="sql-commit-prepared-examples">
  <title id="sql-commit-prepared-examples-title">Examples</title>
  <para>
   Commit the transaction identified by the transaction
   identifier <literal>foobar</>:
   
<programlisting>
COMMIT PREPARED 'foobar';
</programlisting>
  </para>

 </refsect1>

 <refsect1>
  <title>See Also</title>

  <simplelist type="inline">
   <member><xref linkend="sql-prepare-transaction" endterm="sql-prepare-transaction-title"></member>
   <member><xref linkend="sql-rollback-prepared" endterm="sql-rollback-prepared-title"></member>
  </simplelist>
 </refsect1>

</refentry>