summaryrefslogtreecommitdiff
path: root/doc/src
diff options
context:
space:
mode:
authorBruce Momjian1999-06-04 03:44:42 +0000
committerBruce Momjian1999-06-04 03:44:42 +0000
commit5a7547d3fc2d257e7d6fde34ca785d52488a6449 (patch)
tree438b3378b98e1a273d228de030bce129ae518124 /doc/src
parent74e7b58b617de4e4d4479cc9b93b6ce718fc0206 (diff)
Add description for SET TRANSACTION.
Diffstat (limited to 'doc/src')
-rw-r--r--doc/src/sgml/ref/set.sgml7
1 files changed, 6 insertions, 1 deletions
diff --git a/doc/src/sgml/ref/set.sgml b/doc/src/sgml/ref/set.sgml
index ec4b1baa897..2b203e7698b 100644
--- a/doc/src/sgml/ref/set.sgml
+++ b/doc/src/sgml/ref/set.sgml
@@ -545,6 +545,11 @@ SET TIME ZONE { '<REPLACEABLE CLASS="PARAMETER">timezone</REPLACEABLE>' | LOCAL
<para>
Sets the isolation level for the current transaction to
'SERIALIZABLE' or 'READ COMMITTED'.
+ SERIALIZABLE means that the current transaction will place a
+ lock on every row read, so later reads in that transaction
+ see the rows unmodified by other transactions.
+ READ COMMITTED means that the current transaction reads only
+ committed rows. READ COMMITTED is the default.
</para>
</listitem>
</varlistentry>
@@ -557,7 +562,7 @@ SET TIME ZONE { '<REPLACEABLE CLASS="PARAMETER">timezone</REPLACEABLE>' | LOCAL
<listitem>
<para>
Sets the isolation level for the current transaction to
- 'SERIALIZABLE' or 'READ COMMITTED'.
+ 'READ COMMITTED'.
</para>
</listitem>
</varlistentry>