From 1aac32df89eb19949050f6f27c268122833ad036 Mon Sep 17 00:00:00 2001 From: Alexander Korotkov Date: Wed, 8 Apr 2020 11:37:27 +0300 Subject: Revert 0f5ca02f53 0f5ca02f53 introduces 3 new keywords. It appears to be too much for relatively small feature. Given now we past feature freeze, it's already late for discussion of the new syntax. So, revert. Discussion: https://postgr.es/m/28209.1586294824%40sss.pgh.pa.us --- doc/src/sgml/ref/begin.sgml | 17 +---------------- doc/src/sgml/ref/start_transaction.sgml | 17 +---------------- 2 files changed, 2 insertions(+), 32 deletions(-) (limited to 'doc/src') diff --git a/doc/src/sgml/ref/begin.sgml b/doc/src/sgml/ref/begin.sgml index 66d9ad7cb23..c23bbfb4e71 100644 --- a/doc/src/sgml/ref/begin.sgml +++ b/doc/src/sgml/ref/begin.sgml @@ -21,7 +21,7 @@ PostgreSQL documentation -BEGIN [ WORK | TRANSACTION ] [ transaction_mode [, ...] ] [ WAIT FOR LSN lsn_value [TIMEOUT number_of_milliseconds ] ] +BEGIN [ WORK | TRANSACTION ] [ transaction_mode [, ...] ] where transaction_mode is one of: @@ -63,17 +63,6 @@ BEGIN [ WORK | TRANSACTION ] [ transaction_mode was executed. - - - The WAIT FOR clause allows to wait for the target log - sequence number (LSN) to be replayed on standby before - starting the transaction in PostgreSQL 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 LSN was not reached before timeout, transaction - doesn't begin. Waiting can be interrupted by cancelling - BEGIN command. - @@ -157,10 +146,6 @@ BEGIN; different purpose in embedded SQL. You are advised to be careful about the transaction semantics when porting database applications. - - - There is no WAIT FOR clause in the SQL standard. - diff --git a/doc/src/sgml/ref/start_transaction.sgml b/doc/src/sgml/ref/start_transaction.sgml index b94ab00b403..d6cd1d41779 100644 --- a/doc/src/sgml/ref/start_transaction.sgml +++ b/doc/src/sgml/ref/start_transaction.sgml @@ -21,7 +21,7 @@ PostgreSQL documentation -START TRANSACTION [ transaction_mode [, ...] ] [ WAIT FOR LSN lsn_value [TIMEOUT number_of_milliseconds ] ] +START TRANSACTION [ transaction_mode [, ...] ] where transaction_mode is one of: @@ -40,17 +40,6 @@ START TRANSACTION [ transaction_mode was executed. This is the same as the command. - - - The WAIT FOR clause allows to wait for the target log - sequence number (LSN) to be replayed on standby before - starting the transaction in PostgreSQL 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 LSN was not reached before timeout, transaction - doesn't begin. Waiting can be interrupted by cancelling - START TRANSACTION command. - @@ -89,10 +78,6 @@ START TRANSACTION [ transaction_mode - - There is no WAIT FOR clause in the SQL standard. - - See also the compatibility section of . -- cgit v1.2.3