Subject: CVS commit: pkgsrc/databases
From: Adam Ciarcinski
Date: 2017-11-13 10:33:33
Message id: 20171113093333.D4265FBDE@cvs.NetBSD.org

Log Message:
postgresql: updated to the latest

The PostgreSQL Global Development Group has released an update to all supported \ 
versions of our database system, including 10.1, 9.6.6, 9.5.10, 9.4.15, 9.3.20, \ 
and 9.2.24. This release fixes three security issues. This release also fixes \ 
issues found in BRIN indexing, logical replication and other bugs reported over \ 
the past three months.

All users using the affected versions of PostgreSQL should update as soon as \ 
possible. If you use BRIN indexes or contrib/start-scripts, please see the \ 
release notes for additional post-upgrade steps.

Security Issues

Three security vulnerabilities have been fixed by this release:

CVE-2017-12172: Start scripts permit database administrator to modify root-owned \ 
files
CVE-2017-15098: Memory disclosure in JSON functions
CVE-2017-15099: INSERT ... ON CONFLICT DO UPDATE fails to enforce SELECT privileges

Bug Fixes and Improvements

This update also fixes a number of bugs reported in the last few months. Some of \ 
these issues affect only version 10, but many affect all supported versions:

Fix a race condition in BRIN indexing that could cause some rows to not be \ 
included in the indexing.
Fix crash when logical decoding is invoked from a PL language function.
Several fixes for logical replication.
Restored behavior for CTEs attached to INSERT/UPDATE/DELETE statements to \ 
pre-version 10.
Prevent low-probability crash in processing of nested trigger firings.
Do not evaluate an aggregate function's argument expressions when the conditions \ 
in the FILTER clause evaluate to FALSE. This complies with SQL-standard \ 
behavior.
Fix incorrect query results when multiple GROUPING SETS columns contain the same \ 
simple variable.
Fix memory leak over the lifespan of a query when evaluating a set-returning \ 
function from the target list in a SELECT.
Several fixes for parallel query execution, including fixing a crash in the \ 
parallel execution of certain queries that contain a certain type of bitmap \ 
scan.
Fix json_build_array(), json_build_object(), jsonb_build_array(), and \ 
jsonb_build_object() to handle explicit VARIADIC arguments correctly.
Prevent infinite float values from being casted to the numeric type.
Fix autovacuum's “work item” logic to prevent possible crashes and silent \ 
loss of work items.
Several fixes for VIEWs around adding columns to the end of a view.
Fix for hashability detection of range data types that are created by a user.
Improvements on using extended statistics on columns for the purposes of query \ 
planning.
Prevent idle_in_transaction_session_timeout from being ignored when a \ 
statement_timeout occurred earlier.
Fix low-probability loss of NOTIFY messages due more than 2 billion transactions \ 
processing before any queries are executed in the session.
Several file system interaction fixes.
Correctly restore the umask setting when file creation fails in COPY or lo_export().
Fix pg_dump to ensure that it emits GRANT commands in a valid order.
Fix pg_basebackup's matching of tablespace paths to canonicalize both paths \ 
before comparing to help improve Windows compatibility.
Fix libpq to not require user's home directory to exist when trying to read the \ 
"~/.pgpass" file.
Several fixes for ecpg.

Files:
RevisionActionfile
1.3modifypkgsrc/databases/postgresql10/Makefile.common
1.2modifypkgsrc/databases/postgresql10/distinfo
1.3modifypkgsrc/databases/postgresql10-client/Makefile
1.2modifypkgsrc/databases/postgresql10-docs/PLIST
1.2modifypkgsrc/databases/postgresql10-server/PLIST
1.33modifypkgsrc/databases/postgresql92/Makefile.common
1.26modifypkgsrc/databases/postgresql92/distinfo
1.4modifypkgsrc/databases/postgresql92/options.mk
1.11modifypkgsrc/databases/postgresql92-client/Makefile
1.24modifypkgsrc/databases/postgresql92-docs/PLIST
1.14modifypkgsrc/databases/postgresql92-server/PLIST
1.29modifypkgsrc/databases/postgresql93/Makefile.common
1.26modifypkgsrc/databases/postgresql93/distinfo
1.3modifypkgsrc/databases/postgresql93/options.mk
1.13modifypkgsrc/databases/postgresql93-client/Makefile
1.21modifypkgsrc/databases/postgresql93-docs/PLIST
1.12modifypkgsrc/databases/postgresql93-server/PLIST
1.21modifypkgsrc/databases/postgresql94/Makefile.common
1.18modifypkgsrc/databases/postgresql94/distinfo
1.2modifypkgsrc/databases/postgresql94/options.mk
1.7modifypkgsrc/databases/postgresql94-client/Makefile
1.6modifypkgsrc/databases/postgresql94-docs/Makefile
1.16modifypkgsrc/databases/postgresql94-docs/PLIST
1.9modifypkgsrc/databases/postgresql94-plperl/Makefile
1.9modifypkgsrc/databases/postgresql94-server/PLIST
1.14modifypkgsrc/databases/postgresql95/Makefile.common
1.11modifypkgsrc/databases/postgresql95/distinfo
1.2modifypkgsrc/databases/postgresql95/options.mk
1.7modifypkgsrc/databases/postgresql95-client/Makefile
1.10modifypkgsrc/databases/postgresql95-docs/PLIST
1.7modifypkgsrc/databases/postgresql95-server/PLIST
1.8modifypkgsrc/databases/postgresql96/Makefile.common
1.7modifypkgsrc/databases/postgresql96/distinfo
1.2modifypkgsrc/databases/postgresql96/options.mk
1.5modifypkgsrc/databases/postgresql96-client/Makefile
1.6modifypkgsrc/databases/postgresql96-docs/PLIST
1.4modifypkgsrc/databases/postgresql96-server/PLIST
1.2removepkgsrc/databases/postgresql94/patches/patch-src_timezone_strftime.c