NotificationsYou must be signed in to change notification settings
Fork5
Star26

Commit1e901bb

Thomas G. Lockhart

committed

Implement SET SESSION CHARACTERISTICS and SET DefaultXactIsoLevel.

1 parent2016898 commit1e901bbCopy full SHA for 1e901bb

File tree

1 file changed

+73

-2

lines changed

src/backend/commands
- variable.c

1 file changed

+73

-2

lines changed

`‎src/backend/commands/variable.c`

Lines changed: 73 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -9,7 +9,7 @@`
`9`	`9`	`*`
`10`	`10`	`*`
`11`	`11`	`* IDENTIFICATION`
`12`		`- * $Header: /cvsroot/pgsql/src/backend/commands/variable.c,v 1.38 2000/06/22 22:31:17 petere Exp $`
	`12`	`+ * $Header: /cvsroot/pgsql/src/backend/commands/variable.c,v 1.39 2000/07/14 15:35:44 thomas Exp $`
`13`	`13`	`*`
`14`	`14`	`*-------------------------------------------------------------------------`
`15`	`15`	`*/`
`@@ -43,6 +43,9 @@ static bool show_timezone(void);`
`43`	`43`	`staticboolreset_timezone(void);`
`44`	`44`	`staticboolparse_timezone(char*);`
`45`	`45`
	`46`	`+staticboolshow_DefaultXactIsoLevel(void);`
	`47`	`+staticboolreset_DefaultXactIsoLevel(void);`
	`48`	`+staticboolparse_DefaultXactIsoLevel(char*);`
`46`	`49`	`staticboolshow_XactIsoLevel(void);`
`47`	`50`	`staticboolreset_XactIsoLevel(void);`
`48`	`51`	`staticboolparse_XactIsoLevel(char*);`
`@@ -434,6 +437,68 @@ reset_timezone()`
`434`	`437`
`435`	`438`	`/* SET TRANSACTION */`
`436`	`439`
	`440`	`+staticbool`
	`441`	`+parse_DefaultXactIsoLevel(char*value)`
	`442`	`+{`
	`443`	`+#if0`
	`444`	`+TransactionStates=CurrentTransactionState;`
	`445`	`+#endif`
	`446`	`+`
	`447`	`+if (value==NULL)`
	`448`	`+{`
	`449`	`+reset_DefaultXactIsoLevel();`
	`450`	`+return TRUE;`
	`451`	`+}`
	`452`	`+`
	`453`	`+#if0`
	`454`	`+if (s->state!=TRANS_DEFAULT)`
	`455`	`+{`
	`456`	`+elog(ERROR,"ALTER SESSION/SET TRANSACTION ISOLATION LEVEL"`
	`457`	`+" can not be called within a transaction");`
	`458`	`+return TRUE;`
	`459`	`+}`
	`460`	`+#endif`
	`461`	`+`
	`462`	`+if (strcasecmp(value,"SERIALIZABLE")==0)`
	`463`	`+DefaultXactIsoLevel=XACT_SERIALIZABLE;`
	`464`	`+elseif (strcasecmp(value,"COMMITTED")==0)`
	`465`	`+DefaultXactIsoLevel=XACT_READ_COMMITTED;`
	`466`	`+else`
	`467`	`+elog(ERROR,"Bad TRANSACTION ISOLATION LEVEL (%s)",value);`
	`468`	`+`
	`469`	`+return TRUE;`
	`470`	`+}`
	`471`	`+`
	`472`	`+staticbool`
	`473`	`+show_DefaultXactIsoLevel()`
	`474`	`+{`
	`475`	`+`
	`476`	`+if (DefaultXactIsoLevel==XACT_SERIALIZABLE)`
	`477`	`+elog(NOTICE,"Default TRANSACTION ISOLATION LEVEL is SERIALIZABLE");`
	`478`	`+else`
	`479`	`+elog(NOTICE,"Default TRANSACTION ISOLATION LEVEL is READ COMMITTED");`
	`480`	`+return TRUE;`
	`481`	`+}`
	`482`	`+`
	`483`	`+staticbool`
	`484`	`+reset_DefaultXactIsoLevel()`
	`485`	`+{`
	`486`	`+#if0`
	`487`	`+TransactionStates=CurrentTransactionState;`
	`488`	`+`
	`489`	`+if (s->state!=TRANS_DEFAULT)`
	`490`	`+{`
	`491`	`+elog(ERROR,"ALTER SESSION/SET TRANSACTION ISOLATION LEVEL"`
	`492`	`+" can not be called within a transaction");`
	`493`	`+return TRUE;`
	`494`	`+}`
	`495`	`+#endif`
	`496`	`+`
	`497`	`+DefaultXactIsoLevel=XACT_READ_COMMITTED;`
	`498`	`+`
	`499`	`+return TRUE;`
	`500`	`+}`
	`501`	`+`
`437`	`502`	`staticbool`
`438`	`503`	`parse_XactIsoLevel(char*value)`
`439`	`504`	`{`
`@@ -535,6 +600,8 @@ SetPGVariable(const char name, const char value)`
`535`	`600`	`parse_date(pstrdup(value));`
`536`	`601`	`elseif (strcasecmp(name,"timezone")==0)`
`537`	`602`	`parse_timezone(pstrdup(value));`
	`603`	`+elseif (strcasecmp(name,"DefaultXactIsoLevel")==0)`
	`604`	`+parse_DefaultXactIsoLevel(pstrdup(value));`
`538`	`605`	`elseif (strcasecmp(name,"XactIsoLevel")==0)`
`539`	`606`	`parse_XactIsoLevel(pstrdup(value));`
`540`	`607`	`#ifdefMULTIBYTE`
`@@ -557,6 +624,8 @@ GetPGVariable(const char *name)`
`557`	`624`	`show_date();`
`558`	`625`	`elseif (strcasecmp(name,"timezone")==0)`
`559`	`626`	`show_timezone();`
	`627`	`+elseif (strcasecmp(name,"DefaultXactIsoLevel")==0)`
	`628`	`+show_DefaultXactIsoLevel();`
`560`	`629`	`elseif (strcasecmp(name,"XactIsoLevel")==0)`
`561`	`630`	`show_XactIsoLevel();`
`562`	`631`	`#ifdefMULTIBYTE`
`@@ -581,8 +650,10 @@ ResetPGVariable(const char *name)`
`581`	`650`	`reset_date();`
`582`	`651`	`elseif (strcasecmp(name,"timezone")==0)`
`583`	`652`	`reset_timezone();`
	`653`	`+elseif (strcasecmp(name,"DefaultXactIsoLevel")==0)`
	`654`	`+reset_DefaultXactIsoLevel();`
`584`	`655`	`elseif (strcasecmp(name,"XactIsoLevel")==0)`
`585`		`-reset_XactIsoLevel();`
	`656`	`+reset_XactIsoLevel();`
`586`	`657`	`#ifdefMULTIBYTE`
`587`	`658`	`elseif (strcasecmp(name, "client_encoding")==0)`
`588`	`659`	`reset_client_encoding();`

0 commit comments

Comments

(0)

Movatterモバイル変換

Navigation Menu

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

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

Commit1e901bb

File tree

1 file changed

1 file changed

`‎src/backend/commands/variable.c`

0 commit comments