Path to this page:
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: