Subject: CVS commit: pkgsrc/databases
From: Adam Ciarcinski
Date: 2019-02-17 09:26:13
Message id: 20190217082613.B3873FB16@cvs.NetBSD.org

Log Message:
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

Files:
RevisionActionfile
1.11modifypkgsrc/databases/postgresql10/Makefile.common
1.9modifypkgsrc/databases/postgresql10/distinfo
1.6modifypkgsrc/databases/postgresql10-client/PLIST
1.8modifypkgsrc/databases/postgresql10-docs/PLIST
1.6modifypkgsrc/databases/postgresql10-server/Makefile
1.7modifypkgsrc/databases/postgresql10-server/PLIST
1.3modifypkgsrc/databases/postgresql11/Makefile.common
1.3modifypkgsrc/databases/postgresql11/distinfo
1.2modifypkgsrc/databases/postgresql11-client/PLIST
1.3modifypkgsrc/databases/postgresql11-docs/PLIST
1.3modifypkgsrc/databases/postgresql11-server/Makefile
1.2modifypkgsrc/databases/postgresql11-server/PLIST
1.29modifypkgsrc/databases/postgresql94/Makefile.common
1.25modifypkgsrc/databases/postgresql94/distinfo
1.23modifypkgsrc/databases/postgresql94-docs/PLIST
1.8modifypkgsrc/databases/postgresql94-server/Makefile
1.11modifypkgsrc/databases/postgresql94-server/PLIST
1.23modifypkgsrc/databases/postgresql95/Makefile.common
1.18modifypkgsrc/databases/postgresql95/distinfo
1.16modifypkgsrc/databases/postgresql95-docs/PLIST
1.8modifypkgsrc/databases/postgresql95-server/Makefile
1.9modifypkgsrc/databases/postgresql95-server/PLIST
1.17modifypkgsrc/databases/postgresql96/Makefile.common
1.14modifypkgsrc/databases/postgresql96/distinfo
1.6modifypkgsrc/databases/postgresql96-client/PLIST
1.12modifypkgsrc/databases/postgresql96-docs/PLIST
1.5modifypkgsrc/databases/postgresql96-server/Makefile
1.7modifypkgsrc/databases/postgresql96-server/PLIST
1.1removepkgsrc/databases/postgresql11/patches/patch-src_include_Makefile