pgsql: First-draft release notes for 11.1.

2018-11-02 Thread Tom Lane
First-draft release notes for 11.1. As usual, the release notes for other branches will be made by cutting these down, but put them up for community review first. Note that a fair percentage of the entries apply only to prior branches because their issue was already fixed in 11.0. Branch --

pgsql: Yet further rethinking of build changes for macOS Mojave.

2018-11-02 Thread Tom Lane
Yet further rethinking of build changes for macOS Mojave. The solution arrived at in commit e74dd00f5 presumes that the compiler has a suitable default -isysroot setting ... but further experience shows that in many combinations of macOS version, XCode version, Xcode command line tools version, an

pgsql: Yet further rethinking of build changes for macOS Mojave.

2018-11-02 Thread Tom Lane
Yet further rethinking of build changes for macOS Mojave. The solution arrived at in commit e74dd00f5 presumes that the compiler has a suitable default -isysroot setting ... but further experience shows that in many combinations of macOS version, XCode version, Xcode command line tools version, an

pgsql: Yet further rethinking of build changes for macOS Mojave.

2018-11-02 Thread Tom Lane
Yet further rethinking of build changes for macOS Mojave. The solution arrived at in commit e74dd00f5 presumes that the compiler has a suitable default -isysroot setting ... but further experience shows that in many combinations of macOS version, XCode version, Xcode command line tools version, an

pgsql: Yet further rethinking of build changes for macOS Mojave.

2018-11-02 Thread Tom Lane
Yet further rethinking of build changes for macOS Mojave. The solution arrived at in commit e74dd00f5 presumes that the compiler has a suitable default -isysroot setting ... but further experience shows that in many combinations of macOS version, XCode version, Xcode command line tools version, an

pgsql: Yet further rethinking of build changes for macOS Mojave.

2018-11-02 Thread Tom Lane
Yet further rethinking of build changes for macOS Mojave. The solution arrived at in commit e74dd00f5 presumes that the compiler has a suitable default -isysroot setting ... but further experience shows that in many combinations of macOS version, XCode version, Xcode command line tools version, an

pgsql: Yet further rethinking of build changes for macOS Mojave.

2018-11-02 Thread Tom Lane
Yet further rethinking of build changes for macOS Mojave. The solution arrived at in commit e74dd00f5 presumes that the compiler has a suitable default -isysroot setting ... but further experience shows that in many combinations of macOS version, XCode version, Xcode command line tools version, an

pgsql: Yet further rethinking of build changes for macOS Mojave.

2018-11-02 Thread Tom Lane
Yet further rethinking of build changes for macOS Mojave. The solution arrived at in commit e74dd00f5 presumes that the compiler has a suitable default -isysroot setting ... but further experience shows that in many combinations of macOS version, XCode version, Xcode command line tools version, an

pgsql: Fix NULL handling in multi-batch Parallel Hash Left Join.

2018-11-02 Thread Thomas Munro
Fix NULL handling in multi-batch Parallel Hash Left Join. NULL keys in left joins were skipped when building batch files. Repair, by making the keep_nulls argument to ExecHashGetHashValue() depend on whether this is a left outer join, as we do in other paths. Bug #15475. Thinko in 1804284042e.

pgsql: Fix NULL handling in multi-batch Parallel Hash Left Join.

2018-11-02 Thread Thomas Munro
Fix NULL handling in multi-batch Parallel Hash Left Join. NULL keys in left joins were skipped when building batch files. Repair, by making the keep_nulls argument to ExecHashGetHashValue() depend on whether this is a left outer join, as we do in other paths. Bug #15475. Thinko in 1804284042e.

pgsql: docs: adjust simpler language for NULL return from ANY/ALL

2018-11-02 Thread Bruce Momjian
docs: adjust simpler language for NULL return from ANY/ALL Adjustment to commit 8610c973ddf1cbf0befc1369d2cf0d56c0efcd0a. Reported-by: Tom Lane Discussion: https://postgr.es/m/[email protected] Backpatch-through: 9.3 Branch -- REL9_3_STABLE Details --- https://git.postgr

