Repeatable Read Table Reference

From: swehren(at)gmail(dot)com
To: pgsql-docs(at)postgresql(dot)org
Subject: Repeatable Read Table Reference
Date: 2016-05-24 20:38:08
Message-ID: 20160524203808.19432.60758@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/9.5/static/transaction-iso.html
Description:

In the documentation for Repeatable Read on this page:

https://www.postgresql.org/docs/current/static/transaction-iso.html

The documentation says, "This is a stronger guarantee than is required by
the SQL standard for this isolation level, and prevents all of the phenomena
described in Table 13-1."

Since the Serialization Anomaly was added to the table in this commit
(https://github.com/postgres/postgres/commit/23c33198b961f27c80655a7cf439d49ef5a1833d#diff-a85793bf153f1f44870606f9695bc33c),
that statement is no longer true if I understand the documentation
correctly. Here's a brief patch to tweak that sentence.

diff --git a/doc/src/sgml/mvcc.sgml b/doc/src/sgml/mvcc.sgml
index f2272bc..0a112cb 100644
--- a/doc/src/sgml/mvcc.sgml
+++ b/doc/src/sgml/mvcc.sgml
@@ -461,10 +461,10 @@ COMMIT;
even though they are not yet committed.) This is a stronger
guarantee than is required by the <acronym>SQL</acronym> standard
for this isolation level, and prevents all of the phenomena described
- in <xref linkend="mvcc-isolevel-table">. As mentioned above, this is
- specifically allowed by the standard, which only describes the
- <emphasis>minimum</emphasis> protections each isolation level must
- provide.
+ in <xref linkend="mvcc-isolevel-table"> except for serialization
+ anomalies. As mentioned above, this is specifically allowed by the
+ standard, which only describes the <emphasis>minimum</emphasis>
+ protections each isolation level must provide.
</para>

<para>

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Tsunakawa, Takayuki 2016-05-25 00:01:20 Re: Mention pg_reload_conf() in ALTER SYSTEM page
Previous Message Tom Lane 2016-05-24 18:05:43 Re: Mention pg_reload_conf() in ALTER SYSTEM page