Subject: CVS commit: pkgsrc
From: Adam Ciarcinski
Date: 2024-11-16 11:13:53
Message id: 20241116101353.C1084FC7D@cvs.NetBSD.org

Log Message:
postgresql: updated to 17.1, 16.5, 15.9, 14.14, 13.17

PostgreSQL 12 is now end-of-life.

Security Issues
* CVE-2024-10976: PostgreSQL row security below e.g. subqueries disregards user \ 
ID changes
* CVE-2024-10977: PostgreSQL libpq retains an error message from man-in-the-middle
* CVE-2024-10978: PostgreSQL SET ROLE, SET SESSION AUTHORIZATION reset to wrong \ 
user ID
* CVE-2024-10979: PostgreSQL PL/Perl environment variable changes execute \ 
arbitrary code

Bug Fixes and Improvements

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

Fix when attaching or detaching table partitions with foreign key constraints. \ 
After upgrade, users impacted by this issue will need to perform manual steps to \ 
finish fixing it. Please see the "Upgrading" section and the release \ 
notes for more information.
Fix when using libc as the default collation provider when LC_CTYPE is C while \ 
LC_COLLATE is a different locale. This could lead to incorrect query results. If \ 
you have these settings in your database, please reindex any affected indexes \ 
after updating to this release. This issue impacted 17.0 only.
Several query planner fixes, including disallowing joining partitions \ 
(partitionwise join) if the collations of the partitions don't match.
Fix possible wrong answers or wrong varnullingrels planner errors for MERGE ... \ 
WHEN NOT MATCHED BY SOURCE actions.
Fix validation of the COPY FORCE_NOT_NULL and FORCE_NULL.
Fix server crash when a json_objectagg() call contains a volatile function.
Ensure there's a registered dependency between a partitioned table and a \ 
non-built-in access method specified in CREATE TABLE ... USING. This fix only \ 
prevents problems for partitioned tables created after this update.
Fix race condition in committing a serializable transaction.
Fix race condition in COMMIT PREPARED that could require manual file removal \ 
after a crash-and-recovery.
Fix for pg_cursors view to prevent errors by excluding cursors that aren't \ 
completely set up.
Reduce logical decoding memory consumption.
Fix to prevent stable functions from receiving stale row values when they're \ 
called from a CALL statement's argument list and the CALL is within a PL/pgSQL \ 
EXCEPTION block.
Fix for JIT crashes on ARM (aarch64) systems.
The psql \watch now treats values that are less than 1ms to be 0 (no wait \ 
between executions).
Fix failure to use credentials for a replication user in the password file (pgpass)
pg_combinebackup now throws an error if an incremental backup file is present in \ 
a directory that should contain a full backup.
Fix to avoid reindexing temporary tables and indexes in vacuumdb and parallel \ 
reindexdb

