diff options
| author | Bruce Momjian <bruce@momjian.us> | 2022-06-22 14:33:26 -0400 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2022-06-22 14:33:48 -0400 |
| commit | a9a230e623e551889b325bc5d50d9929e4d11a22 (patch) | |
| tree | b7e655f41a8468dcc1d42fb1c6873fa497cf4bd3 | |
| parent | e243de03fb4583dd4a9f0afb41493727d7946c02 (diff) | |
| download | postgresql-a9a230e623e551889b325bc5d50d9929e4d11a22.tar.gz postgresql-a9a230e623e551889b325bc5d50d9929e4d11a22.zip | |
doc: clarify wording about phantom reads
Reported-by: akhilhello@gmail.com
Discussion: https://postgr.es/m/165222922369.669.10475917322916060899@wrigleys.postgresql.org
Backpatch-through: 10
| -rw-r--r-- | doc/src/sgml/high-availability.sgml | 2 | ||||
| -rw-r--r-- | doc/src/sgml/mvcc.sgml | 7 |
2 files changed, 5 insertions, 4 deletions
diff --git a/doc/src/sgml/high-availability.sgml b/doc/src/sgml/high-availability.sgml index c7e402765fc..3df4cda7166 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. </para> <para> diff --git a/doc/src/sgml/mvcc.sgml b/doc/src/sgml/mvcc.sgml index 6b025909714..ff148bb3dcd 100644 --- a/doc/src/sgml/mvcc.sgml +++ b/doc/src/sgml/mvcc.sgml @@ -277,9 +277,10 @@ <para> 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 <emphasis>must</emphasis> happen. + does not allow phantom reads. This is acceptable under the SQL + standard because the standard specifies which anomalies must + <emphasis>not</emphasis> occur at certain isolation levels; higher + guarantees are acceptable. The behavior of the available isolation levels is detailed in the following subsections. </para> |