Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commita6ed479

Browse files
committed
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE;
SET TRANSACTION ISOLATION LEVEL READ COMMITTED; ^^^^ requiredAlso note that SET TRANSACTION ISOLATION LEVEL changeisolevel for _current_ transaction, in accordance withstandard, 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 theseSET TIME ZONE { '<REPLACEABLE>now.for Vadim
1 parent155b580 commita6ed479

File tree

2 files changed

+5
-5
lines changed

2 files changed

+5
-5
lines changed

‎doc/src/sgml/ref/set.sgml

Lines changed: 3 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -534,7 +534,7 @@ SET TIME ZONE { '<REPLACEABLE CLASS="PARAMETER">timezone</REPLACEABLE>' | LOCAL
534534
</term>
535535
<listitem>
536536
<para>
537-
Sets the isolation level fortransactions.
537+
Sets the isolation level forthe current transaction.
538538

539539
<variablelist>
540540
<varlistentry>
@@ -543,7 +543,7 @@ SET TIME ZONE { '<REPLACEABLE CLASS="PARAMETER">timezone</REPLACEABLE>' | LOCAL
543543
</term>
544544
<listitem>
545545
<para>
546-
Sets the isolation level fortransactions to
546+
Sets the isolation level forthe current transaction to
547547
'SERIALIZABLE' or 'READ COMMITTED'.
548548
</para>
549549
</listitem>
@@ -556,7 +556,7 @@ SET TIME ZONE { '<REPLACEABLE CLASS="PARAMETER">timezone</REPLACEABLE>' | LOCAL
556556
</term>
557557
<listitem>
558558
<para>
559-
Sets the isolation level fortransactions to
559+
Sets the isolation level forthe current transaction to
560560
'SERIALIZABLE' or 'COMMITTED'.
561561
</para>
562562
</listitem>

‎src/man/set.l

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -1,6 +1,6 @@
11
.\" This is -*-nroff-*-
22
.\" XXX standard disclaimer belongs here....
3-
.\" $Header: /cvsroot/pgsql/src/man/Attic/set.l,v 1.19 1999/06/03 20:42:18 momjian Exp $
3+
.\" $Header: /cvsroot/pgsql/src/man/Attic/set.l,v 1.20 1999/06/03 20:44:28 momjian Exp $
44
.TH SET SQL 05/14/97 PostgreSQL PostgreSQL
55
.SH NAME
66
set - set run-time parameters for session
@@ -82,7 +82,7 @@ The default is unlimited.
8282
sets your timezone.
8383
.PP
8484
.ITRANSACTIONISOLATIONLEVEL
85-
sets the transaction isolation level to
85+
sets thecurrenttransaction's isolation level to
8686
.IR SERIALIZABLE
8787
or
8888
.IR READCOMMITTED .

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp