CVS commit: pkgsrc/databases/postgresql-timescaledb

["Adam Ciarcinski" <adam%netbsd.org@localhost>]

Module Name:    pkgsrc
Committed By:   adam
Date:           Wed Aug  2 06:38:30 UTC 2023

Modified Files:
        pkgsrc/databases/postgresql-timescaledb: Makefile PLIST distinfo

Log Message:
postgresql-timescaledb: updated to 2.11.1

2.11.1 (2023-06-29)

This release contains bug fixes since the 2.11.0 release.
We recommend that you upgrade at the next available opportunity.

**Features**
* Update the loader to add support for the OSM extension (used for data tiering on [Timescale](https://www.timescale.com/))

**Bugfixes**
* Scheduler accidentally getting killed when calling `delete_job`
* Fix Result node handling with ConstraintAwareAppend on compressed chunks
* Ensure tlist is present in decompress chunk plan
* Fixed handling of NULL values in bookend_sfunc
* Fixed batch look ahead in compressed sorted merge
* Mark cagg_watermark function as PARALLEL RESTRICTED
* Copy job config JSONB structure into current MemoryContext
* Improve continuous aggregate query chunk exclusion

2.11.0 (2023-05-12)

This release contains new features and bug fixes since the 2.10.3 release.
We deem it moderate priority for upgrading.

This release includes these noteworthy features:
* Support for DML operations on compressed chunks:
  * UPDATE/DELETE support
  * Support for unique constraints on compressed chunks
  * Support for `ON CONFLICT DO UPDATE`
  * Support for `ON CONFLICT DO NOTHING`
* Join support for Hierarchical Continuous Aggregates
* Performance improvements for real-time Hierarchical Continuous Aggregates

**Features**
* Allow pushdown of reference table joins
* Improve Realtime Continuous Aggregate performance
* Improve unique constraint support on compressed hypertables
* Support UPDATE/DELETE on compressed hypertables
* Enable JOINS for Hierarchical Continuous Aggregates
* Add parallel support for partialize_agg()
* Refactor and optimize distributed COPY
* Add support for ON CONFLICT DO UPDATE for compressed hypertables
* Skip Ordered Append when only 1 child node is present
* Propagate vacuum/analyze to compressed chunks
* Reduce decompression during constraint checking
* Optimize compressed chunk resorting
* Support sending telemetry event reports

**Bugfixes**
* Fix SEGMENTBY columns predicates to be pushed down
* Handle user-defined FDW options properly
* Decompression may have lost DEFAULT values
* Fix issue creating dimensional constraints
* Improve interpolate error message on datatype mismatch
* Fix unique constraint on compressed tables
* Add permission checks to run_job()
* Enable run_job() for telemetry job
* Fix on-insert decompression after schema changes
* Quote username identifier appropriately
* Fix tablespace for compressed hypertable and corresponding toast
* Fix ALTER TABLE SET with normal tables
* Reduce memory usage for distributed analyze
* Fix subtransaction resource owner


To generate a diff of this commit:
cvs rdiff -u -r1.20 -r1.21 pkgsrc/databases/postgresql-timescaledb/Makefile
cvs rdiff -u -r1.17 -r1.18 pkgsrc/databases/postgresql-timescaledb/PLIST
cvs rdiff -u -r1.19 -r1.20 pkgsrc/databases/postgresql-timescaledb/distinfo

Please note that diffs are not public domain; they are subject to the
copyright notices on the relevant files.

Modified files:

Index: pkgsrc/databases/postgresql-timescaledb/Makefile
diff -u pkgsrc/databases/postgresql-timescaledb/Makefile:1.20 pkgsrc/databases/postgresql-timescaledb/Makefile:1.21
--- pkgsrc/databases/postgresql-timescaledb/Makefile:1.20       Fri Apr 28 07:34:42 2023
+++ pkgsrc/databases/postgresql-timescaledb/Makefile    Wed Aug  2 06:38:30 2023
@@ -1,6 +1,6 @@
-# $NetBSD: Makefile,v 1.20 2023/04/28 07:34:42 adam Exp $
+# $NetBSD: Makefile,v 1.21 2023/08/02 06:38:30 adam Exp $
 
-DISTNAME=      timescaledb-2.10.3
+DISTNAME=      timescaledb-2.11.1
 PKGNAME=       postgresql${PGSQL_VERSION}-${DISTNAME}
 CATEGORIES=    databases
 MASTER_SITES=  ${MASTER_SITE_GITHUB:=timescale/}
@@ -13,7 +13,6 @@ LICENSE=      apache-2.0
 
 DEPENDS+=      postgresql${PGSQL_VERSION}-server>=0:../../databases/postgresql${PGSQL_VERSION}-server
 
-USE_CMAKE=     yes
 CMAKE_ARGS+=   -DUSE_OPENSSL=ON
 CMAKE_ARGS+=   -DREGRESS_CHECKS=OFF
 
@@ -39,5 +38,6 @@ PLIST.tsl=            yes
 CMAKE_ARGS+=           -DAPACHE_ONLY=ON
 .endif
 
+.include "../../devel/cmake/build.mk"
 .include "../../mk/pgsql.buildlink3.mk"
 .include "../../mk/bsd.pkg.mk"

Index: pkgsrc/databases/postgresql-timescaledb/PLIST
diff -u pkgsrc/databases/postgresql-timescaledb/PLIST:1.17 pkgsrc/databases/postgresql-timescaledb/PLIST:1.18
--- pkgsrc/databases/postgresql-timescaledb/PLIST:1.17  Fri Apr 28 07:34:42 2023
+++ pkgsrc/databases/postgresql-timescaledb/PLIST       Wed Aug  2 06:38:30 2023
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.17 2023/04/28 07:34:42 adam Exp $
+@comment $NetBSD: PLIST,v 1.18 2023/08/02 06:38:30 adam Exp $
 lib/postgresql/timescaledb-${PKGVERSION}.so
 ${PLIST.tsl}lib/postgresql/timescaledb-tsl-${PKGVERSION}.so
 lib/postgresql/timescaledb.so
@@ -21,6 +21,8 @@ share/postgresql/extension/timescaledb--
 share/postgresql/extension/timescaledb--2.10.0--${PKGVERSION}.sql
 share/postgresql/extension/timescaledb--2.10.1--${PKGVERSION}.sql
 share/postgresql/extension/timescaledb--2.10.2--${PKGVERSION}.sql
+share/postgresql/extension/timescaledb--2.10.3--${PKGVERSION}.sql
+share/postgresql/extension/timescaledb--2.11.0--${PKGVERSION}.sql
 share/postgresql/extension/timescaledb--2.2.0--${PKGVERSION}.sql
 share/postgresql/extension/timescaledb--2.2.1--${PKGVERSION}.sql
 share/postgresql/extension/timescaledb--2.3.0--${PKGVERSION}.sql

Index: pkgsrc/databases/postgresql-timescaledb/distinfo
diff -u pkgsrc/databases/postgresql-timescaledb/distinfo:1.19 pkgsrc/databases/postgresql-timescaledb/distinfo:1.20
--- pkgsrc/databases/postgresql-timescaledb/distinfo:1.19       Fri Apr 28 07:34:42 2023
+++ pkgsrc/databases/postgresql-timescaledb/distinfo    Wed Aug  2 06:38:30 2023
@@ -1,5 +1,5 @@
-$NetBSD: distinfo,v 1.19 2023/04/28 07:34:42 adam Exp $
+$NetBSD: distinfo,v 1.20 2023/08/02 06:38:30 adam Exp $
 
-BLAKE2s (timescaledb-2.10.3.tar.gz) = a027a042f14afc3da02a4ff87baaaee3b82f3677ed30ecb343cab6a6ff2a16e5
-SHA512 (timescaledb-2.10.3.tar.gz) = c94227d9aa1df36634bbf2626f580165860cab543efbfeb448f9799cf70ef6c1891af0077c2280ae22dbfb2360cf2b6012e7f05c26b0cf7aef6eb217c583b444
-Size (timescaledb-2.10.3.tar.gz) = 7465897 bytes
+BLAKE2s (timescaledb-2.11.1.tar.gz) = 745bd5dbb6908e7f91dfef195a203eb9799b6810fecba27fe781e72b52e7a64c
+SHA512 (timescaledb-2.11.1.tar.gz) = e29a378bfe1e5bb72d6d9bd430b972d1e14cf2345f2599559f73075146fd8c5839f08459880681140eff607b152671beeb1876bf509008ad2b653d258eb356b8
+Size (timescaledb-2.11.1.tar.gz) = 7723360 bytes