[pkgsrc/trunk]: pkgsrc/databases postgresqlNN: updated to 11.2, 10.7, 9.6.12, ...

[adam <adam%pkgsrc.org@localhost>]

details:   https://anonhg.NetBSD.org/pkgsrc/rev/3c49eb2c526b
branches:  trunk
changeset: 329875:3c49eb2c526b
user:      adam <adam%pkgsrc.org@localhost>
date:      Sun Feb 17 08:26:11 2019 +0000

description:
postgresqlNN: updated to 11.2, 10.7, 9.6.12, 9.5.16, and 9.4.21

PostgreSQL 11.2, 10.7, 9.6.12, 9.5.16, and 9.4.21 Released!
This release changes the behavior in how PostgreSQL interfaces with fsync() and includes fixes for partitioning and over 70 other bugs that were reported over the past three months.

Fix handling of unique indexes with INCLUDE columns on partitioned tables
Ensure that NOT NULL constraints of a partitioned table are honored within its partitions
Several fixes for constraints on partitioned tables
Fix problems with applying ON COMMIT DROP and ON COMMIT DELETE ROWS to partitioned tables and tables with inheritance children
Disallow COPY FREEZE on partitioned tables
Several fixes for the ALTER TABLE .. ADD COLUMN with a non-nullable default feature, including a possible index corruption case
Several fixes in GIN indexes, including avoiding a deadlock with vacuuming and concurrent index insertions (which partially reverts a performance improvement introduced in PostgreSQL 10)
Fix possible crashes in logical replication when index expressions or predicates are in use
Several fixes for the write-ahead log (WAL)
Fix possible crash in UPDATE with a multiple SET clause using a sub-SELECT
Fix crash when zero rows are provided to json[b]_populate_recordset() or json[b]_to_recordset()
Several fixes related to collation handling, including the parsing of collation-sensitive expressions in the arguments of a CALL statement
Several fixes for the query planner, including an improvement to planning speed for large inheritance or partitioning table groups
Several fixes for TRUNCATE
Ensure ALTER TABLE ONLY ADD COLUMN IF NOT EXISTS is processed correctly
Allow UNLISTEN in hot-standby (replica) mode
Fix parsing of space-separated lists of host names in the ldapserver parameter of LDAP authentication entries in pg_hba.conf
Several fixes for ecpg
Several fixes for psql, including having \g target work with COPY TO STDOUT
The random number generation for pgbench is now fully deterministic and platform-independent when --random-seed=N is specified
Fix pg_basebackup and pg_verify_checksums to appropriately ignore temporary files
Several fixes for pg_dump, including having ALTER INDEX SET STATISTICS commands present
Prevent false index-corruption reports from contrib/amcheck caused by inline-compressed data
Support new Makefile variables to help with building extensions

diffstat:

 databases/postgresql10-client/PLIST                       |    3 +-
 databases/postgresql10-docs/PLIST                         |  368 +-------------
 databases/postgresql10-server/Makefile                    |    3 +-
 databases/postgresql10-server/PLIST                       |    3 +-
 databases/postgresql10/Makefile.common                    |    4 +-
 databases/postgresql10/distinfo                           |   10 +-
 databases/postgresql11-client/PLIST                       |    3 +-
 databases/postgresql11-docs/PLIST                         |  375 +-------------
 databases/postgresql11-server/Makefile                    |    3 +-
 databases/postgresql11-server/PLIST                       |    4 +-
 databases/postgresql11/Makefile.common                    |    4 +-
 databases/postgresql11/distinfo                           |   11 +-
 databases/postgresql11/patches/patch-src_include_Makefile |   15 -
 databases/postgresql94-docs/PLIST                         |  319 +-----------
 databases/postgresql94-server/Makefile                    |    3 +-
 databases/postgresql94-server/PLIST                       |    3 +-
 databases/postgresql94/Makefile.common                    |    4 +-
 databases/postgresql94/distinfo                           |   10 +-
 databases/postgresql95-docs/PLIST                         |  340 +------------
 databases/postgresql95-server/Makefile                    |    3 +-
 databases/postgresql95-server/PLIST                       |    3 +-
 databases/postgresql95/Makefile.common                    |    4 +-
 databases/postgresql95/distinfo                           |   10 +-
 databases/postgresql96-client/PLIST                       |    3 +-
 databases/postgresql96-docs/PLIST                         |  356 +-------------
 databases/postgresql96-server/Makefile                    |    3 +-
 databases/postgresql96-server/PLIST                       |    3 +-
 databases/postgresql96/Makefile.common                    |    4 +-
 databases/postgresql96/distinfo                           |   10 +-
 29 files changed, 77 insertions(+), 1807 deletions(-)

