Subject: CVS commit: pkgsrc/databases
From: Adam Ciarcinski
Date: 2022-02-11 09:31:25
Message id: 20220211083125.B2258FB24@cvs.NetBSD.org

Log Message:
postgresql1N: updated to 14.2, 13.6, 12.10, 11.15, and 10.20

PostgreSQL 14.2, 13.6, 12.10, 11.15, and 10.20 Released!

This update fixes over 55 bugs that were reported in the last several months. \ 
The issues listed below affect PostgreSQL 14. Some of these issues may also \ 
affect other supported versions of PostgreSQL.

Included in this release:

Fix for a low probability scenario of index corruption when a HOT (heap-only \ 
tuple) chain changes state during VACUUM. Encountering this issue is unlikely, \ 
but if you are concerned, please consider reindexing.
Fix for using REINDEX CONCURRENTLY on TOAST table indexes to prevent corruption. \ 
You can fix any TOAST indexes by reindexing them again.
The psql \password command now defaults to setting the password for the role \ 
defined by CURRENT_USER. Additionally, the role name is now included in the \ 
password prompt.
Build extended statistics for partitioned tables. If you previously added \ 
extended statistics to a partitioned table, you should run ANALYZE on those \ 
tables. As autovacuum currently does not process partitioned tables, you must \ 
periodically run ANALYZE on any partitioned tables to update their statistics.
Fix crash with ALTER STATISTICS when the statistics object is dropped concurrently.
Fix crash with multiranges when extracting variable-length data types.
Several fixes to the query planner that lead to incorrect query results.
Several fixes for query plan memoization.
Fix startup of a physical replica to tolerate transaction ID wraparound.
When using logical replication, avoid duplicate transmission of a partitioned \ 
table's data when the publication includes both the child and parent tables.
Disallow altering data type of a partitioned table's columns when the \ 
partitioned table's row type is used as a composite type elsewhere.
Disallow ALTER TABLE ... DROP NOT NULL for a column that is part of a replica \ 
identity index.
Several fixes for caching that correct logical replication behavior and improve \ 
performance.
Fix memory leak when updating expression indexes.
Avoid leaking memory during REASSIGN OWNED BY operations that reassign ownership \ 
of many objects.
Fix display of whole-row variables appearing in INSERT ... VALUES rules.
Fix race condition that could lead to failure to localize error messages that \ 
are reported early in multi-threaded use of libpq or ecpglib.
Fix psql \d command for identifying parent triggers.
Fix failures on Windows when using the terminal as data source or destination. \ 
This affected the psql \copy command and using pg_recvlogical with -f -.
Fix the pg_dump --inserts and --column-inserts modes to handle tables that \ 
contain both generated and dropped columns.
Fix edge cases in how postgres_fdw handles asynchronous queries. These errors \ 
could lead to crashes or incorrect results when attempting to run parallel scans \ 
of foreign tables.
For the full list of changes available, please review the release notes.

Files:
RevisionActionfile
1.3modifypkgsrc/databases/postgresql14-server/Makefile
1.3modifypkgsrc/databases/postgresql14-pltcl/Makefile
1.3modifypkgsrc/databases/postgresql14-plpython/Makefile
1.3modifypkgsrc/databases/postgresql14-plperl/Makefile
1.3modifypkgsrc/databases/postgresql14-docs/PLIST
1.3modifypkgsrc/databases/postgresql14-docs/Makefile
1.3modifypkgsrc/databases/postgresql14-contrib/Makefile
1.3modifypkgsrc/databases/postgresql14-client/PLIST
1.3modifypkgsrc/databases/postgresql14-client/Makefile
1.5modifypkgsrc/databases/postgresql14/distinfo
1.3modifypkgsrc/databases/postgresql14/Makefile.common
1.5modifypkgsrc/databases/postgresql14/Makefile
1.11modifypkgsrc/databases/postgresql13-server/Makefile
1.11modifypkgsrc/databases/postgresql13-pltcl/Makefile
1.12modifypkgsrc/databases/postgresql13-plpython/Makefile
1.11modifypkgsrc/databases/postgresql13-plperl/Makefile
1.7modifypkgsrc/databases/postgresql13-docs/PLIST
1.9modifypkgsrc/databases/postgresql13-docs/Makefile
1.12modifypkgsrc/databases/postgresql13-contrib/Makefile
1.12modifypkgsrc/databases/postgresql13-client/Makefile
1.12modifypkgsrc/databases/postgresql13/distinfo
1.11modifypkgsrc/databases/postgresql13/Makefile.common
1.11modifypkgsrc/databases/postgresql13/Makefile
1.19modifypkgsrc/databases/postgresql12-server/Makefile
1.17modifypkgsrc/databases/postgresql12-pltcl/Makefile
1.18modifypkgsrc/databases/postgresql12-plpython/Makefile
1.16modifypkgsrc/databases/postgresql12-plperl/Makefile
1.11modifypkgsrc/databases/postgresql12-docs/PLIST
1.13modifypkgsrc/databases/postgresql12-docs/Makefile
1.19modifypkgsrc/databases/postgresql12-contrib/Makefile
1.20modifypkgsrc/databases/postgresql12-client/Makefile
1.15modifypkgsrc/databases/postgresql12/distinfo
1.18modifypkgsrc/databases/postgresql12/Makefile.common
1.20modifypkgsrc/databases/postgresql12/Makefile
1.20modifypkgsrc/databases/postgresql11-server/Makefile
1.17modifypkgsrc/databases/postgresql11-pltcl/Makefile
1.20modifypkgsrc/databases/postgresql11-plpython/Makefile
1.16modifypkgsrc/databases/postgresql11-plperl/Makefile
1.16modifypkgsrc/databases/postgresql11-docs/PLIST
1.13modifypkgsrc/databases/postgresql11-docs/Makefile
1.19modifypkgsrc/databases/postgresql11-contrib/Makefile
1.18modifypkgsrc/databases/postgresql11-client/Makefile
1.21modifypkgsrc/databases/postgresql11/distinfo
1.25modifypkgsrc/databases/postgresql11/Makefile.common
1.21modifypkgsrc/databases/postgresql11/Makefile
1.23modifypkgsrc/databases/postgresql10-server/Makefile
1.19modifypkgsrc/databases/postgresql10-pltcl/Makefile
1.22modifypkgsrc/databases/postgresql10-plpython/Makefile
1.18modifypkgsrc/databases/postgresql10-plperl/Makefile
1.21modifypkgsrc/databases/postgresql10-docs/PLIST
1.15modifypkgsrc/databases/postgresql10-docs/Makefile
1.22modifypkgsrc/databases/postgresql10-contrib/Makefile
1.22modifypkgsrc/databases/postgresql10-client/Makefile
1.26modifypkgsrc/databases/postgresql10/distinfo
1.32modifypkgsrc/databases/postgresql10/Makefile.common
1.29modifypkgsrc/databases/postgresql10/Makefile