Commit5a7547d

committed

Add description for SET TRANSACTION.

1 parent74e7b58 commit5a7547dCopy full SHA for 5a7547d

File tree

+15

-2

lines changed

+15

-2

lines changed

Lines changed: 6 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -545,6 +545,11 @@ SET TIME ZONE { '<REPLACEABLE CLASS="PARAMETER">timezone</REPLACEABLE>' \| LOCAL`
`545`	`545`	`<para>`
`546`	`546`	`Sets the isolation level for the current transaction to`
`547`	`547`	`'SERIALIZABLE' or 'READ COMMITTED'.`
	`548`	`+SERIALIZABLE means that the current transaction will place a`
	`549`	`+lock on every row read, so later reads in that transaction`
	`550`	`+see the rows unmodified by other transactions.`
	`551`	`+READ COMMITTED means that the current transaction reads only`
	`552`	`+committed rows. READ COMMITTED is the default.`
`548`	`553`	`</para>`
`549`	`554`	`</listitem>`
`550`	`555`	`</varlistentry>`
`@@ -557,7 +562,7 @@ SET TIME ZONE { '<REPLACEABLE CLASS="PARAMETER">timezone</REPLACEABLE>' \| LOCAL`
`557`	`562`	`<listitem>`
`558`	`563`	`<para>`
`559`	`564`	`Sets the isolation level for the current transaction to`
`560`		`-'SERIALIZABLE' or 'READ COMMITTED'.`
	`565`	`+'READ COMMITTED'.`
`561`	`566`	`</para>`
`562`	`567`	`</listitem>`
`563`	`568`	`</varlistentry>`

Lines changed: 9 additions & 1 deletion

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.20 1999/06/03 20:44:28 momjian Exp $`
	`3`	`+.\" $Header: /cvsroot/pgsql/src/man/Attic/set.l,v 1.21 1999/06/04 03:44:42 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`
`@@ -86,6 +86,14 @@ sets the current transaction's isolation level to`
`86`	`86`	`.IR SERIALIZABLE`
`87`	`87`	`or`
`88`	`88`	`.IR READCOMMITTED .`
	`89`	`+.IR SERIALIZABLE`
	`90`	`+means that the current transaction will place a lock on every row read,`
	`91`	`+so later reads in that transaction see the rows unmodified by`
	`92`	`+other transactions.`
	`93`	`+.IR READCOMMITTED`
	`94`	`+means that the current transaction reads only committed rows.`
	`95`	`+.IR READCOMMITTED`
	`96`	`+is the default.`
`89`	`97`	`.PP`
`90`	`98`	`.IR CLIENT_ENCODING\|NAMES`
`91`	`99`	`sets the character set encoding of the client. Only available if multi-byte`

Comments

(0)