diffs (truncated from 2321 to 300 lines):

diff -r 79eb9b40ac0c -r 3c49eb2c526b databases/postgresql10-client/PLIST
--- a/databases/postgresql10-client/PLIST       Sun Feb 17 06:44:07 2019 +0000
+++ b/databases/postgresql10-client/PLIST       Sun Feb 17 08:26:11 2019 +0000
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.5 2018/08/10 11:56:10 adam Exp $
+@comment $NetBSD: PLIST,v 1.6 2019/02/17 08:26:11 adam Exp $
 bin/clusterdb
 bin/createdb
 bin/createuser
@@ -393,6 +393,7 @@
 include/postgresql/server/optimizer/geqo_selection.h
 include/postgresql/server/optimizer/joininfo.h
 include/postgresql/server/optimizer/orclauses.h
+include/postgresql/server/optimizer/paramassign.h
 include/postgresql/server/optimizer/pathnode.h
 include/postgresql/server/optimizer/paths.h
 include/postgresql/server/optimizer/placeholder.h
diff -r 79eb9b40ac0c -r 3c49eb2c526b databases/postgresql10-docs/PLIST
--- a/databases/postgresql10-docs/PLIST Sun Feb 17 06:44:07 2019 +0000
+++ b/databases/postgresql10-docs/PLIST Sun Feb 17 08:26:11 2019 +0000
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.7 2018/11/09 18:12:24 adam Exp $
+@comment $NetBSD: PLIST,v 1.8 2019/02/17 08:26:11 adam Exp $
 man/man1/clusterdb.1
 man/man1/createdb.1
 man/man1/createuser.1
@@ -456,6 +456,7 @@
 share/doc/postgresql/html/datetime-appendix.html
 share/doc/postgresql/html/datetime-config-files.html
 share/doc/postgresql/html/datetime-input-rules.html
+share/doc/postgresql/html/datetime-invalid-input.html
 share/doc/postgresql/html/datetime-keywords.html
 share/doc/postgresql/html/datetime-units-history.html
 share/doc/postgresql/html/dblink.html
@@ -907,376 +908,15 @@
 share/doc/postgresql/html/regress-tap.html
 share/doc/postgresql/html/regress-variant.html
 share/doc/postgresql/html/regress.html
-share/doc/postgresql/html/release-0-01.html
-share/doc/postgresql/html/release-0-02.html
-share/doc/postgresql/html/release-0-03.html
-share/doc/postgresql/html/release-1-0.html
-share/doc/postgresql/html/release-1-01.html
-share/doc/postgresql/html/release-1-02.html
-share/doc/postgresql/html/release-1-09.html
 share/doc/postgresql/html/release-10-1.html
 share/doc/postgresql/html/release-10-2.html
 share/doc/postgresql/html/release-10-3.html
 share/doc/postgresql/html/release-10-4.html
 share/doc/postgresql/html/release-10-5.html
 share/doc/postgresql/html/release-10-6.html
+share/doc/postgresql/html/release-10-7.html
 share/doc/postgresql/html/release-10.html
