Commit155b580

committed

Thanks for this, but SET TRANSACTION ISOLATION LEVEL

should be described like SET TIME ZONE: TO is not allowed, as wellas DEFAULT option. There are only two forms:for Vadim.

1 parenta40bac0 commit155b580Copy full SHA for 155b580

File tree

-7

lines changed

-7

lines changed

Lines changed: 2 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -530,7 +530,7 @@ SET TIME ZONE { '<REPLACEABLE CLASS="PARAMETER">timezone</REPLACEABLE>' \| LOCAL`
`530`	`530`	`<variablelist>`
`531`	`531`	`<varlistentry>`
`532`	`532`	`<term>`
`533`		`-XACTISOLEVEL \|TRANSACTION ISOLATION LEVEL`
	`533`	`+ TRANSACTION ISOLATION LEVEL`
`534`	`534`	`</term>`
`535`	`535`	`<listitem>`
`536`	`536`	`<para>`
`@@ -544,7 +544,7 @@ SET TIME ZONE { '<REPLACEABLE CLASS="PARAMETER">timezone</REPLACEABLE>' \| LOCAL`
`544`	`544`	`<listitem>`
`545`	`545`	`<para>`
`546`	`546`	`Sets the isolation level for transactions to`
`547`		`-'SERIALIZABLE' or 'COMMITTED'.`
	`547`	`+'SERIALIZABLE' or 'READCOMMITTED'.`
`548`	`548`	`</para>`
`549`	`549`	`</listitem>`
`550`	`550`	`</varlistentry>`

Lines changed: 2 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -5,7 +5,7 @@`
`5`	`5`	`*`
`6`	`6`	`* Copyright (c) 1994, Regents of the University of California`
`7`	`7`	`*`
`8`		`- * $Id: psqlHelp.h,v 1.68 1999/06/0319:52:08 momjian Exp $`
	`8`	`+ * $Id: psqlHelp.h,v 1.69 1999/06/0320:42:17 momjian Exp $`
`9`	`9`	`*`
`10`	`10`	`*-------------------------------------------------------------------------`
`11`	`11`	`*/`
`@@ -331,7 +331,7 @@ TIMEZONE\|XACTISOLEVEL\|CLIENT_ENCODING\|SERVER_ENCODING"},`
`331`	`331`	`\tSET KSQO TO 'ON'\|'OFF'\n\`
`332`	`332`	`\tSET QUERY_LIMIT TO #\n\`
`333`	`333`	`\tSET TIMEZONE TO 'value'\n\`
`334`		`-\tSETXACTISOLEVEL\|TRANSACTION ISOLATION LEVELTO'SERIALIZABLE'\|'COMMITTED'\n\`
	`334`	`+\tSET TRANSACTION ISOLATION LEVEL 'SERIALIZABLE'\|'READCOMMITTED'\n\`
`335`	`335`	`\tSET CLIENT_ENCODING\|NAMES TO 'EUC_JP'\|'SJIS'\|'EUC_CN'\|'EUC_KR'\|'EUC_TW'\|\n\`
`336`	`336`	`\t 'BIG5'\|'MULE_INTERNAL'\|'LATIN1'\|'LATIN2'\|'LATIN3'\|'LATIN4'\|'LATIN5'\|\n\`
`337`	`337`	`\t 'KOI8\|'WIN'\|'ALT'\n\`

Lines changed: 3 additions & 3 deletions

Original file line number	Diff line number	Diff line change
`@@ -1,6 +1,6 @@`
`1`	`1`	`.\" This is --nroff--`
`2`	`2`	`.\" XXX standard disclaimer belongs here....`
`3`		`-.\" $Header: /cvsroot/pgsql/src/man/Attic/set.l,v 1.18 1999/06/0318:38:00 momjian Exp $`
	`3`	`+.\" $Header: /cvsroot/pgsql/src/man/Attic/set.l,v 1.19 1999/06/0320:42:18 momjian Exp $`
`4`	`4`	`.TH SET SQL 05/14/97 PostgreSQL PostgreSQL`
`5`	`5`	`.SH NAME`
`6`	`6`	`set - set run-time parameters for session`
`@@ -81,11 +81,11 @@ The default is unlimited.`
`81`	`81`	`.IR TIMEZONE`
`82`	`82`	`sets your timezone.`
`83`	`83`	`.PP`
`84`		`-.IXACTISOLEVEL\|TRANSACTIONISOLATIONLEVEL`
	`84`	`+.ITRANSACTIONISOLATIONLEVEL`
`85`	`85`	`sets the transaction isolation level to`
`86`	`86`	`.IR SERIALIZABLE`
`87`	`87`	`or`
`88`		`-.IR COMMITTED.`
	`88`	`+.IRREADCOMMITTED .`
`89`	`89`	`.PP`
`90`	`90`	`.IR CLIENT_ENCODING\|NAMES`
`91`	`91`	`sets the character set encoding of the client. Only available if multi-byte`

Comments

(0)