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

Commit4a077ca

Browse files
committed
Add SET TRANSACTION ISOLATION LEVEL and SET NAMES mention.
1 parent7857241 commit4a077ca

File tree

3 files changed

+83
-10
lines changed

3 files changed

+83
-10
lines changed

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

Lines changed: 77 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -530,7 +530,7 @@ SET TIME ZONE { '<REPLACEABLE CLASS="PARAMETER">timezone</REPLACEABLE>' | LOCAL
530530
<variablelist>
531531
<varlistentry>
532532
<term>
533-
XACTISOLEVEL
533+
XACTISOLEVEL | TRANSACTION ISOLATION LEVEL
534534
</term>
535535
<listitem>
536536
<para>
@@ -556,15 +556,88 @@ SET TIME ZONE { '<REPLACEABLE CLASS="PARAMETER">timezone</REPLACEABLE>' | LOCAL
556556
</term>
557557
<listitem>
558558
<para>
559-
Sets the cost of a heap scan to the default value.
559+
Sets the isolation level for transactions to
560+
'SERIALIZABLE' or 'COMMITTED'.
560561
</para>
561562
</listitem>
562563
</varlistentry>
563564
</variablelist>
564565
</para>
566+
567+
<variablelist>
568+
<varlistentry>
569+
<term>
570+
CLIENT_ENCODING | NAMES
571+
</term>
572+
<listitem>
565573
<para>
566-
The frontend may be initialized by setting the PGCOSTHEAP
567-
environment variable.
574+
Sets the multi-byte client encoding
575+
576+
<variablelist>
577+
<varlistentry>
578+
<term>
579+
<replaceable class="parameter">value</replaceable>
580+
</term>
581+
<listitem>
582+
<para>
583+
Sets the multi-byte client encoding.
584+
</para>
585+
</listitem>
586+
</varlistentry>
587+
</para>
588+
589+
<varlistentry>
590+
<term>
591+
DEFAULT
592+
</term>
593+
<listitem>
594+
<para>
595+
Sets the multi-byte client encoding.
596+
</para>
597+
</listitem>
598+
</varlistentry>
599+
</variablelist>
600+
</para>
601+
<para>
602+
This is only enabled if multi-byte was specified to configure.
603+
</para>
604+
605+
<variablelist>
606+
<varlistentry>
607+
<term>
608+
SERVER_ENCODING
609+
</term>
610+
<listitem>
611+
<para>
612+
Sets the multi-byte server encoding
613+
614+
<variablelist>
615+
<varlistentry>
616+
<term>
617+
<replaceable class="parameter">value</replaceable>
618+
</term>
619+
<listitem>
620+
<para>
621+
Sets the multi-byte server encoding.
622+
</para>
623+
</listitem>
624+
</varlistentry>
625+
</para>
626+
627+
<varlistentry>
628+
<term>
629+
DEFAULT
630+
</term>
631+
<listitem>
632+
<para>
633+
Sets the multi-byte server encoding.
634+
</para>
635+
</listitem>
636+
</varlistentry>
637+
</variablelist>
638+
</para>
639+
<para>
640+
This is only enabled if multi-byte was specified to configure.
568641
</para>
569642

570643

‎src/bin/psql/psqlHelp.h

Lines changed: 3 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -5,7 +5,7 @@
55
*
66
* Copyright (c) 1994, Regents of the University of California
77
*
8-
* $Id: psqlHelp.h,v 1.65 1999/06/03 18:25:27 momjian Exp $
8+
* $Id: psqlHelp.h,v 1.66 1999/06/03 18:37:59 momjian Exp $
99
*
1010
*-------------------------------------------------------------------------
1111
*/
@@ -328,8 +328,8 @@ TIMEZONE|XACTISOLEVEL|CLIENT_ENCODING|SERVER_ENCODING"},
328328
\tSET KSQO TO 'ON'|'OFF'\n\
329329
\tSET QUERY_LIMIT TO #\n\
330330
\tSET TIMEZONE TO 'value'\n\
331-
\tSET XACTISOLEVEL TO 'SERIALIZABLE'|'COMMITTED'\n\
332-
\tSET CLIENT_ENCODING TO 'EUC_JP'|'SJIS'|'EUC_CN'|'EUC_KR'|'EUC_TW'|\n\
331+
\tSET XACTISOLEVEL|TRANSACTION ISOLATION LEVEL TO 'SERIALIZABLE'|'COMMITTED'\n\
332+
\tSET CLIENT_ENCODING|NAMES TO 'EUC_JP'|'SJIS'|'EUC_CN'|'EUC_KR'|'EUC_TW'|\n\
333333
\t 'BIG5'|'MULE_INTERNAL'|'LATIN1'|'LATIN2'|'LATIN3'|'LATIN4'|'LATIN5'|\n\
334334
\t 'KOI8|'WIN'|'ALT'\n\
335335
\tSET SERVER_ENCODING TO 'EUC_JP'|'SJIS'|'EUC_CN'|'EUC_KR'|'EUC_TW'|\n\

‎src/man/set.l

Lines changed: 3 additions & 3 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.17 1999/06/03 18:18:43 momjian Exp $
3+
.\" $Header: /cvsroot/pgsql/src/man/Attic/set.l,v 1.18 1999/06/03 18:38:00 momjian Exp $
44
.TH SET SQL 05/14/97 PostgreSQL PostgreSQL
55
.SH NAME
66
set - set run-time parameters for session
@@ -81,13 +81,13 @@ The default is unlimited.
8181
.IR TIMEZONE
8282
sets your timezone.
8383
.PP
84-
.IR XACTISOLEVEL
84+
.IXACTISOLEVEL|TRANSACTIONISOLATIONLEVEL
8585
sets the transaction isolation level to
8686
.IR SERIALIZABLE
8787
or
8888
.IR COMMITTED.
8989
.PP
90-
.IR CLIENT_ENCODING
90+
.IR CLIENT_ENCODING|NAMES
9191
sets the character set encoding of the client. Only available if multi-byte
9292
is enabled at configure time.
9393
.PP

0 commit comments

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