Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pzfQa-0003aU-G5 for pgsql-hackers@arkaria.postgresql.org; Thu, 18 May 2023 15:20:28 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pzfQZ-0003tw-1l for pgsql-hackers@arkaria.postgresql.org; Thu, 18 May 2023 15:20:27 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pzfQY-0003tn-OV for pgsql-hackers@lists.postgresql.org; Thu, 18 May 2023 15:20:26 +0000 Received: from mail-oa1-x2e.google.com ([2001:4860:4864:20::2e]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1pzfQV-000YML-0L for pgsql-hackers@lists.postgresql.org; Thu, 18 May 2023 15:20:26 +0000 Received: by mail-oa1-x2e.google.com with SMTP id 586e51a60fabf-192cb642f5dso956328fac.1 for ; Thu, 18 May 2023 08:20:23 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20221208; t=1684423221; x=1687015221; h=in-reply-to:content-disposition:mime-version:references:message-id :subject:cc:to:from:date:from:to:cc:subject:date:message-id:reply-to; bh=iRuYzMQzBmazt4MMh2AHK+wLUF36KGkDbx+V0qBUXmA=; b=iCygRPgJzqg1UThBXF4JiuCV4qiSODaYCM7PJF+h75hruIbMyqmy4M4MBaUkDaDJ1X 69I/c1JZa6W1cCdVufjs0GbXrY1/stg2ewJKqAisNjpl2mLR9aAPm/Xq8MalwVBQprCo XMUnzeWF5KJ5TjzVBKeJhkPM66Eww/eltxiz+akJ0iHqgKDVzIF4kOwA5oU6p4mdhPnK +AXd3mV0vhyJUdrw/qB4EkTpCpEnX+7zoklYWwWm4vrpJB763diFyS9tp/SOKgoHi/dC mzTmrR1FCt7BaIUutDS53v5BXw8pihu6dOvBD8JZV9hinnrDK46BlZjz6xeiRv+mzMIN YvlA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1684423221; x=1687015221; h=in-reply-to:content-disposition:mime-version:references:message-id :subject:cc:to:from:date:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=iRuYzMQzBmazt4MMh2AHK+wLUF36KGkDbx+V0qBUXmA=; b=LD4suvEQ+8R1eidscnOmKuFwHvp9ll/FpjKu28iVEc9xqZlh5dEI7ibi4ORPvGgafT xmnZgLfFiB2iFTycca71+CM5QqvNhki8VQ1nYCfSx0Ly7nv6Fk8qzyea7X0yWbX40uDg 1nLbfi81ZCeGnBHa4T8DJJzUA01Z2SWDxyHPkZQQAK9c/1I6wFdBN2yI/XuY5wpXzI/X kqk1JsWLBK8JjYRZWk9qt18tv3gjUXzgnPSA4CZF/Jm6DBR7CfYtwNIZQGc+IZ7UiUHT LaQFykaEDnipZ9cT+2BOw9tpDIzYCuFPbwwdTDfbUC/wcGPDWM2GWEsqg0xo8bvGcN9h YXsg== X-Gm-Message-State: AC+VfDyl7G73BWui4jFzGxY4vAvpbVgagUDZ0uBwLIffGKxbk6zQ2pRp pSiu8xnPDl3XXuygr32Fltk= X-Google-Smtp-Source: ACHHUZ7YxvHK+YVB58fp/QvYusLbcC26vb1GhLpCO9kUoiGRHFeebVBWF2Il6qX9+CMk9hx+HsbmyQ== X-Received: by 2002:a05:6870:9546:b0:196:58cd:4174 with SMTP id v6-20020a056870954600b0019658cd4174mr823666oal.10.1684423221158; Thu, 18 May 2023 08:20:21 -0700 (PDT) Received: from nathanxps13 (162-195-170-173.lightspeed.stlsmo.sbcglobal.net. [162.195.170.173]) by smtp.gmail.com with ESMTPSA id f12-20020a056830204c00b006a647f65d03sm762524otp.41.2023.05.18.08.20.20 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Thu, 18 May 2023 08:20:20 -0700 (PDT) Date: Thu, 18 May 2023 08:20:18 -0700 From: Nathan Bossart To: Tom Lane Cc: Aleksander Alekseev , PostgreSQL Hackers Subject: Re: The documentation for READ COMMITTED may be incomplete or wrong Message-ID: <20230518152018.GA3314690@nathanxps13> References: <3794290.1684421615@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <3794290.1684421615@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Thu, May 18, 2023 at 10:53:35AM -0400, Tom Lane wrote: > That's not a documentation problem. That's a bug, and an extremely > nasty one. A quick check shows that it works as expected up through > v13, but fails as described in v14 and later. Needs bisecting ... git-bisect points me to 86dc900. -- Nathan Bossart Amazon Web Services: https://aws.amazon.com