Subject: CVS commit: pkgsrc/databases
From: Adam Ciarcinski
Date: 2018-05-13 10:13:47
Message id: 20180513081347.802BAFBEC@cvs.NetBSD.org

Log Message:
postgresql: updated to 10.4, 9.6.9, 9.5.13, 9.4.18, 9.3.23

SECURITY ISSUES
One security vulnerability has been closed by this release:

CVE-2018-1115: Too-permissive access control list on function pg_logfile_rotate()
Please see the "Updating" section below for post-update steps.

BUG FIXES AND IMPROVEMENTS
This update also fixes over 50 bugs reported in the last several months. Some of \ 
these issues affect only version 10, but many affect all supported versions.

These fixes include:
Fix incorrect volatility and parallel-safety markings on several built-in \ 
functions to ensure correct query planning optimizations
Several fixes for partitioning, including potential crashes as well as allowing \ 
TRUE and FALSE to be used as partition bounds
Fix where a new TOAST value could be assigned to a dead-but-not-yet-vacuumed \ 
TOAST OID, which would result in an error similar to "unexpected chunk \ 
number 0 (expected 1) for toast value nnnnn"
Fix "CREATE TABLE ... LIKE" with bigint identity columns on 32-bit \ 
platforms
Fix memory leak within the runtime of a query that repeatedly executes hash joins
Several crash fixes around queries using GROUPING SET
Avoid failure if a query-cancel or session-termination interrupt occurs while \ 
committing a prepared transaction
Reduce locking during autovacuum worker scheduling, which prevents loss of \ 
potential worker concurrency
Fix possible slow execution of REFRESH MATERIALIZED VIEW CONCURRENTLY
Several fixes around query plans that use "index-only" scans
Avoid deadlocks in concurrent CREATE INDEX CONCURRENTLY commands that are run \ 
under SERIALIZABLE or REPEATABLE READ transaction isolation
Several fixes for SP-GiST indexes, including one collation-aware searches on \ 
text columns
Fixes related to counting the number of tuples in partial GiST, SP-GiST, and \ 
Bloom indexes
Several fixes for logical decoding and replication
Fix misquoting of values for list-valued GUC variables (e.g. \ 
local_preload_libraries, session_preload_libraries, shared_preload_libraries, \ 
temp_tablespaces) in dumps
Several fixes for pg_stat_activity
Several fixes for ecpg
Fix for pg_recvlogical to ensure compatibility with PostgreSQL versions released \ 
before 10
Several fixes for pg_rewind

Files:
RevisionActionfile
1.9modifypkgsrc/databases/postgresql96-docs/PLIST
1.3modifypkgsrc/databases/postgresql96-contrib/PLIST
1.11modifypkgsrc/databases/postgresql96/distinfo
1.14modifypkgsrc/databases/postgresql96/Makefile.common
1.13modifypkgsrc/databases/postgresql95-docs/PLIST
1.15modifypkgsrc/databases/postgresql95/distinfo
1.20modifypkgsrc/databases/postgresql95/Makefile.common
1.20modifypkgsrc/databases/postgresql94-docs/PLIST
1.22modifypkgsrc/databases/postgresql94/distinfo
1.26modifypkgsrc/databases/postgresql94/Makefile.common
1.25modifypkgsrc/databases/postgresql93-docs/PLIST
1.30modifypkgsrc/databases/postgresql93/distinfo
1.34modifypkgsrc/databases/postgresql93/Makefile.common
1.5modifypkgsrc/databases/postgresql10-docs/PLIST
1.2modifypkgsrc/databases/postgresql10-contrib/PLIST
1.6modifypkgsrc/databases/postgresql10/distinfo
1.8modifypkgsrc/databases/postgresql10/Makefile.common