From a6ed4794a3bdd65a491746d106f80a6c26aefc7b Mon Sep 17 00:00:00 2001
From: Bruce Momjian <bruce@momjian.us>
Date: Thu, 3 Jun 1999 20:44:28 +0000
Subject: [PATCH] SET TRANSACTION ISOLATION LEVEL SERIALIZABLE; SET TRANSACTION
 ISOLATION LEVEL READ COMMITTED;                                 ^^^^ required

Also note that SET TRANSACTION ISOLATION LEVEL change
isolevel for _current_ transaction, in accordance with
standard, not for session (ALTER SESSION is used in Oracle,
but it's not implemented currently).

And I would don't mention SET XACTISOLEVEL TO ...
form at all.

Please update set.sgml - I failed to understand all these

SET TIME ZONE { '<REPLACEABLE CLASS="PARAMETER">

now.


for Vadim
---
 doc/src/sgml/ref/set.sgml | 6 +++---
 src/man/set.l             | 4 ++--
 2 files changed, 5 insertions(+), 5 deletions(-)

diff --git a/doc/src/sgml/ref/set.sgml b/doc/src/sgml/ref/set.sgml
index cf9fbf22fb..5a8ca84d09 100644
--- a/doc/src/sgml/ref/set.sgml
+++ b/doc/src/sgml/ref/set.sgml
@@ -534,7 +534,7 @@ SET TIME ZONE { '<REPLACEABLE CLASS="PARAMETER">timezone</REPLACEABLE>' | LOCAL
       </term>
       <listitem>
        <para>
-	Sets the isolation level for transactions.
+	Sets the isolation level for the current transaction.
 	
 	<variablelist>
 	 <varlistentry>
@@ -543,7 +543,7 @@ SET TIME ZONE { '<REPLACEABLE CLASS="PARAMETER">timezone</REPLACEABLE>' | LOCAL
 	  </term>
 	  <listitem>
 	   <para>
-		Sets the isolation level for transactions to
+		Sets the isolation level for the current transaction to
 		'SERIALIZABLE' or 'READ COMMITTED'.
 	   </para>
 	  </listitem>
@@ -556,7 +556,7 @@ SET TIME ZONE { '<REPLACEABLE CLASS="PARAMETER">timezone</REPLACEABLE>' | LOCAL
 	  </term>
 	  <listitem>
 	   <para>
-		Sets the isolation level for transactions to
+		Sets the isolation level for the current transaction to
 		'SERIALIZABLE' or 'COMMITTED'.
 	   </para>
 	  </listitem>
diff --git a/src/man/set.l b/src/man/set.l
index c281e9eaac..9a4cf7f9fb 100644
--- a/src/man/set.l
+++ b/src/man/set.l
@@ -1,6 +1,6 @@
 .\" This is -*-nroff-*-
 .\" XXX standard disclaimer belongs here....
-.\" $Header: /cvsroot/pgsql/src/man/Attic/set.l,v 1.19 1999/06/03 20:42:18 momjian Exp $
+.\" $Header: /cvsroot/pgsql/src/man/Attic/set.l,v 1.20 1999/06/03 20:44:28 momjian Exp $
 .TH SET SQL 05/14/97 PostgreSQL PostgreSQL
 .SH NAME
 set - set run-time parameters for session
@@ -82,7 +82,7 @@ The default is unlimited.
 sets your timezone.
 .PP
 .I TRANSACTION ISOLATION LEVEL
-sets the transaction isolation level to
+sets the current transaction's isolation level to
 .IR SERIALIZABLE
 or
 .IR READ COMMITTED .
-- 
2.40.0