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 1nyiyu-0008Go-OU for pgsql-docs@arkaria.postgresql.org; Tue, 07 Jun 2022 23:51: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 1nyiyt-0007Iu-BX for pgsql-docs@arkaria.postgresql.org; Tue, 07 Jun 2022 23:51: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 1nyiyt-0007Hw-3l for pgsql-docs@lists.postgresql.org; Tue, 07 Jun 2022 23:51:27 +0000 Received: from momjian.us ([72.94.173.45]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nyiyq-0007U5-Kl for pgsql-docs@lists.postgresql.org; Tue, 07 Jun 2022 23:51:26 +0000 Received: from bruce by momjian.us with local (Exim 4.94.2) (envelope-from ) id 1nyiym-000sfu-AL; Tue, 07 Jun 2022 19:51:20 -0400 Date: Tue, 7 Jun 2022 19:51:20 -0400 From: Bruce Momjian To: "David G. Johnston" Cc: Laurenz Albe , akhilhello@gmail.com, Pg Docs Subject: Re: correction Message-ID: References: <165222922369.669.10475917322916060899@wrigleys.postgresql.org> <179f4ffe247c3d6c0938217ef85948bcebb97bdb.camel@cybertec.at> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="n1vyPUNquHhjSIPA" Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --n1vyPUNquHhjSIPA Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Tue, Jun 7, 2022 at 02:40:41PM -0700, David G. Johnston wrote: > On Tue, Jun 7, 2022 at 2:07 PM Bruce Momjian wrote: > > > > How is this, attached? > > > > Works for me. > > Capital "S" in Standard as a proper name? (mind grepping this to see how > consistent we are one way or the other, I'm not setup for that at the moment) Well, that's a good question. Seems we use "SQL standard", and I found one place where we capitalize "Standard", so fixed too in this patch. -- Bruce Momjian https://momjian.us EDB https://enterprisedb.com Indecision is a decision. Inaction is an action. Mark Batterson --n1vyPUNquHhjSIPA Content-Type: text/x-diff; charset=us-ascii Content-Disposition: attachment; filename="strict.diff" diff --git a/doc/src/sgml/high-availability.sgml b/doc/src/sgml/high-availability.sgml index c7e402765f..3df4cda716 100644 --- a/doc/src/sgml/high-availability.sgml +++ b/doc/src/sgml/high-availability.sgml @@ -2194,7 +2194,7 @@ HINT: You can then restart the server after making the necessary configuration Currently, temporary table creation is not allowed during read-only transactions, so in some cases existing scripts will not run correctly. This restriction might be relaxed in a later release. This is - both an SQL Standard compliance issue and a technical issue. + both an SQL standard compliance issue and a technical issue. diff --git a/doc/src/sgml/mvcc.sgml b/doc/src/sgml/mvcc.sgml index 341fea524a..112d6ce7a8 100644 --- a/doc/src/sgml/mvcc.sgml +++ b/doc/src/sgml/mvcc.sgml @@ -277,9 +277,10 @@ The table also shows that PostgreSQL's Repeatable Read implementation - does not allow phantom reads. Stricter behavior is permitted by the - SQL standard: the four isolation levels only define which phenomena - must not happen, not which phenomena must happen. + does not allow phantom reads. This is acceptable under the SQL + standard because the standard specifies which anomalies must + not occur at certain isolation levels; higher + guarantees are acceptable. The behavior of the available isolation levels is detailed in the following subsections. --n1vyPUNquHhjSIPA--