Commit82ef3d3

committed

Add a note to the MVCC chapter that some things aren't transactional.

Craig Ringer, slightly edited by me.

1 parent71450d7 commit82ef3d3Copy full SHA for 82ef3d3

File tree

+12

-0

lines changed

+12

-0

lines changed

Lines changed: 12 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -260,6 +260,18 @@`
`260`	`260`	`command <xref linkend="sql-set-transaction">.`
`261`	`261`	`</para>`
`262`	`262`
	`263`	`+ <important>`
	`264`	`+ <para>`
	`265`	`+ Some <productname>PostgreSQL</productname> data types and functions have`
	`266`	`+ special rules regarding transactional behaviour. In particular, changes`
	`267`	`+ made to a <literal>SEQUENCE</literal> (and therefore the counter of a`
	`268`	`+ column declared using <literal>SERIAL</literal>) are immediately visible`
	`269`	`+ to all other transactions and are not rolled back if the transaction`
	`270`	`+ that made the changes aborts. See <xref linkend="functions-sequence">`
	`271`	`+ and <xref linkend="datatype-serial">.`
	`272`	`+ </para>`
	`273`	`+ </important>`
	`274`	`+`
`263`	`275`	`<sect2 id="xact-read-committed">`
`264`	`276`	`<title>Read Committed Isolation Level</title>`
`265`	`277`

Comments

(0)