From a6ed4794a3bdd65a491746d106f80a6c26aefc7b Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Thu, 3 Jun 1999 20:44:28 +0000 Subject: 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 { ' now. for Vadim --- doc/src/sgml/ref/set.sgml | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) (limited to 'doc/src') diff --git a/doc/src/sgml/ref/set.sgml b/doc/src/sgml/ref/set.sgml index cf9fbf22fb7..5a8ca84d098 100644 --- a/doc/src/sgml/ref/set.sgml +++ b/doc/src/sgml/ref/set.sgml @@ -534,7 +534,7 @@ SET TIME ZONE { 'timezone' | LOCAL - Sets the isolation level for transactions. + Sets the isolation level for the current transaction. @@ -543,7 +543,7 @@ SET TIME ZONE { 'timezone' | LOCAL - Sets the isolation level for transactions to + Sets the isolation level for the current transaction to 'SERIALIZABLE' or 'READ COMMITTED'. @@ -556,7 +556,7 @@ SET TIME ZONE { 'timezone' | LOCAL - Sets the isolation level for transactions to + Sets the isolation level for the current transaction to 'SERIALIZABLE' or 'COMMITTED'. -- cgit v1.2.3