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 1qCrxG-0004gE-57 for pgsql-docs@arkaria.postgresql.org; Sat, 24 Jun 2023 01:20:46 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1qCrxD-0008N3-Lh for pgsql-docs@arkaria.postgresql.org; Sat, 24 Jun 2023 01:20:43 +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 1qCrxD-0008Mp-E3 for pgsql-docs@lists.postgresql.org; Sat, 24 Jun 2023 01:20:43 +0000 Received: from momjian.us ([72.94.173.45]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qCrx7-0006Mp-9D for pgsql-docs@lists.postgresql.org; Sat, 24 Jun 2023 01:20:42 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=momjian.us; s=2023062311; h=In-Reply-To:Content-Type:MIME-Version:References:Message-ID: Subject:Cc:To:From:Date:Sender:Reply-To:Content-Transfer-Encoding:Content-ID: Content-Description:Resent-Date:Resent-From:Resent-Sender:Resent-To:Resent-Cc :Resent-Message-ID:List-Id:List-Help:List-Unsubscribe:List-Subscribe: List-Post:List-Owner:List-Archive; bh=Lr75iMo2gARrP1Ufgrk1HReYXgZGBNICVC1J2PQNKSU=; b=fAUs8VJBxJ4wFaxXCYDoOnfyA/ 2phqjqCPabCnxXFaWD12lVMTNOX5NwHQZFpra4werOZtZ65PJqFXNDlkTvGbuyeZqE2WCyo+8IYAq O4p0pGZf/xaAvZl27VzjK66tz76OhsKNuegiiij2QKhYMB43vDziUjYsxZj6LbcRqtiMio0txY2pR mb5RIGFtIQsg6mUvYV4z1zDGk8Uu4rQ3c1IiI0hMA0/4413vVdpUuQ7gLVsJdfQUcU7xlGskRjshD 5I9NAfMPwHNbuB6yWCTQms61l1a6kJW+uv18laZIDbmz5zy2G7/V8CDq25yVlm1XBsCugErA2Gtqe eyUxBevA==; Received: from bruce by momjian.us with local (Exim 4.94.2) (envelope-from ) id 1qCrx5-00AzBp-65; Fri, 23 Jun 2023 21:20:35 -0400 Date: Fri, 23 Jun 2023 21:20:35 -0400 From: Bruce Momjian To: Tom Lane Cc: anton.sidyakin@gmail.com, pgsql-docs@lists.postgresql.org Subject: Re: bad choice of the word in sentence Message-ID: References: <168745911769.2239590.6062411529242609290@wrigleys.postgresql.org> <112752.1687569399@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <112752.1687569399@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Fri, Jun 23, 2023 at 09:16:39PM -0400, Tom Lane wrote: > Bruce Momjian writes: > > On Thu, Jun 22, 2023 at 06:38:37PM +0000, PG Doc comments form wrote: > >> Quote: > >> "<...>When a transaction uses this isolation level, a SELECT query (without > >> a FOR UPDATE/SHARE clause) sees only data committed before the query began; > >> it never sees either uncommitted data or changes committed during query > >> execution by concurrent transactions. <...>" > > >> Don't you think this is bad choice of the word, especially while speaking > >> about "commiting transactions" in very same sentence? > > > No, the issue is only for committed transactions, not aborted ones. > > I think this sentence is formally correct, but it is not very hard to > misparse. Maybe a bit of re-ordering would help? Like > > ... it never sees either uncommitted data or changes committed by > concurrent transactions during the query's execution. Sure. -- Bruce Momjian https://momjian.us EDB https://enterprisedb.com Only you can decide what is important to you.