diff options
| author | Bruce Momjian | 1999-06-03 20:44:28 +0000 |
|---|---|---|
| committer | Bruce Momjian | 1999-06-03 20:44:28 +0000 |
| commit | a6ed4794a3bdd65a491746d106f80a6c26aefc7b (patch) | |
| tree | 9fd5da84b9e0a43a020d777c418ee0a6d299075d /doc/src | |
| parent | 155b5808cac496eef1dd2602694a934530cedcd7 (diff) | |
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
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/ref/set.sgml | 6 |
1 files changed, 3 insertions, 3 deletions
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 { '<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> |