Subject: CVS commit: pkgsrc/databases
From: Adam Ciarcinski
Date: 2022-08-15 22:59:40
Message id: 20220815205941.4B5CBFB1A@cvs.NetBSD.org

Log Message:
postgresql: updated to 14.5, 13.8, 12.12, 11.17, 10.22

This update fixes over 40 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 replay of CREATE DATABASE write-ahead log (WAL) records on standby servers \ 
when encountering a missing tablespace directory.
Add support for tablespaces that are plain directories instead of symbolic links \ 
to other directories.
Fix permission checks in CREATE INDEX to use the user's permissions. This fixes \ 
broken dump/restore scenarios that relied on the behavior prior to the fix for \ 
CVE-2022-1552.
In the extended query protocol, force an immediate commit after CREATE DATABASE \ 
and other commands that can't run in a transaction block.
Fix a race condition around checking transaction visibility that was more likely \ 
to happen when using synchronous replication.
Fix incorrect permission-checking code for extended statistics.
Fix extended statistics machinery to handle most common value (MCV)-type \ 
statistics on boolean-valued expressions.
Avoid planner core dump with constant = ANY(array) clauses when there are \ 
MCV-type extended statistics on the array variable.
Allow cancellation of ANALYZE while it is computing extended statistics.
Fix ALTER TABLE ... ENABLE/DISABLE TRIGGER to handle recursion for triggers on \ 
partitioned tables.
Reject ROW() expressions and functions in FROM that have more than 1600 columns.
Fix memory leak in logical replication subscribers.
Fix checks in logical replication of replica identity when the target table is \ 
partitioned.
Arrange to clean up after commit-time errors within SPI_commit(), rather than \ 
expecting callers to do that. This includes a fix for the same scenario in \ 
PL/Python, which had reported crashes on Python 3.11 and memory leaks on older \ 
versions of Python 3.
Improve handling in libpq of idle states in pipeline mode.
In the psql \watch command, echo a newline after cancellation with control-C.
Fix pg_upgrade to detect non-upgradable usages of functions accepting anyarray \ 
parameters.
Several postgres_fdw fixes, including prevention of batch insertions when there \ 
are WITH CHECK OPTION constraints present.

Files:
RevisionActionfile
1.33modifypkgsrc/databases/postgresql10/Makefile
1.35modifypkgsrc/databases/postgresql10/Makefile.common
1.28modifypkgsrc/databases/postgresql10/distinfo
1.28modifypkgsrc/databases/postgresql10-client/Makefile
1.26modifypkgsrc/databases/postgresql10-contrib/Makefile
1.19modifypkgsrc/databases/postgresql10-docs/Makefile
1.23modifypkgsrc/databases/postgresql10-docs/PLIST
1.22modifypkgsrc/databases/postgresql10-plperl/Makefile
1.27modifypkgsrc/databases/postgresql10-plpython/Makefile
1.23modifypkgsrc/databases/postgresql10-pltcl/Makefile
1.27modifypkgsrc/databases/postgresql10-server/Makefile
1.25modifypkgsrc/databases/postgresql11/Makefile
1.28modifypkgsrc/databases/postgresql11/Makefile.common
1.24modifypkgsrc/databases/postgresql11/distinfo
1.24modifypkgsrc/databases/postgresql11-client/Makefile
1.23modifypkgsrc/databases/postgresql11-contrib/Makefile
1.17modifypkgsrc/databases/postgresql11-docs/Makefile
1.18modifypkgsrc/databases/postgresql11-docs/PLIST
1.20modifypkgsrc/databases/postgresql11-plperl/Makefile
1.25modifypkgsrc/databases/postgresql11-plpython/Makefile
1.21modifypkgsrc/databases/postgresql11-pltcl/Makefile
1.24modifypkgsrc/databases/postgresql11-server/Makefile
1.6modifypkgsrc/databases/postgresql11-server/PLIST
1.24modifypkgsrc/databases/postgresql12/Makefile
1.21modifypkgsrc/databases/postgresql12/Makefile.common
1.17modifypkgsrc/databases/postgresql12/distinfo
1.26modifypkgsrc/databases/postgresql12-client/Makefile
1.7modifypkgsrc/databases/postgresql12-client/PLIST
1.23modifypkgsrc/databases/postgresql12-contrib/Makefile
1.17modifypkgsrc/databases/postgresql12-docs/Makefile
1.13modifypkgsrc/databases/postgresql12-docs/PLIST
1.20modifypkgsrc/databases/postgresql12-plperl/Makefile
1.23modifypkgsrc/databases/postgresql12-plpython/Makefile
1.21modifypkgsrc/databases/postgresql12-pltcl/Makefile
1.23modifypkgsrc/databases/postgresql12-server/Makefile
1.15modifypkgsrc/databases/postgresql13/Makefile
1.14modifypkgsrc/databases/postgresql13/Makefile.common
1.14modifypkgsrc/databases/postgresql13/distinfo
1.20modifypkgsrc/databases/postgresql13-client/Makefile
1.16modifypkgsrc/databases/postgresql13-contrib/Makefile
1.13modifypkgsrc/databases/postgresql13-docs/Makefile
1.9modifypkgsrc/databases/postgresql13-docs/PLIST
1.15modifypkgsrc/databases/postgresql13-plperl/Makefile
1.17modifypkgsrc/databases/postgresql13-plpython/Makefile
1.15modifypkgsrc/databases/postgresql13-pltcl/Makefile
1.15modifypkgsrc/databases/postgresql13-server/Makefile
1.10modifypkgsrc/databases/postgresql14/Makefile
1.7modifypkgsrc/databases/postgresql14/Makefile.common
1.8modifypkgsrc/databases/postgresql14/distinfo
1.10modifypkgsrc/databases/postgresql14-client/Makefile
1.8modifypkgsrc/databases/postgresql14-contrib/Makefile
1.8modifypkgsrc/databases/postgresql14-docs/Makefile
1.6modifypkgsrc/databases/postgresql14-docs/PLIST
1.8modifypkgsrc/databases/postgresql14-plperl/Makefile
1.9modifypkgsrc/databases/postgresql14-plpython/Makefile
1.8modifypkgsrc/databases/postgresql14-pltcl/Makefile
1.8modifypkgsrc/databases/postgresql14-server/Makefile
1.4modifypkgsrc/databases/postgresql14-server/PLIST