-share/doc/postgresql/html/release-6-0.html
-share/doc/postgresql/html/release-6-1-1.html
-share/doc/postgresql/html/release-6-1.html
-share/doc/postgresql/html/release-6-2-1.html
-share/doc/postgresql/html/release-6-2.html
-share/doc/postgresql/html/release-6-3-1.html
-share/doc/postgresql/html/release-6-3-2.html
-share/doc/postgresql/html/release-6-3.html
-share/doc/postgresql/html/release-6-4-1.html
-share/doc/postgresql/html/release-6-4-2.html
-share/doc/postgresql/html/release-6-4.html
-share/doc/postgresql/html/release-6-5-1.html
-share/doc/postgresql/html/release-6-5-2.html
-share/doc/postgresql/html/release-6-5-3.html
-share/doc/postgresql/html/release-6-5.html
-share/doc/postgresql/html/release-7-0-1.html
-share/doc/postgresql/html/release-7-0-2.html
-share/doc/postgresql/html/release-7-0-3.html
-share/doc/postgresql/html/release-7-0.html
-share/doc/postgresql/html/release-7-1-1.html
-share/doc/postgresql/html/release-7-1-2.html
-share/doc/postgresql/html/release-7-1-3.html
-share/doc/postgresql/html/release-7-1.html
-share/doc/postgresql/html/release-7-2-1.html
-share/doc/postgresql/html/release-7-2-2.html
-share/doc/postgresql/html/release-7-2-3.html
-share/doc/postgresql/html/release-7-2-4.html
-share/doc/postgresql/html/release-7-2-5.html
-share/doc/postgresql/html/release-7-2-6.html
-share/doc/postgresql/html/release-7-2-7.html
-share/doc/postgresql/html/release-7-2-8.html
-share/doc/postgresql/html/release-7-2.html
-share/doc/postgresql/html/release-7-3-1.html
-share/doc/postgresql/html/release-7-3-10.html
-share/doc/postgresql/html/release-7-3-11.html
-share/doc/postgresql/html/release-7-3-12.html
-share/doc/postgresql/html/release-7-3-13.html
-share/doc/postgresql/html/release-7-3-14.html
-share/doc/postgresql/html/release-7-3-15.html
-share/doc/postgresql/html/release-7-3-16.html
-share/doc/postgresql/html/release-7-3-17.html
-share/doc/postgresql/html/release-7-3-18.html
-share/doc/postgresql/html/release-7-3-19.html
-share/doc/postgresql/html/release-7-3-2.html
-share/doc/postgresql/html/release-7-3-20.html
-share/doc/postgresql/html/release-7-3-21.html
-share/doc/postgresql/html/release-7-3-3.html
-share/doc/postgresql/html/release-7-3-4.html
-share/doc/postgresql/html/release-7-3-5.html
-share/doc/postgresql/html/release-7-3-6.html
-share/doc/postgresql/html/release-7-3-7.html
-share/doc/postgresql/html/release-7-3-8.html
-share/doc/postgresql/html/release-7-3-9.html
-share/doc/postgresql/html/release-7-3.html
-share/doc/postgresql/html/release-7-4-1.html
-share/doc/postgresql/html/release-7-4-10.html
-share/doc/postgresql/html/release-7-4-11.html
-share/doc/postgresql/html/release-7-4-12.html
-share/doc/postgresql/html/release-7-4-13.html
-share/doc/postgresql/html/release-7-4-14.html
-share/doc/postgresql/html/release-7-4-15.html
-share/doc/postgresql/html/release-7-4-16.html
-share/doc/postgresql/html/release-7-4-17.html
-share/doc/postgresql/html/release-7-4-18.html
-share/doc/postgresql/html/release-7-4-19.html
-share/doc/postgresql/html/release-7-4-2.html
-share/doc/postgresql/html/release-7-4-20.html
-share/doc/postgresql/html/release-7-4-21.html
-share/doc/postgresql/html/release-7-4-22.html
-share/doc/postgresql/html/release-7-4-23.html
-share/doc/postgresql/html/release-7-4-24.html
-share/doc/postgresql/html/release-7-4-25.html
-share/doc/postgresql/html/release-7-4-26.html
-share/doc/postgresql/html/release-7-4-27.html
-share/doc/postgresql/html/release-7-4-28.html
-share/doc/postgresql/html/release-7-4-29.html
-share/doc/postgresql/html/release-7-4-3.html
-share/doc/postgresql/html/release-7-4-30.html
-share/doc/postgresql/html/release-7-4-4.html
-share/doc/postgresql/html/release-7-4-5.html
-share/doc/postgresql/html/release-7-4-6.html
-share/doc/postgresql/html/release-7-4-7.html
-share/doc/postgresql/html/release-7-4-8.html
-share/doc/postgresql/html/release-7-4-9.html
-share/doc/postgresql/html/release-7-4.html
-share/doc/postgresql/html/release-8-0-1.html
-share/doc/postgresql/html/release-8-0-10.html
-share/doc/postgresql/html/release-8-0-11.html
-share/doc/postgresql/html/release-8-0-12.html
-share/doc/postgresql/html/release-8-0-13.html
-share/doc/postgresql/html/release-8-0-14.html
-share/doc/postgresql/html/release-8-0-15.html
-share/doc/postgresql/html/release-8-0-16.html
-share/doc/postgresql/html/release-8-0-17.html
-share/doc/postgresql/html/release-8-0-18.html
-share/doc/postgresql/html/release-8-0-19.html
-share/doc/postgresql/html/release-8-0-2.html
-share/doc/postgresql/html/release-8-0-20.html
-share/doc/postgresql/html/release-8-0-21.html
-share/doc/postgresql/html/release-8-0-22.html
-share/doc/postgresql/html/release-8-0-23.html
-share/doc/postgresql/html/release-8-0-24.html
-share/doc/postgresql/html/release-8-0-25.html
-share/doc/postgresql/html/release-8-0-26.html
-share/doc/postgresql/html/release-8-0-3.html
-share/doc/postgresql/html/release-8-0-4.html
-share/doc/postgresql/html/release-8-0-5.html
-share/doc/postgresql/html/release-8-0-6.html
-share/doc/postgresql/html/release-8-0-7.html
-share/doc/postgresql/html/release-8-0-8.html
-share/doc/postgresql/html/release-8-0-9.html
-share/doc/postgresql/html/release-8-0.html
-share/doc/postgresql/html/release-8-1-1.html
-share/doc/postgresql/html/release-8-1-10.html
-share/doc/postgresql/html/release-8-1-11.html
-share/doc/postgresql/html/release-8-1-12.html
-share/doc/postgresql/html/release-8-1-13.html
-share/doc/postgresql/html/release-8-1-14.html
-share/doc/postgresql/html/release-8-1-15.html
-share/doc/postgresql/html/release-8-1-16.html
-share/doc/postgresql/html/release-8-1-17.html
-share/doc/postgresql/html/release-8-1-18.html
-share/doc/postgresql/html/release-8-1-19.html
-share/doc/postgresql/html/release-8-1-2.html
-share/doc/postgresql/html/release-8-1-20.html
-share/doc/postgresql/html/release-8-1-21.html
-share/doc/postgresql/html/release-8-1-22.html
-share/doc/postgresql/html/release-8-1-23.html
-share/doc/postgresql/html/release-8-1-3.html
-share/doc/postgresql/html/release-8-1-4.html
-share/doc/postgresql/html/release-8-1-5.html
-share/doc/postgresql/html/release-8-1-6.html
-share/doc/postgresql/html/release-8-1-7.html
-share/doc/postgresql/html/release-8-1-8.html
-share/doc/postgresql/html/release-8-1-9.html
-share/doc/postgresql/html/release-8-1.html
-share/doc/postgresql/html/release-8-2-1.html
-share/doc/postgresql/html/release-8-2-10.html
-share/doc/postgresql/html/release-8-2-11.html
-share/doc/postgresql/html/release-8-2-12.html
-share/doc/postgresql/html/release-8-2-13.html
-share/doc/postgresql/html/release-8-2-14.html
-share/doc/postgresql/html/release-8-2-15.html
-share/doc/postgresql/html/release-8-2-16.html
-share/doc/postgresql/html/release-8-2-17.html
-share/doc/postgresql/html/release-8-2-18.html
-share/doc/postgresql/html/release-8-2-19.html
-share/doc/postgresql/html/release-8-2-2.html
-share/doc/postgresql/html/release-8-2-20.html
-share/doc/postgresql/html/release-8-2-21.html
-share/doc/postgresql/html/release-8-2-22.html
-share/doc/postgresql/html/release-8-2-23.html
-share/doc/postgresql/html/release-8-2-3.html
-share/doc/postgresql/html/release-8-2-4.html
-share/doc/postgresql/html/release-8-2-5.html
-share/doc/postgresql/html/release-8-2-6.html
-share/doc/postgresql/html/release-8-2-7.html
-share/doc/postgresql/html/release-8-2-8.html
-share/doc/postgresql/html/release-8-2-9.html
-share/doc/postgresql/html/release-8-2.html
-share/doc/postgresql/html/release-8-3-1.html
-share/doc/postgresql/html/release-8-3-10.html
-share/doc/postgresql/html/release-8-3-11.html
-share/doc/postgresql/html/release-8-3-12.html
-share/doc/postgresql/html/release-8-3-13.html
-share/doc/postgresql/html/release-8-3-14.html
-share/doc/postgresql/html/release-8-3-15.html
-share/doc/postgresql/html/release-8-3-16.html
-share/doc/postgresql/html/release-8-3-17.html
-share/doc/postgresql/html/release-8-3-18.html
-share/doc/postgresql/html/release-8-3-19.html
-share/doc/postgresql/html/release-8-3-2.html
-share/doc/postgresql/html/release-8-3-20.html
-share/doc/postgresql/html/release-8-3-21.html
-share/doc/postgresql/html/release-8-3-22.html
-share/doc/postgresql/html/release-8-3-23.html
-share/doc/postgresql/html/release-8-3-3.html
-share/doc/postgresql/html/release-8-3-4.html
-share/doc/postgresql/html/release-8-3-5.html
-share/doc/postgresql/html/release-8-3-6.html
-share/doc/postgresql/html/release-8-3-7.html
-share/doc/postgresql/html/release-8-3-8.html
-share/doc/postgresql/html/release-8-3-9.html
-share/doc/postgresql/html/release-8-3.html
-share/doc/postgresql/html/release-8-4-1.html
-share/doc/postgresql/html/release-8-4-10.html
-share/doc/postgresql/html/release-8-4-11.html
-share/doc/postgresql/html/release-8-4-12.html
-share/doc/postgresql/html/release-8-4-13.html
-share/doc/postgresql/html/release-8-4-14.html
-share/doc/postgresql/html/release-8-4-15.html
-share/doc/postgresql/html/release-8-4-16.html
-share/doc/postgresql/html/release-8-4-17.html
-share/doc/postgresql/html/release-8-4-18.html
-share/doc/postgresql/html/release-8-4-19.html
-share/doc/postgresql/html/release-8-4-2.html
-share/doc/postgresql/html/release-8-4-20.html
-share/doc/postgresql/html/release-8-4-21.html
-share/doc/postgresql/html/release-8-4-22.html
-share/doc/postgresql/html/release-8-4-3.html
-share/doc/postgresql/html/release-8-4-4.html
-share/doc/postgresql/html/release-8-4-5.html
-share/doc/postgresql/html/release-8-4-6.html
-share/doc/postgresql/html/release-8-4-7.html
-share/doc/postgresql/html/release-8-4-8.html
-share/doc/postgresql/html/release-8-4-9.html
-share/doc/postgresql/html/release-8-4.html
-share/doc/postgresql/html/release-9-0-1.html
-share/doc/postgresql/html/release-9-0-10.html
-share/doc/postgresql/html/release-9-0-11.html
-share/doc/postgresql/html/release-9-0-12.html
-share/doc/postgresql/html/release-9-0-13.html
-share/doc/postgresql/html/release-9-0-14.html
-share/doc/postgresql/html/release-9-0-15.html
-share/doc/postgresql/html/release-9-0-16.html
-share/doc/postgresql/html/release-9-0-17.html
-share/doc/postgresql/html/release-9-0-18.html
-share/doc/postgresql/html/release-9-0-19.html
-share/doc/postgresql/html/release-9-0-2.html
-share/doc/postgresql/html/release-9-0-20.html
-share/doc/postgresql/html/release-9-0-21.html
-share/doc/postgresql/html/release-9-0-22.html
-share/doc/postgresql/html/release-9-0-23.html
-share/doc/postgresql/html/release-9-0-3.html
-share/doc/postgresql/html/release-9-0-4.html
-share/doc/postgresql/html/release-9-0-5.html
-share/doc/postgresql/html/release-9-0-6.html
-share/doc/postgresql/html/release-9-0-7.html
-share/doc/postgresql/html/release-9-0-8.html
-share/doc/postgresql/html/release-9-0-9.html
-share/doc/postgresql/html/release-9-0.html
-share/doc/postgresql/html/release-9-1-1.html
-share/doc/postgresql/html/release-9-1-10.html
-share/doc/postgresql/html/release-9-1-11.html
-share/doc/postgresql/html/release-9-1-12.html
-share/doc/postgresql/html/release-9-1-13.html
-share/doc/postgresql/html/release-9-1-14.html
-share/doc/postgresql/html/release-9-1-15.html
-share/doc/postgresql/html/release-9-1-16.html
-share/doc/postgresql/html/release-9-1-17.html
-share/doc/postgresql/html/release-9-1-18.html
-share/doc/postgresql/html/release-9-1-19.html
-share/doc/postgresql/html/release-9-1-2.html
-share/doc/postgresql/html/release-9-1-20.html
-share/doc/postgresql/html/release-9-1-21.html
-share/doc/postgresql/html/release-9-1-22.html
-share/doc/postgresql/html/release-9-1-23.html