summaryrefslogtreecommitdiff
path: root/src/man/set.l
diff options
context:
space:
mode:
authorVadim B. Mikheev1999-06-09 03:51:40 +0000
committerVadim B. Mikheev1999-06-09 03:51:40 +0000
commit0e41fd57df6760f8978045cd27fd8de94e085964 (patch)
treedcb195c4077709737bc48dc0f887fcff908e3e27 /src/man/set.l
parentc0b4b42c92b7f3243959de6241349a54444e1bb2 (diff)
MVCC updates.
Diffstat (limited to 'src/man/set.l')
-rw-r--r--src/man/set.l23
1 files changed, 9 insertions, 14 deletions
diff --git a/src/man/set.l b/src/man/set.l
index 15c64baca7d..23ecae07e74 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.21 1999/06/04 03:44:42 momjian Exp $
+.\" $Header: /cvsroot/pgsql/src/man/Attic/set.l,v 1.22 1999/06/09 03:51:40 vadim Exp $
.TH SET SQL 05/14/97 PostgreSQL PostgreSQL
.SH NAME
set - set run-time parameters for session
@@ -81,19 +81,14 @@ The default is unlimited.
.IR TIMEZONE
sets your timezone.
.PP
-.I TRANSACTION ISOLATION LEVEL
-sets the current transaction's isolation level to
-.IR SERIALIZABLE
-or
-.IR READ COMMITTED .
-.IR 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.
-.IR READ COMMITTED
-means that the current transaction reads only committed rows.
-.IR READ COMMITTED
-is the default.
+\fITRANSACTION ISOLATION LEVEL\fR sets the current transaction's isolation
+level to \fI SERIALIZABLE\fR or \fIREAD COMMITTED\fR. \fISERIALIZABLE\fR
+means that the current transaction queries will read only rows committed
+before first DML statement (SELECT/INSERT/DELETE/UPDATE/FETCH/COPY_TO) was
+executed in this transaction. \fIREAD COMMITTED\fR means that the current
+transaction queries will read only rows committed before a query began.
+\fIREAD COMMITTED\fR is the default. \fBNote\fR: SQL92 standard requires
+\fISERIALIZABLE\fR to be the default isolation level.
.PP
.IR CLIENT_ENCODING|NAMES
sets the character set encoding of the client. Only available if multi-byte