Vik Reykja vikrey...@gmail.com wrote:
in Section 13.2.3 of the 9.1 docs [1], the follow sentence
fragment can be found:
using Serializable transactions will allow one transaction to
commit and and will roll the other back
Note the double and towards the end. (Is this the right list for
this kind of report?)
When it's strictly documentation and doesn't involve questions of
how the software works, pgsql-docs is probably better, but this
works.
Trivial patch attached. Thanks!
-Kevin
*** a/doc/src/sgml/mvcc.sgml
--- b/doc/src/sgml/mvcc.sgml
***
*** 547,553 SELECT SUM(value) FROM mytab WHERE class = 2;
If either transaction were running at the Repeatable Read isolation level,
both would be allowed to commit; but since there is no serial order of
execution
consistent with the result, using Serializable transactions will allow one
! transaction to commit and and will roll the other back with this message:
screen
ERROR: could not serialize access due to read/write dependencies among
transactions
--- 547,553
If either transaction were running at the Repeatable Read isolation level,
both would be allowed to commit; but since there is no serial order of
execution
consistent with the result, using Serializable transactions will allow one
! transaction to commit and will roll the other back with this message:
screen
ERROR: could not serialize access due to read/write dependencies among
transactions
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers