Content-Length: 301184 | pFad | http://github.com/postgrespro/postgres/commit/9ca5c8721dfa2413e910531373395c6e18062ddf

56 Document two phase commit commands in ecpg docu. · postgrespro/postgres@9ca5c87 · GitHub
Skip to content

Commit 9ca5c87

Browse files
author
Michael Meskes
committed
Document two phase commit commands in ecpg docu.
Patch by Masahiko Sawada
1 parent 42fcad6 commit 9ca5c87

File tree

1 file changed

+29
-0
lines changed

1 file changed

+29
-0
lines changed

doc/src/sgml/ecpg.sgml

Lines changed: 29 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -507,6 +507,35 @@ EXEC SQL COMMIT;
507507
</listitem>
508508
</varlistentry>
509509

510+
<variablelist>
511+
<varlistentry>
512+
<term><literal>EXEC SQL PREPARE TRANSACTION </literal><replaceable class="PARAMETER">transaction_id</></term>
513+
<listitem>
514+
<para>
515+
Prepare the current transaction for two-phase commit.
516+
</para>
517+
</listitem>
518+
</varlistentry>
519+
520+
<variablelist>
521+
<varlistentry>
522+
<term><literal>EXEC SQL COMMIT PREPARED </literal><replaceable class="PARAMETER">transaction_id</></term>
523+
<listitem>
524+
<para>
525+
Commit a transaction that is in prepared state.
526+
</para>
527+
</listitem>
528+
</varlistentry>
529+
530+
<varlistentry>
531+
<term><literal>EXEC SQL ROLLBACK PREPARED </literal><replaceable class="PARAMETER">transaction_id</></term>
532+
<listitem>
533+
<para>
534+
Roll back a transaction that is in prepared state.
535+
</para>
536+
</listitem>
537+
</varlistentry>
538+
510539
<varlistentry>
511540
<term><literal>EXEC SQL SET AUTOCOMMIT TO ON</literal></term>
512541
<listitem>

0 commit comments

Comments
 (0)








ApplySandwichStrip

pFad - (p)hone/(F)rame/(a)nonymizer/(d)eclutterfier!      Saves Data!


--- a PPN by Garber Painting Akron. With Image Size Reduction included!

Fetched URL: http://github.com/postgrespro/postgres/commit/9ca5c8721dfa2413e910531373395c6e18062ddf

Alternative Proxies:

Alternative Proxy

pFad Proxy

pFad v3 Proxy

pFad v4 Proxy