diff options
author | Vadim B. Mikheev | 1999-06-09 03:51:40 +0000 |
---|---|---|
committer | Vadim B. Mikheev | 1999-06-09 03:51:40 +0000 |
commit | 0e41fd57df6760f8978045cd27fd8de94e085964 (patch) | |
tree | dcb195c4077709737bc48dc0f887fcff908e3e27 /src/man/set.l | |
parent | c0b4b42c92b7f3243959de6241349a54444e1bb2 (diff) |
MVCC updates.
Diffstat (limited to 'src/man/set.l')
-rw-r--r-- | src/man/set.l | 23 |
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 |