pgsql: docs: adjust simpler language for NULL return from ANY/ALL

2018-11-02 Thread Bruce Momjian
docs: adjust simpler language for NULL return from ANY/ALL Adjustment to commit 8610c973ddf1cbf0befc1369d2cf0d56c0efcd0a. Reported-by: Tom Lane Discussion: https://postgr.es/m/[email protected] Backpatch-through: 9.3 Branch -- REL9_6_STABLE Details --- https://git.postgr

pgsql: docs: adjust simpler language for NULL return from ANY/ALL

2018-11-02 Thread Bruce Momjian
docs: adjust simpler language for NULL return from ANY/ALL Adjustment to commit 8610c973ddf1cbf0befc1369d2cf0d56c0efcd0a. Reported-by: Tom Lane Discussion: https://postgr.es/m/[email protected] Backpatch-through: 9.3 Branch -- REL9_4_STABLE Details --- https://git.postgr

pgsql: docs: adjust simpler language for NULL return from ANY/ALL

2018-11-02 Thread Bruce Momjian
docs: adjust simpler language for NULL return from ANY/ALL Adjustment to commit 8610c973ddf1cbf0befc1369d2cf0d56c0efcd0a. Reported-by: Tom Lane Discussion: https://postgr.es/m/[email protected] Backpatch-through: 9.3 Branch -- REL_11_STABLE Details --- https://git.postgr

pgsql: docs: adjust simpler language for NULL return from ANY/ALL

2018-11-02 Thread Bruce Momjian
docs: adjust simpler language for NULL return from ANY/ALL Adjustment to commit 8610c973ddf1cbf0befc1369d2cf0d56c0efcd0a. Reported-by: Tom Lane Discussion: https://postgr.es/m/[email protected] Backpatch-through: 9.3 Branch -- master Details --- https://git.postgresql.or

pgsql: docs: adjust simpler language for NULL return from ANY/ALL

2018-11-02 Thread Bruce Momjian
docs: adjust simpler language for NULL return from ANY/ALL Adjustment to commit 8610c973ddf1cbf0befc1369d2cf0d56c0efcd0a. Reported-by: Tom Lane Discussion: https://postgr.es/m/[email protected] Backpatch-through: 9.3 Branch -- REL_10_STABLE Details --- https://git.postgr

Re: pgsql: doc: use simpler language for NULL return from ANY/ALL

2018-11-02 Thread Bruce Momjian
On Fri, Nov 2, 2018 at 10:20:21AM -0400, Tom Lane wrote: > Bruce Momjian writes: > > doc: use simpler language for NULL return from ANY/ALL > > Previously the combination of "does not return" and "any row" caused > > ambiguity. > > IMO this is not an improvement. It's turned something that rea

pgsql: docs: adjust simpler language for NULL return from ANY/ALL

2018-11-02 Thread Bruce Momjian
docs: adjust simpler language for NULL return from ANY/ALL Adjustment to commit 8610c973ddf1cbf0befc1369d2cf0d56c0efcd0a. Reported-by: Tom Lane Discussion: https://postgr.es/m/[email protected] Backpatch-through: 9.3 Branch -- REL9_5_STABLE Details --- https://git.postgr

Re: pgsql: doc: use simpler language for NULL return from ANY/ALL

2018-11-02 Thread Tom Lane
Bruce Momjian writes: > doc: use simpler language for NULL return from ANY/ALL > Previously the combination of "does not return" and "any row" caused > ambiguity. IMO this is not an improvement. It's turned something that read reasonably well into something that sounds like it was written by a

pgsql: GUC: adjust effective_cache_size docs and SQL description

