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 1nojhc-0000Rz-Rn for pgsql-docs@arkaria.postgresql.org; Wed, 11 May 2022 10:36:20 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nojhb-0002G7-Dy for pgsql-docs@arkaria.postgresql.org; Wed, 11 May 2022 10:36:19 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nojhb-0002Fy-2R for pgsql-docs@lists.postgresql.org; Wed, 11 May 2022 10:36:19 +0000 Received: from mail-ej1-x629.google.com ([2a00:1450:4864:20::629]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1nojhV-000180-V2 for pgsql-docs@lists.postgresql.org; Wed, 11 May 2022 10:36:17 +0000 Received: by mail-ej1-x629.google.com with SMTP id bv19so3134668ejb.6 for ; Wed, 11 May 2022 03:36:13 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec-at.20210112.gappssmtp.com; s=20210112; h=message-id:subject:from:to:date:in-reply-to:references:user-agent :mime-version:content-transfer-encoding; bh=q0wJ69W6gObavPNBeZ0YwngcT6E8A+3vhSzDKTvut94=; b=qOLkcx+BZI1OhJPcHJkmMbirW/xrP+eOtR5omLLYMtIB/fb8J9jSZkFGA5+XXj3Vix kOJvJiyX98WSqu8ZbdQcpdJubdM48i3Ytrz42TAe2CPKUw81Svrc+LOYsBKQiOcDMNAx qGAqvZETWoEXpdT+s4Br2Z9DRVnTKQ/I5bdMZGRw4ShpuSZURPvDgCgFeLDu/cjLctiP Z98eypjBhylCfQ1YgkRNPSDmIiDVlIkE7ZNeXfZ9KFWzuP0kcybrxwuPI7rpdoi2qe+I vf82k0nE0YawC3cRKV5rvAgKt4MzsXSIQa4EW8nItlgCi4oOV+nipSlXykMWlqtjz6p1 DO/A== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:message-id:subject:from:to:date:in-reply-to :references:user-agent:mime-version:content-transfer-encoding; bh=q0wJ69W6gObavPNBeZ0YwngcT6E8A+3vhSzDKTvut94=; b=3G0FXnNk/l3MAyJtyC3vd0YskcfleCtBnPLZBq9BUz1GU2mQ+xLXfPoPYDVt92PKs3 C4fVA22QuosVqeszEjNBMyo2Np6vSOJpFueforee5yFIjlEvdb9oSKoOARe3LM19rv3f jwNrR0EMqZJTvd5WSm8Yz9l23Oi9UkgXaBkax8LmF9xY4ydjsgGkvFWI0GyIqk+1rTKt atj5YBrfrMJFEaklUobwsb/TFMOJaIbSa7hUK3cDjDxuLfxe2WKm2wAhjpSKQBFlZ26v kJ0jvpHY5z8xf243vgGEZzAFSKK+EV6JYseAYAizQFIYg2v+qnNwqDrUiRyTAnf+jMDS z58g== X-Gm-Message-State: AOAM533ul8+ucsxcRZMOZd5hY2GShUqUbRP21E4y+O+we9eQENP1cOCb AFQ2DgUZi1A5sba+kDlW46oL+A== X-Google-Smtp-Source: ABdhPJxqpuZkP4WUIiq0CzfHSx6cLQqsNpxiPpb7OITD2Rnw9uHgxOtvshH2N1lad6hmpsO42G6spw== X-Received: by 2002:a17:907:a042:b0:6f3:b4fc:be3d with SMTP id gz2-20020a170907a04200b006f3b4fcbe3dmr23437556ejc.318.1652265372164; Wed, 11 May 2022 03:36:12 -0700 (PDT) Received: from dynamic-pd01.res.v6.highway.a1.net ([2001:871:5e:38f0:824b:d0c0:ba62:9aa5]) by smtp.gmail.com with ESMTPSA id r7-20020a17090638c700b006f3ef214e11sm814933ejd.119.2022.05.11.03.36.11 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 11 May 2022 03:36:11 -0700 (PDT) Message-ID: Subject: Re: correction From: Laurenz Albe To: akhilhello@gmail.com, pgsql-docs@lists.postgresql.org Date: Wed, 11 May 2022 12:36:11 +0200 In-Reply-To: <165222922369.669.10475917322916060899@wrigleys.postgresql.org> References: <165222922369.669.10475917322916060899@wrigleys.postgresql.org> Content-Type: text/plain; charset="UTF-8" User-Agent: Evolution 3.42.4 (3.42.4-2.fc35) MIME-Version: 1.0 Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Wed, 2022-05-11 at 00:33 +0000, PG Doc comments form wrote: > The following documentation comment has been logged on the website: > > Page: https://www.postgresql.org/docs/14/transaction-iso.html > Description: > > in this page: https://www.postgresql.org/docs/14/transaction-iso.html > > under the Table 13.1 section, if we search for "phantom reads. Stricter > behavior is permitted by the SQL standard", do we mean "Looser behaviour"? What is meant is "The SQL standard allows an implementation to implement stricter behavior than required by the standard; it only defines the things that are *not* allowed to happen at a certain isolation level. So it is for example fine for PostgreSQL not to allow dirty reads in READ UNCOMMITTED isolation level." Perhaps this could be rewritten to be clearer; it is indeed easy to misunderstand that sentence. Yours, Laurenz Albe