Subject: CVS commit: pkgsrc/databases
From: Adam Ciarcinski
Date: 2019-06-23 09:56:00
Message id: 20190623075600.5ED79FBF4@cvs.NetBSD.org

Log Message:
postgresqlNN: updated to 11.4, 10.9, 9.6.14, 9.5.18, 9.4.23

PostgreSQL 11.4, 10.9, 9.6.14, 9.5.18, 9.4.23, and 12 Beta 2 Released!

The PostgreSQL Global Development Group has released an update to all supported \ 
versions of our database system, including 11.4, 10.9, 9.6.14, 9.5.18, and \ 
9.4.23, as well as the second beta of PostgreSQL 12. This release fixes one \ 
security issue and over 25 bugs since the previous cumulative update in May.

Security Issues

This release closes one security vulnerability:
CVE-2019-10164: Stack-based buffer overflow via setting a password
Versions affected: 10, 11, 12 beta.

Bug Fixes and Improvements

Fix assorted errors in run-time partition pruning that could lead to wrong \ 
answers in queries on partitioned tables
pg_dump now recreates table partitions using CREATE TABLE and ALTER TABLE .. \ 
ATTACH PARTITION rather than including PARTITION OF in the creation command
Improve how initdb determines which system time zone to select if there are \ 
equivalent names for the time zone. Also explicitly prefer UTC over UCT
Fix possible crash while trying to copy trigger definitions to a new partition
Fix failure of ALTER TABLE .. ALTER COLUMN TYPE when the table has a partial \ 
exclusion constraint
Fix failure of COMMENT command for comments on domains
Several fixes related to aggregation
Fix faulty generation of merge-append plans that could lead to "could not \ 
find pathkey item to sort" errors
Fix failures on dump/restore where views contained queries with duplicate join names
Fix conversion of JSON string literals to JSON-type output columns in \ 
json_to_record() and json_populate_record()
Fix incorrect optimization of {1,1} quantifiers in regular expressions
Fix issue for B-tree indexes during edge case failure involving columns covered \ 
with the INCLUDE clause, which manifests itself with errors during VACUUM. If \ 
you are affected by this issue, you will need to reindex the specific index
Fix race condition in check to see whether a pre-existing shared memory segment \ 
is still in use by a conflicting postmaster
Fix for the walreceiver process that avoids a crash or deadlock on shutdown
Avoid possible hang in libpq if using SSL and OpenSSL's pending-data buffer \ 
contains an exact multiple of 256 bytes
Fix ordering of GRANT commands emitted by pg_dump and pg_dumpall for databases \ 
and tablespaces
Fix misleading error reports from reindexdb
Ensure that vacuumdb returns correct status if an error occurs while using \ 
parallel jobs
Fix contrib/auto_explain to not cause problems in parallel queries, which \ 
resulted in failures like "could not find key N in shm TOC"
Account for possible data modifications by local BEFORE ROW UPDATE triggers in \ 
contrib/postgres_fdw
On Windows, avoid failure when the database encoding is set to SQL_ASCII and we \ 
attempt to log a non-ASCII string

Files:
RevisionActionfile
1.13modifypkgsrc/databases/postgresql10/Makefile.common
1.11modifypkgsrc/databases/postgresql10/distinfo
1.10modifypkgsrc/databases/postgresql10-docs/PLIST
1.5modifypkgsrc/databases/postgresql11/Makefile.common
1.5modifypkgsrc/databases/postgresql11/distinfo
1.5modifypkgsrc/databases/postgresql11-docs/PLIST
1.2modifypkgsrc/databases/postgresql11-pltcl/PLIST
1.31modifypkgsrc/databases/postgresql94/Makefile.common
1.27modifypkgsrc/databases/postgresql94/distinfo
1.25modifypkgsrc/databases/postgresql94-docs/PLIST
1.25modifypkgsrc/databases/postgresql95/Makefile.common
1.20modifypkgsrc/databases/postgresql95/distinfo
1.18modifypkgsrc/databases/postgresql95-docs/PLIST
1.19modifypkgsrc/databases/postgresql96/Makefile.common
1.16modifypkgsrc/databases/postgresql96/distinfo
1.14modifypkgsrc/databases/postgresql96-docs/PLIST
1.1removepkgsrc/databases/postgresql10-server/MESSAGE.rcd
1.1removepkgsrc/databases/postgresql11-server/MESSAGE.rcd
1.1removepkgsrc/databases/postgresql94-server/MESSAGE.rcd
1.1removepkgsrc/databases/postgresql95-server/MESSAGE.rcd
1.1removepkgsrc/databases/postgresql96-server/MESSAGE.rcd