2018-11-02 Thread Bruce Momjian
GUC: adjust effective_cache_size docs and SQL description Clarify that effective_cache_size is both kernel buffers and shared buffers. Reported-by: [email protected] Discussion: https://postgr.es/m/[email protected] Backpatch-through: 9.3 Bran

pgsql: GUC: adjust effective_cache_size docs and SQL description

2018-11-02 Thread Bruce Momjian
GUC: adjust effective_cache_size docs and SQL description Clarify that effective_cache_size is both kernel buffers and shared buffers. Reported-by: [email protected] Discussion: https://postgr.es/m/[email protected] Backpatch-through: 9.3 Bran

pgsql: GUC: adjust effective_cache_size docs and SQL description

2018-11-02 Thread Bruce Momjian
GUC: adjust effective_cache_size docs and SQL description Clarify that effective_cache_size is both kernel buffers and shared buffers. Reported-by: [email protected] Discussion: https://postgr.es/m/[email protected] Backpatch-through: 9.3 Bran

pgsql: GUC: adjust effective_cache_size docs and SQL description

2018-11-02 Thread Bruce Momjian
GUC: adjust effective_cache_size docs and SQL description Clarify that effective_cache_size is both kernel buffers and shared buffers. Reported-by: [email protected] Discussion: https://postgr.es/m/[email protected] Backpatch-through: 9.3 Bran

pgsql: GUC: adjust effective_cache_size docs and SQL description

2018-11-02 Thread Bruce Momjian
GUC: adjust effective_cache_size docs and SQL description Clarify that effective_cache_size is both kernel buffers and shared buffers. Reported-by: [email protected] Discussion: https://postgr.es/m/[email protected] Backpatch-through: 9.3 Bran

pgsql: GUC: adjust effective_cache_size docs and SQL description

2018-11-02 Thread Bruce Momjian
GUC: adjust effective_cache_size docs and SQL description Clarify that effective_cache_size is both kernel buffers and shared buffers. Reported-by: [email protected] Discussion: https://postgr.es/m/[email protected] Backpatch-through: 9.3 Bran

pgsql: GUC: adjust effective_cache_size docs and SQL description

2018-11-02 Thread Bruce Momjian
GUC: adjust effective_cache_size docs and SQL description Clarify that effective_cache_size is both kernel buffers and shared buffers. Reported-by: [email protected] Discussion: https://postgr.es/m/[email protected] Backpatch-through: 9.3 Bran

pgsql: Fix spelling errors and typos in comments

2018-11-02 Thread Magnus Hagander
Fix spelling errors and typos in comments Author: Daniel Gustafsson Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/fbec7459aa39da864ad1d578f044a21c3b3b057c Modified Files -- src/backend/access/nbtree/nbtsearch.c | 2 +- src/backend/access/transam/

pgsql: Fix some spelling errors in the documentation

2018-11-02 Thread Magnus Hagander
Fix some spelling errors in the documentation Author: Daniel Gustafsson Branch -- REL9_4_STABLE Details --- https://git.postgresql.org/pg/commitdiff/1ac334b165bb55cfa9441218713ead7b8421f9ca Modified Files -- doc/src/sgml/libpq.sgml | 6 +++--- doc/src/sgml/lobj.sgml | 2 +-

pgsql: Fix some spelling errors in the documentation

2018-11-02 Thread Magnus Hagander
Fix some spelling errors in the documentation Author: Daniel Gustafsson Branch -- REL9_5_STABLE Details --- https://git.postgresql.org/pg/commitdiff/51afe7602bfa703f93b22fb81f13e8201f0f2b56 Modified Files -- doc/src/sgml/libpq.sgml | 6 +++--- doc/src/sgml/lobj.sgml | 2 +-

pgsql: Fix some spelling errors in the documentation

2018-11-02 Thread Magnus Hagander
Fix some spelling errors in the documentation Author: Daniel Gustafsson Branch -- REL_11_STABLE Details --- https://git.postgresql.org/pg/commitdiff/708b96d56aee3cee830623f26c231e371fda19e4 Modified Files -- doc/src/sgml/libpq.sgml | 6 +++--- doc/src/sgml/lobj

