postgres.git / summary / log / commit / refs

commit    82ef3d3008f8ec9c565f7a5724196cd0f342d594
Author:   Robert Haas <rhaas@postgresql.org>
Date:     Tue Aug 21 15:08:15 2012 +0000
First released in: 9.3.0

    Add a note to the MVCC chapter that some things aren't transactional.
    
    Craig Ringer, slightly edited by me.


 doc/src/sgml/mvcc.sgml | 12 ++++++++++++
 1 file changed, 12 insertions(+)

diff --git a/doc/src/sgml/mvcc.sgml b/doc/src/sgml/mvcc.sgml
index 8f8858294dc..d5c6076d4aa 100644
--- a/doc/src/sgml/mvcc.sgml
+++ b/doc/src/sgml/mvcc.sgml
@@ -260,6 +260,18 @@
     command <xref linkend="sql-set-transaction">.
    </para>
 
+   <important>
+     <para>
+       Some <productname>PostgreSQL</productname> data types and functions have
+       special rules regarding transactional behaviour.  In particular, changes
+       made to a <literal>SEQUENCE</literal> (and therefore the counter of a
+       column declared using <literal>SERIAL</literal>) are immediately visible
+       to all other transactions and are not rolled back if the transaction
+       that made the changes aborts.  See <xref linkend="functions-sequence">
+       and <xref linkend="datatype-serial">.
+     </para>
+   </important>
+
   <sect2 id="xact-read-committed">
    <title>Read Committed Isolation Level</title>
 


[parent: 71450d7fd6c7]