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

Commit10e9cd2

Browse files
committed
Allow default transaction isolation level (a.k.a. set session
characteristics) to be set through GUC.
1 parente4a40cc commit10e9cd2

File tree

6 files changed

+79
-87
lines changed

6 files changed

+79
-87
lines changed

‎doc/src/sgml/ref/set_transaction.sgml‎

Lines changed: 13 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -1,4 +1,4 @@
1-
<!-- $Header: /cvsroot/pgsql/doc/src/sgml/ref/set_transaction.sgml,v 1.3 2000/11/24 20:16:38 petere Exp $ -->
1+
<!-- $Header: /cvsroot/pgsql/doc/src/sgml/ref/set_transaction.sgml,v 1.4 2001/06/30 22:03:25 petere Exp $ -->
22
<refentry id="SQL-SET-TRANSACTION">
33
<docinfo>
44
<date>2000-11-24</date>
@@ -74,6 +74,18 @@ SET SESSION CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL { READ COMMITTED | SE
7474
</para>
7575
</refsect1>
7676

77+
<refsect1>
78+
<title>Notes</title>
79+
80+
<para>
81+
The session default transaction isolation level can also be set
82+
with the command <literal>SET default_transaction_isolation =
83+
'<replaceable>value</replaceable>'</literal> and in the
84+
configuration file. Consult the <citetitle>Administrator's
85+
Guide</citetitle> for more information.
86+
</para>
87+
</refsect1>
88+
7789
<refsect1 id="R1-SQL-SET-TRANSACTION-3">
7890
<title>Compatibility</title>
7991

‎doc/src/sgml/runtime.sgml‎

Lines changed: 27 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -1,5 +1,5 @@
11
<!--
2-
$Header: /cvsroot/pgsql/doc/src/sgml/runtime.sgml,v 1.71 2001/06/3021:15:57 darcy Exp $
2+
$Header: /cvsroot/pgsql/doc/src/sgml/runtime.sgml,v 1.72 2001/06/3022:03:25 petere Exp $
33
-->
44

55
<Chapter Id="runtime">
@@ -996,6 +996,29 @@ env PGOPTIONS='-c geqo=off' psql
996996
</listitem>
997997
</varlistentry>
998998

999+
<varlistentry>
1000+
<indexterm>
1001+
<primary>transaction isolation level</primary>
1002+
</indexterm>
1003+
1004+
<term>DEFAUL_TRANSACTION_ISOLATION (<type>string</type>)</term>
1005+
<listitem>
1006+
<para>
1007+
Each SQL transaction has an isolation level, which can be
1008+
either <quote>read committed</quote> or
1009+
<quote>serializable</quote>. This parameter controls what the
1010+
isolation level of each new transaction is set to. The
1011+
default is read committed.
1012+
</para>
1013+
1014+
<para>
1015+
Consult the <citetitle>PostgreSQL User's Guide</citetitle> and
1016+
the command <command>SET TRANSACTION</command> for more
1017+
information.
1018+
</para>
1019+
</listitem>
1020+
</varlistentry>
1021+
9991022
<varlistentry>
10001023
<term>DYNAMIC_LIBRARY_PATH (<type>string</type>)</term>
10011024
<listitem>
@@ -1051,9 +1074,9 @@ dynamic_library_path = '/usr/local/lib:/home/my_project/lib:$libdir:$libdir/cont
10511074
will use the <function>fsync()</> system call in several
10521075
places to make sure that updates are physically written to
10531076
disk and do not hang around in the kernel buffer cache. This
1054-
increases the chancethat adatabase installation will still
1055-
be usable after an operating system or hardware crash by a
1056-
large amount. (Crashes of the database server itself do
1077+
increases the chanceby alarge amount that a database
1078+
installation will stillbe usable after an operating system or
1079+
hardware crash. (Crashes of the database server itself do
10571080
<emphasis>not</> affect this consideration.)
10581081
</para>
10591082

‎src/backend/commands/variable.c‎

Lines changed: 4 additions & 78 deletions
Original file line numberDiff line numberDiff line change
@@ -9,7 +9,7 @@
99
*
1010
*
1111
* IDENTIFICATION
12-
* $Header: /cvsroot/pgsql/src/backend/commands/variable.c,v 1.50 2001/06/12 22:54:05 tgl Exp $
12+
* $Header: /cvsroot/pgsql/src/backend/commands/variable.c,v 1.51 2001/06/30 22:03:25 petere Exp $
1313
*
1414
*-------------------------------------------------------------------------
1515
*/
@@ -46,9 +46,6 @@ static bool show_timezone(void);
4646
staticboolreset_timezone(void);
4747
staticboolparse_timezone(char*);
4848

49-
staticboolshow_DefaultXactIsoLevel(void);
50-
staticboolreset_DefaultXactIsoLevel(void);
51-
staticboolparse_DefaultXactIsoLevel(char*);
5249
staticboolshow_XactIsoLevel(void);
5350
staticboolreset_XactIsoLevel(void);
5451
staticboolparse_XactIsoLevel(char*);
@@ -448,69 +445,6 @@ reset_timezone(void)
448445

449446
/* SET TRANSACTION */
450447

451-
staticbool
452-
parse_DefaultXactIsoLevel(char*value)
453-
{
454-
#if0
455-
TransactionStates=CurrentTransactionState;
456-
457-
#endif
458-
459-
if (value==NULL)
460-
{
461-
reset_DefaultXactIsoLevel();
462-
return TRUE;
463-
}
464-
465-
#if0
466-
if (s->state!=TRANS_DEFAULT)
467-
{
468-
elog(ERROR,"ALTER SESSION/SET TRANSACTION ISOLATION LEVEL"
469-
" can not be called within a transaction");
470-
return TRUE;
471-
}
472-
#endif
473-
474-
if (strcasecmp(value,"SERIALIZABLE")==0)
475-
DefaultXactIsoLevel=XACT_SERIALIZABLE;
476-
elseif (strcasecmp(value,"COMMITTED")==0)
477-
DefaultXactIsoLevel=XACT_READ_COMMITTED;
478-
else
479-
elog(ERROR,"Bad TRANSACTION ISOLATION LEVEL (%s)",value);
480-
481-
return TRUE;
482-
}
483-
484-
staticbool
485-
show_DefaultXactIsoLevel(void)
486-
{
487-
488-
if (DefaultXactIsoLevel==XACT_SERIALIZABLE)
489-
elog(NOTICE,"Default TRANSACTION ISOLATION LEVEL is SERIALIZABLE");
490-
else
491-
elog(NOTICE,"Default TRANSACTION ISOLATION LEVEL is READ COMMITTED");
492-
return TRUE;
493-
}
494-
495-
staticbool
496-
reset_DefaultXactIsoLevel(void)
497-
{
498-
#if0
499-
TransactionStates=CurrentTransactionState;
500-
501-
if (s->state!=TRANS_DEFAULT)
502-
{
503-
elog(ERROR,"ALTER SESSION/SET TRANSACTION ISOLATION LEVEL"
504-
" can not be called within a transaction");
505-
return TRUE;
506-
}
507-
#endif
508-
509-
DefaultXactIsoLevel=XACT_READ_COMMITTED;
510-
511-
return TRUE;
512-
}
513-
514448
staticbool
515449
parse_XactIsoLevel(char*value)
516450
{
@@ -530,7 +464,7 @@ parse_XactIsoLevel(char *value)
530464

531465
if (strcasecmp(value,"SERIALIZABLE")==0)
532466
XactIsoLevel=XACT_SERIALIZABLE;
533-
elseif (strcasecmp(value,"COMMITTED")==0)
467+
elseif (strcasecmp(value,"READCOMMITTED")==0)
534468
XactIsoLevel=XACT_READ_COMMITTED;
535469
else
536470
elog(ERROR,"Bad TRANSACTION ISOLATION LEVEL (%s)",value);
@@ -711,8 +645,6 @@ SetPGVariable(const char *name, const char *value)
711645
parse_datestyle(mvalue);
712646
elseif (strcasecmp(name,"timezone")==0)
713647
parse_timezone(mvalue);
714-
elseif (strcasecmp(name,"DefaultXactIsoLevel")==0)
715-
parse_DefaultXactIsoLevel(mvalue);
716648
elseif (strcasecmp(name,"XactIsoLevel")==0)
717649
parse_XactIsoLevel(mvalue);
718650
elseif (strcasecmp(name,"client_encoding")==0)
@@ -737,8 +669,6 @@ GetPGVariable(const char *name)
737669
show_datestyle();
738670
elseif (strcasecmp(name,"timezone")==0)
739671
show_timezone();
740-
elseif (strcasecmp(name,"DefaultXactIsoLevel")==0)
741-
show_DefaultXactIsoLevel();
742672
elseif (strcasecmp(name,"XactIsoLevel")==0)
743673
show_XactIsoLevel();
744674
elseif (strcasecmp(name,"client_encoding")==0)
@@ -752,7 +682,6 @@ GetPGVariable(const char *name)
752682
ShowAllGUCConfig();
753683
show_datestyle();
754684
show_timezone();
755-
show_DefaultXactIsoLevel();
756685
show_XactIsoLevel();
757686
show_client_encoding();
758687
show_server_encoding();
@@ -772,8 +701,6 @@ ResetPGVariable(const char *name)
772701
reset_datestyle();
773702
elseif (strcasecmp(name,"timezone")==0)
774703
reset_timezone();
775-
elseif (strcasecmp(name,"DefaultXactIsoLevel")==0)
776-
reset_DefaultXactIsoLevel();
777704
elseif (strcasecmp(name,"XactIsoLevel")==0)
778705
reset_XactIsoLevel();
779706
elseif (strcasecmp(name,"client_encoding")==0)
@@ -784,16 +711,15 @@ ResetPGVariable(const char *name)
784711
reset_random_seed();
785712
elseif (strcasecmp(name,"all")==0)
786713
{
787-
reset_DefaultXactIsoLevel();
788-
reset_XactIsoLevel();
789714
reset_random_seed();
790715
/* reset_server_encoding(); */
791716
reset_client_encoding();
792717
reset_datestyle();
793718
reset_timezone();
794719

795720
ResetAllOptions(false);
796-
}else
721+
}
722+
else
797723
SetConfigOption(name,NULL,
798724
superuser() ?PGC_SUSET :PGC_USERSET,
799725
false);

‎src/backend/parser/gram.y‎

Lines changed: 3 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -11,7 +11,7 @@
1111
*
1212
*
1313
* IDENTIFICATION
14-
* $Header: /cvsroot/pgsql/src/backend/parser/gram.y,v 2.232 2001/06/23 00:07:34 momjian Exp $
14+
* $Header: /cvsroot/pgsql/src/backend/parser/gram.y,v 2.233 2001/06/30 22:03:25 petere Exp $
1515
*
1616
* HISTORY
1717
* AUTHORDATEMAJOR EVENT
@@ -752,7 +752,7 @@ VariableSetStmt: SET ColId TO var_value
752752
|SETSESSIONCHARACTERISTICSASTRANSACTIONISOLATIONLEVELopt_level
753753
{
754754
VariableSetStmt *n = makeNode(VariableSetStmt);
755-
n->name ="DefaultXactIsoLevel";
755+
n->name ="default_transaction_isolation";
756756
n->value =$8;
757757
$$ = (Node *) n;
758758
}
@@ -772,7 +772,7 @@ VariableSetStmt: SET ColId TO var_value
772772
}
773773
;
774774

775-
opt_level:READCOMMITTED{$$ ="committed"; }
775+
opt_level:READCOMMITTED{$$ ="readcommitted"; }
776776
|SERIALIZABLE{$$ ="serializable"; }
777777
;
778778

‎src/backend/utils/misc/guc.c‎

Lines changed: 31 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -4,7 +4,7 @@
44
* Support for grand unified configuration scheme, including SET
55
* command, configuration file, and command line options.
66
*
7-
* $Header: /cvsroot/pgsql/src/backend/utils/misc/guc.c,v 1.43 2001/06/27 23:31:39 tgl Exp $
7+
* $Header: /cvsroot/pgsql/src/backend/utils/misc/guc.c,v 1.44 2001/06/30 22:03:26 petere Exp $
88
*
99
* Copyright 2000 by PostgreSQL Global Development Group
1010
* Written by Peter Eisentraut <peter_e@gmx.net>.
@@ -51,6 +51,11 @@ extern char *Syslog_ident;
5151
staticboolcheck_facility(constchar*facility);
5252
#endif
5353

54+
staticchar*default_iso_level_string;
55+
56+
staticboolcheck_defaultxactisolevel(constchar*value);
57+
staticvoidassign_defaultxactisolevel(constchar*value);
58+
5459
/*
5560
* Debugging options
5661
*/
@@ -355,6 +360,9 @@ static struct config_real
355360
staticstructconfig_string
356361
ConfigureNamesString[]=
357362
{
363+
{"default_transaction_isolation",PGC_USERSET,&default_iso_level_string,
364+
"read committed",check_defaultxactisolevel,assign_defaultxactisolevel},
365+
358366
{"dynamic_library_path",PGC_SUSET,&Dynamic_library_path,
359367
"$libdir",NULL,NULL},
360368

@@ -1092,3 +1100,25 @@ check_facility(const char *facility)
10921100
}
10931101

10941102
#endif
1103+
1104+
1105+
1106+
staticbool
1107+
check_defaultxactisolevel(constchar*value)
1108+
{
1109+
return (strcasecmp(value,"read committed")==0
1110+
||strcasecmp(value,"serializable")==0)
1111+
? true : false;
1112+
}
1113+
1114+
1115+
staticvoid
1116+
assign_defaultxactisolevel(constchar*value)
1117+
{
1118+
if (strcasecmp(value,"serializable")==0)
1119+
DefaultXactIsoLevel=XACT_SERIALIZABLE;
1120+
elseif (strcasecmp(value,"read committed")==0)
1121+
DefaultXactIsoLevel=XACT_READ_COMMITTED;
1122+
else
1123+
elog(ERROR,"bogus transaction isolation level");
1124+
}

‎src/backend/utils/misc/postgresql.conf.sample‎

Lines changed: 1 addition & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -166,6 +166,7 @@
166166
#
167167
#Misc
168168
#
169+
#default_transaction_isolation = 'read committed'
169170
#sql_inheritance = true
170171
#australian_timezones = false
171172
#deadlock_timeout = 1000

0 commit comments

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