head 1.3; access; symbols pkgsrc-2024Q3:1.2.0.26 pkgsrc-2024Q3-base:1.2 pkgsrc-2024Q2:1.2.0.24 pkgsrc-2024Q2-base:1.2 pkgsrc-2024Q1:1.2.0.22 pkgsrc-2024Q1-base:1.2 pkgsrc-2023Q4:1.2.0.20 pkgsrc-2023Q4-base:1.2 pkgsrc-2023Q3:1.2.0.18 pkgsrc-2023Q3-base:1.2 pkgsrc-2023Q2:1.2.0.16 pkgsrc-2023Q2-base:1.2 pkgsrc-2023Q1:1.2.0.14 pkgsrc-2023Q1-base:1.2 pkgsrc-2022Q4:1.2.0.12 pkgsrc-2022Q4-base:1.2 pkgsrc-2022Q3:1.2.0.10 pkgsrc-2022Q3-base:1.2 pkgsrc-2022Q2:1.2.0.8 pkgsrc-2022Q2-base:1.2 pkgsrc-2022Q1:1.2.0.6 pkgsrc-2022Q1-base:1.2 pkgsrc-2021Q4:1.2.0.4 pkgsrc-2021Q4-base:1.2 pkgsrc-2021Q3:1.2.0.2 pkgsrc-2021Q3-base:1.2 pkgsrc-2021Q2:1.1.0.14 pkgsrc-2021Q2-base:1.1 pkgsrc-2021Q1:1.1.0.12 pkgsrc-2021Q1-base:1.1 pkgsrc-2020Q4:1.1.0.10 pkgsrc-2020Q4-base:1.1 pkgsrc-2020Q3:1.1.0.8 pkgsrc-2020Q3-base:1.1 pkgsrc-2020Q2:1.1.0.6 pkgsrc-2020Q2-base:1.1 pkgsrc-2020Q1:1.1.0.2 pkgsrc-2020Q1-base:1.1 pkgsrc-2019Q4:1.1.0.4 pkgsrc-2019Q4-base:1.1; locks; strict; comment @# @; 1.3 date 2024.11.16.10.13.45; author adam; state dead; branches; next 1.2; commitid yMyTfQxO92xq8RxF; 1.2 date 2021.07.12.09.06.21; author mlelstv; state Exp; branches; next 1.1; commitid o9uoBqzvdsdP4G0D; 1.1 date 2019.10.07.19.21.48; author adam; state Exp; branches 1.1.14.1; next ; commitid wUS8rJP7kz3VaYFB; 1.1.14.1 date 2021.07.24.18.11.47; author bsiegert; state Exp; branches; next ; commitid uJKAB3YsTd3gIg2D; desc @@ 1.3 log @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 @ text @$NetBSD: patch-src_backend_Makefile,v 1.2 2021/07/12 09:06:21 mlelstv Exp $ --- src/backend/Makefile.orig 2018-10-15 21:12:02.000000000 +0000 +++ src/backend/Makefile @@@@ -17,6 +17,10 @@@@ subdir = src/backend top_builddir = ../.. include $(top_builddir)/src/Makefile.global +CFLAGS+= $(DL_CFLAGS) +LDFLAGS+= $(DL_LDFLAGS) +LIBS+= $(DL_LIBS) + SUBDIRS = access bootstrap catalog parser commands executor foreign lib libpq \ main nodes optimizer partitioning port postmaster \ regex replication rewrite \ @@@@ -113,6 +117,9 @@@@ endif # aix $(top_builddir)/src/port/libpgport_srv.a: | submake-libpgport +$(top_builddir)/src/common/libpgcommon_srv.a: | submake-libpgport +utils: | catalog + # The postgres.o target is needed by the rule in Makefile.global that # creates the exports file when MAKE_EXPORTS = true. @ 1.2 log @Add backends order dependency for catalog -> utils @ text @d1 1 a1 1 $NetBSD: patch-src_backend_Makefile,v 1.1 2019/10/07 19:21:48 adam Exp $ @ 1.1 log @postgresql12: added version 12.0 Release 12: General performance improvements, including: * Optimizations to space utilization and read/write performance for B-tree indexes * Partitioning performance enhancements, including improved query performance on tables with thousands of partitions, improved insertion performance with INSERT and COPY, and the ability to execute ALTER TABLE ATTACH PARTITION without blocking queries * Automatic (but overridable) inlining of common table expressions (CTEs) * Reduction of WAL overhead for creation of GiST, GIN, and SP-GiST indexes * Support for covering GiST indexes, via the INCLUDE clause * Multi-column most-common-value (MCV) statistics can be defined via CREATE STATISTICS, to support better plans for queries that test several non-uniformly-distributed columns Enhancements to administrative functionality, including: * REINDEX CONCURRENTLY can rebuild an index without blocking writes to its table * pg_checksums can enable/disable page checksums (used for detecting data corruption) in an offline cluster * Progress reporting statistics for CREATE INDEX, REINDEX, CLUSTER, VACUUM FULL, and pg_checksums Support for the SQL/JSON path language Stored generated columns Nondeterministic ICU collations, enabling case-insensitive and accent-insensitive grouping and ordering New authentication features, including: * Encryption of TCP/IP connections when using GSSAPI authentication * Discovery of LDAP servers using DNS SRV records * Multi-factor authentication, using the clientcert=verify-full option combined with an additional authentication method in pg_hba.conf @ text @d1 1 a1 1 $NetBSD: patch-src_backend_Makefile,v 1.1 2018/10/23 16:02:51 adam Exp $ d16 1 a16 1 @@@@ -113,6 +117,8 @@@@ endif # aix d21 1 @ 1.1.14.1 log @Pullup ticket #6491 - requested by nia databases/postgresql10: build fix databases/postgresql11: build fix databases/postgresql12: build fix databases/postgresql13: build fix Revisions pulled up: - databases/postgresql10/distinfo 1.21 - databases/postgresql10/patches/patch-src_backend_Makefile 1.2 - databases/postgresql11/distinfo 1.16 - databases/postgresql11/patches/patch-src_backend_Makefile 1.2 - databases/postgresql12/distinfo 1.10 - databases/postgresql12/patches/patch-src_backend_Makefile 1.2 - databases/postgresql13/distinfo 1.6 - databases/postgresql13/patches/patch-src_backend_Makefile 1.2 --- Module Name: pkgsrc Committed By: mlelstv Date: Mon Jul 12 09:06:22 UTC 2021 Modified Files: pkgsrc/databases/postgresql10: distinfo pkgsrc/databases/postgresql10/patches: patch-src_backend_Makefile pkgsrc/databases/postgresql11: distinfo pkgsrc/databases/postgresql11/patches: patch-src_backend_Makefile pkgsrc/databases/postgresql12: distinfo pkgsrc/databases/postgresql12/patches: patch-src_backend_Makefile pkgsrc/databases/postgresql13: distinfo pkgsrc/databases/postgresql13/patches: patch-src_backend_Makefile Log Message: Add backends order dependency for catalog -> utils @ text @d1 1 a1 1 $NetBSD$ d16 1 a16 1 @@@@ -113,6 +117,9 @@@@ endif # aix a20 1 +utils: | catalog @