diff options
Diffstat (limited to 'doc/src')
-rw-r--r-- | doc/src/sgml/ref/begin.sgml | 17 | ||||
-rw-r--r-- | doc/src/sgml/ref/start_transaction.sgml | 17 |
2 files changed, 32 insertions, 2 deletions
diff --git a/doc/src/sgml/ref/begin.sgml b/doc/src/sgml/ref/begin.sgml index c23bbfb4e71..66d9ad7cb23 100644 --- a/doc/src/sgml/ref/begin.sgml +++ b/doc/src/sgml/ref/begin.sgml @@ -21,7 +21,7 @@ PostgreSQL documentation <refsynopsisdiv> <synopsis> -BEGIN [ WORK | TRANSACTION ] [ <replaceable class="parameter">transaction_mode</replaceable> [, ...] ] +BEGIN [ WORK | TRANSACTION ] [ <replaceable class="parameter">transaction_mode</replaceable> [, ...] ] [ WAIT FOR LSN <replaceable class="parameter">lsn_value</replaceable> [TIMEOUT <replaceable class="parameter">number_of_milliseconds</replaceable> ] ] <phrase>where <replaceable class="parameter">transaction_mode</replaceable> is one of:</phrase> @@ -63,6 +63,17 @@ BEGIN [ WORK | TRANSACTION ] [ <replaceable class="parameter">transaction_mode</ <xref linkend="sql-set-transaction"/> was executed. </para> + + <para> + The <literal>WAIT FOR</literal> clause allows to wait for the target log + sequence number (<acronym>LSN</acronym>) to be replayed on standby before + starting the transaction in <productname>PostgreSQL</productname> databases + with master-standby asynchronous replication. Wait time can be limited by + specifying a timeout, which is measured in milliseconds and must be a positive + integer. If <acronym>LSN</acronym> was not reached before timeout, transaction + doesn't begin. Waiting can be interrupted by cancelling + <literal>BEGIN</literal> command. + </para> </refsect1> <refsect1> @@ -146,6 +157,10 @@ BEGIN; different purpose in embedded SQL. You are advised to be careful about the transaction semantics when porting database applications. </para> + + <para> + There is no <literal>WAIT FOR</literal> clause in the SQL standard. + </para> </refsect1> <refsect1> diff --git a/doc/src/sgml/ref/start_transaction.sgml b/doc/src/sgml/ref/start_transaction.sgml index d6cd1d41779..b94ab00b403 100644 --- a/doc/src/sgml/ref/start_transaction.sgml +++ b/doc/src/sgml/ref/start_transaction.sgml @@ -21,7 +21,7 @@ PostgreSQL documentation <refsynopsisdiv> <synopsis> -START TRANSACTION [ <replaceable class="parameter">transaction_mode</replaceable> [, ...] ] +START TRANSACTION [ <replaceable class="parameter">transaction_mode</replaceable> [, ...] ] [ WAIT FOR LSN <replaceable class="parameter">lsn_value</replaceable> [TIMEOUT <replaceable class="parameter">number_of_milliseconds</replaceable> ] ] <phrase>where <replaceable class="parameter">transaction_mode</replaceable> is one of:</phrase> @@ -40,6 +40,17 @@ START TRANSACTION [ <replaceable class="parameter">transaction_mode</replaceable characteristics, as if <xref linkend="sql-set-transaction"/> was executed. This is the same as the <xref linkend="sql-begin"/> command. </para> + + <para> + The <literal>WAIT FOR</literal> clause allows to wait for the target log + sequence number (<acronym>LSN</acronym>) to be replayed on standby before + starting the transaction in <productname>PostgreSQL</productname> databases + with master-standby asynchronous replication. Wait time can be limited by + specifying a timeout, which is measured in milliseconds and must be a positive + integer. If <acronym>LSN</acronym> was not reached before timeout, transaction + doesn't begin. Waiting can be interrupted by cancelling + <literal>START TRANSACTION</literal> command. + </para> </refsect1> <refsect1> @@ -79,6 +90,10 @@ START TRANSACTION [ <replaceable class="parameter">transaction_mode</replaceable </para> <para> + There is no <literal>WAIT FOR</literal> clause in the SQL standard. + </para> + + <para> See also the compatibility section of <xref linkend="sql-set-transaction"/>. </para> </refsect1> |