pgsql: Fix some spelling errors in the documentation

2018-11-02 Thread Magnus Hagander
Fix some spelling errors in the documentation Author: Daniel Gustafsson Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/0083a824333874570ec34b23c9acd445d1183036 Modified Files -- doc/src/sgml/libpq.sgml | 6 +++--- doc/src/sgml/lobj.sgml

pgsql: Fix some spelling errors in the documentation

2018-11-02 Thread Magnus Hagander
Fix some spelling errors in the documentation Author: Daniel Gustafsson Branch -- REL_10_STABLE Details --- https://git.postgresql.org/pg/commitdiff/919cffd323a0408a31cde7bc58994add5694b7fc Modified Files -- doc/src/sgml/libpq.sgml | 6 +++--- doc/src/sgml/lobj.sgml | 2 +-

pgsql: Fix some spelling errors in the documentation

2018-11-02 Thread Magnus Hagander
Fix some spelling errors in the documentation Author: Daniel Gustafsson Branch -- REL9_6_STABLE Details --- https://git.postgresql.org/pg/commitdiff/4f67ff17e2b302a97b1a10127d91746d54f4655c Modified Files -- doc/src/sgml/libpq.sgml | 6 +++--- doc/src/sgml/lobj.sgml | 2 +-

pgsql: doc: use simpler language for NULL return from ANY/ALL

2018-11-02 Thread Bruce Momjian
doc: use simpler language for NULL return from ANY/ALL Previously the combination of "does not return" and "any row" caused ambiguity. Reported-by: KES Discussion: https://postgr.es/m/[email protected] Reviewed-by: David G. Johnston Backpatch-thr

pgsql: doc: use simpler language for NULL return from ANY/ALL

2018-11-02 Thread Bruce Momjian
doc: use simpler language for NULL return from ANY/ALL Previously the combination of "does not return" and "any row" caused ambiguity. Reported-by: KES Discussion: https://postgr.es/m/[email protected] Reviewed-by: David G. Johnston Backpatch-thr

pgsql: doc: use simpler language for NULL return from ANY/ALL

2018-11-02 Thread Bruce Momjian
doc: use simpler language for NULL return from ANY/ALL Previously the combination of "does not return" and "any row" caused ambiguity. Reported-by: KES Discussion: https://postgr.es/m/[email protected] Reviewed-by: David G. Johnston Backpatch-thr

pgsql: doc: use simpler language for NULL return from ANY/ALL

2018-11-02 Thread Bruce Momjian
doc: use simpler language for NULL return from ANY/ALL Previously the combination of "does not return" and "any row" caused ambiguity. Reported-by: KES Discussion: https://postgr.es/m/[email protected] Reviewed-by: David G. Johnston Backpatch-thr

pgsql: doc: use simpler language for NULL return from ANY/ALL

2018-11-02 Thread Bruce Momjian
doc: use simpler language for NULL return from ANY/ALL Previously the combination of "does not return" and "any row" caused ambiguity. Reported-by: KES Discussion: https://postgr.es/m/[email protected] Reviewed-by: David G. Johnston Backpatch-thr

pgsql: doc: use simpler language for NULL return from ANY/ALL

2018-11-02 Thread Bruce Momjian
doc: use simpler language for NULL return from ANY/ALL Previously the combination of "does not return" and "any row" caused ambiguity. Reported-by: KES Discussion: https://postgr.es/m/[email protected] Reviewed-by: David G. Johnston Backpatch-thr

pgsql: doc: use simpler language for NULL return from ANY/ALL

2018-11-02 Thread Bruce Momjian
doc: use simpler language for NULL return from ANY/ALL Previously the combination of "does not return" and "any row" caused ambiguity. Reported-by: KES Discussion: https://postgr.es/m/[email protected] Reviewed-by: David G. Johnston Backpatch-thr