Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1b5bbB-00046D-Nc for pgsql-docs@arkaria.postgresql.org; Wed, 25 May 2016 16:23:57 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1b5bbB-0002K1-AC for pgsql-docs@arkaria.postgresql.org; Wed, 25 May 2016 16:23:57 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1b5bap-0001vb-Dh for pgsql-docs@postgresql.org; Wed, 25 May 2016 16:23:35 +0000 Received: from mail-oi0-x233.google.com ([2607:f8b0:4003:c06::233]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1b5bal-000611-KO for pgsql-docs@postgresql.org; Wed, 25 May 2016 16:23:34 +0000 Received: by mail-oi0-x233.google.com with SMTP id b65so86882787oia.1 for ; Wed, 25 May 2016 09:23:31 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc; bh=3GFwUiYH8R9whRydGe+ArHGLJXlbkL48M+ibR9sNJK0=; b=BXd6Bpt5wGiIdhuNCW1jga3+EiKRp6myQTvDjiJ6JhX8cTkFfEaEFKUPk+RCMgOZlf D0PThNUtfCaQ8K2okRFYvpvqirbqJhYElC8+JnE2Ws1C4UfDg02TjZ3Mtn2jpL1Faa1k Fu658rucNmklxGakYdzo3NGM7BCUGqIlYRFkwxa1cNnehEg1njffXBOz2y0uDh4lDUh+ VbOwObG6thl2LmvQEwQVidJtIpPkYHWVR7uaEQM2NMLxyqog1kt9UqpuA2oilBZ9ZNCn FMTF86MbDsW2qO9CnL0YQRQ7vKA8J1h+K9Jtq48oEH3PgeepXR7qxLIKYlUHdGXDki0o xh8A== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:mime-version:in-reply-to:references:date :message-id:subject:from:to:cc; bh=3GFwUiYH8R9whRydGe+ArHGLJXlbkL48M+ibR9sNJK0=; b=Kt3InnEfQMwkdPN2qGyHhj1qHaf9udikt2UitvzTK0Onr+LUEEePEV2kAFA0z3bxHK 3fOOVX20kaIWDDs3im0bN8tJguUbwRuIhhkN47aeyajieU80eu31uK9NQ/oma0sFzRUi w+rV1AfvHeH2maLx+yiFMmmEgB1RDs7Q2y+brqGAT5Wts+/ceL3x6Tuzpm5KOsQoAoX+ t2y8vxAFhH2x3T0FCJB7lVxyIGAl0dz18jos2mjqW3UfhLnUZO7Wkl5wGz97Ipq/owd3 wq/geKSfZx0wzq4Sh+Vdbw4RBNHk+OETdooYuCJrOLQnf+toy9OjpGPj23WLuKeXYDei SOlQ== X-Gm-Message-State: ALyK8tKXKv0N8f3fpQErm7Qtg3rcI+z35yVyCa1pfmy9DFPsMNYoAQ1uO1fx71HAleXAkLd0OnyCd183er7++g== MIME-Version: 1.0 X-Received: by 10.157.13.227 with SMTP id 90mr3149503ots.79.1464193409783; Wed, 25 May 2016 09:23:29 -0700 (PDT) Received: by 10.182.19.133 with HTTP; Wed, 25 May 2016 09:23:29 -0700 (PDT) In-Reply-To: <20160524203808.19432.60758@wrigleys.postgresql.org> References: <20160524203808.19432.60758@wrigleys.postgresql.org> Date: Wed, 25 May 2016 11:23:29 -0500 Message-ID: Subject: Re: Repeatable Read Table Reference From: Kevin Grittner To: swehren@gmail.com Cc: "pgsql-docs@postgresql.org" Content-Type: text/plain; charset=UTF-8 X-Pg-Spam-Score: -2.7 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-docs Precedence: bulk Sender: pgsql-docs-owner@postgresql.org On Tue, May 24, 2016 at 3:38 PM, wrote: > 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. Pushed. Thanks! -- Kevin Grittner EDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-docs