Files:
RevisionActionfile
1.29modifypkgsrc/databases/postgresql13/Makefile
1.25modifypkgsrc/databases/postgresql13/Makefile.common
1.24modifypkgsrc/databases/postgresql13/distinfo
1.35modifypkgsrc/databases/postgresql13-client/Makefile
1.6modifypkgsrc/databases/postgresql13-client/PLIST
1.29modifypkgsrc/databases/postgresql13-contrib/Makefile
1.26modifypkgsrc/databases/postgresql13-docs/Makefile
1.18modifypkgsrc/databases/postgresql13-docs/PLIST
1.31modifypkgsrc/databases/postgresql13-plperl/Makefile
1.31modifypkgsrc/databases/postgresql13-plpython/Makefile
1.28modifypkgsrc/databases/postgresql13-pltcl/Makefile
1.28modifypkgsrc/databases/postgresql13-server/Makefile
1.24modifypkgsrc/databases/postgresql14/Makefile
1.17modifypkgsrc/databases/postgresql14/Makefile.common
1.17modifypkgsrc/databases/postgresql14/distinfo
1.25modifypkgsrc/databases/postgresql14-client/Makefile
1.4modifypkgsrc/databases/postgresql14-client/PLIST
1.21modifypkgsrc/databases/postgresql14-contrib/Makefile
1.21modifypkgsrc/databases/postgresql14-docs/Makefile
1.15modifypkgsrc/databases/postgresql14-docs/PLIST
1.24modifypkgsrc/databases/postgresql14-plperl/Makefile
1.23modifypkgsrc/databases/postgresql14-plpython/Makefile
1.21modifypkgsrc/databases/postgresql14-pltcl/Makefile
1.21modifypkgsrc/databases/postgresql14-server/Makefile
1.15modifypkgsrc/databases/postgresql15/Makefile
1.11modifypkgsrc/databases/postgresql15/Makefile.common
1.10modifypkgsrc/databases/postgresql15/distinfo
1.14modifypkgsrc/databases/postgresql15-client/Makefile
1.4modifypkgsrc/databases/postgresql15-client/PLIST
1.14modifypkgsrc/databases/postgresql15-contrib/Makefile
1.14modifypkgsrc/databases/postgresql15-docs/Makefile
1.10modifypkgsrc/databases/postgresql15-docs/PLIST
1.16modifypkgsrc/databases/postgresql15-plperl/Makefile
1.15modifypkgsrc/databases/postgresql15-plpython/Makefile
1.14modifypkgsrc/databases/postgresql15-pltcl/Makefile
1.14modifypkgsrc/databases/postgresql15-server/Makefile
1.10modifypkgsrc/databases/postgresql16/Makefile
1.8modifypkgsrc/databases/postgresql16/Makefile.common
1.7modifypkgsrc/databases/postgresql16/distinfo
1.11modifypkgsrc/databases/postgresql16-client/Makefile
1.3modifypkgsrc/databases/postgresql16-client/PLIST
1.10modifypkgsrc/databases/postgresql16-contrib/Makefile
1.10modifypkgsrc/databases/postgresql16-docs/Makefile
1.6modifypkgsrc/databases/postgresql16-docs/PLIST
1.10modifypkgsrc/databases/postgresql16-plperl/Makefile
1.10modifypkgsrc/databases/postgresql16-plpython/Makefile
1.10modifypkgsrc/databases/postgresql16-pltcl/Makefile
1.11modifypkgsrc/databases/postgresql16-server/Makefile
1.2modifypkgsrc/databases/postgresql16/patches/patch-src_pl_plperl_GNUmakefile
1.3modifypkgsrc/databases/postgresql17/Makefile
1.2modifypkgsrc/databases/postgresql17/Makefile.common
1.2modifypkgsrc/databases/postgresql17/distinfo
1.3modifypkgsrc/databases/postgresql17-client/Makefile
1.2modifypkgsrc/databases/postgresql17-client/PLIST
1.3modifypkgsrc/databases/postgresql17-contrib/Makefile
1.3modifypkgsrc/databases/postgresql17-docs/Makefile
1.2modifypkgsrc/databases/postgresql17-docs/PLIST
1.3modifypkgsrc/databases/postgresql17-plperl/Makefile
1.3modifypkgsrc/databases/postgresql17-plpython/Makefile
1.3modifypkgsrc/databases/postgresql17-pltcl/Makefile
1.4modifypkgsrc/databases/postgresql17-server/Makefile
1.2modifypkgsrc/databases/postgresql17/patches/patch-src_pl_plperl_GNUmakefile
1.1removepkgsrc/databases/postgresql12/DESCR
1.37removepkgsrc/databases/postgresql12/Makefile
1.31removepkgsrc/databases/postgresql12/Makefile.common
1.1removepkgsrc/databases/postgresql12/PLIST
1.25removepkgsrc/databases/postgresql12/distinfo
1.7removepkgsrc/databases/postgresql12/options.mk
1.1removepkgsrc/databases/postgresql12-client/DESCR
1.40removepkgsrc/databases/postgresql12-client/Makefile
1.8removepkgsrc/databases/postgresql12-client/PLIST
1.7removepkgsrc/databases/postgresql12-client/buildlink3.mk
1.1removepkgsrc/databases/postgresql12-contrib/DESCR
1.35removepkgsrc/databases/postgresql12-contrib/Makefile
1.2removepkgsrc/databases/postgresql12-contrib/PLIST
1.1removepkgsrc/databases/postgresql12-docs/DESCR
1.29removepkgsrc/databases/postgresql12-docs/Makefile
1.21removepkgsrc/databases/postgresql12-docs/PLIST
1.1removepkgsrc/databases/postgresql12-plperl/DESCR
1.35removepkgsrc/databases/postgresql12-plperl/Makefile
1.4removepkgsrc/databases/postgresql12-plperl/PLIST
1.1removepkgsrc/databases/postgresql12-plpython/DESCR
1.36removepkgsrc/databases/postgresql12-plpython/Makefile
1.3removepkgsrc/databases/postgresql12-plpython/PLIST
1.1removepkgsrc/databases/postgresql12-pltcl/DESCR
1.33removepkgsrc/databases/postgresql12-pltcl/Makefile
1.2removepkgsrc/databases/postgresql12-pltcl/PLIST
1.1removepkgsrc/databases/postgresql12-server/DEINSTALL
1.1removepkgsrc/databases/postgresql12-server/DESCR
1.35removepkgsrc/databases/postgresql12-server/Makefile
1.8removepkgsrc/databases/postgresql12-server/PLIST
1.3removepkgsrc/databases/postgresql12-server/files/pgsql.sh
1.1removepkgsrc/databases/postgresql12-server/files/smf/manifest.xml
1.1removepkgsrc/databases/postgresql12-server/files/smf/postgresql.sh
1.1removepkgsrc/databases/postgresql12/patches/patch-config_missing
1.1removepkgsrc/databases/postgresql12/patches/patch-config_perl.m4
1.1removepkgsrc/databases/postgresql12/patches/patch-configure
1.1removepkgsrc/databases/postgresql12/patches/patch-contrib_dblink_dblink.c
1.1removepkgsrc/databases/postgresql12/patches/patch-contrib_uuid-ossp_Makefile
1.1removepkgsrc/databases/postgresql12/patches/patch-src_Makefile.global.in
1.1removepkgsrc/databases/postgresql12/patches/patch-src_Makefile.shlib
1.2removepkgsrc/databases/postgresql12/patches/patch-src_backend_Makefile
1.1removepkgsrc/databases/postgresql12/patches/patch-src_interfaces_libpq_Makefile
1.1removepkgsrc/databases/postgresql12/patches/patch-src_makefiles_Makefile.solaris
1.1removepkgsrc/databases/postgresql12/patches/patch-src_pl_plperl_GNUmakefile