TimescaleDB Files

This release contains performance improvements and bug fixes since the 2.25.1 release and a fix for a security vulnerability (https://github.com/timescale/timescaledb/pull/9331). You can check the security advisory for more information on the vulnerability and the platforms that are affected. We recommend that you upgrade as soon as possible.

Bugfixes

https://github.com/timescale/timescaledb/pull/9276 Fix NULL and DEFAULT handling in uniqueness check on compressed chunks https://github.com/timescale/timescaledb/pull/9277 Fix SSL-related build errors https://github.com/timescale/timescaledb/pull/9279 Fix EXPLAIN VERBOSE corrupting targetlist of cached ModifyHypertable plans https://github.com/timescale/timescaledb/pull/9281 Fix real-time continuous aggregates on UUID hypertables https://github.com/timescale/timescaledb/pull/9283 Fix plan-time error when using enum in orderby compression setting https://github.com/timescale/timescaledb/pull/9290 Propagate ALTER <object> OWNER TO to policy jobs https://github.com/timescale/timescaledb/pull/9292 Fix continuous aggregate column rename https://github.com/timescale/timescaledb/pull/9293 Fix time_bucket_gapfill inside LATERAL subqueries https://github.com/timescale/timescaledb/pull/9294 Fix DELETEand UPDATE with WHERE EXISTS on hypertables https://github.com/timescale/timescaledb/pull/9303 Fix segfault in continuous aggregate creation on Postgres 18 https://github.com/timescale/timescaledb/pull/9308 Fix continuous aggregate offset/origin not applied in watermark and refresh window calculations https://github.com/timescale/timescaledb/pull/9314 Fix generated columns always NULL in compressed chunks https://github.com/timescale/timescaledb/pull/9321 Fix segfault when using OLD/NEW refs in RETURNING clause on Postgres 18 https://github.com/timescale/timescaledb/pull/9324 Potential violation of a foreign key constraint referencing a hypertable caused by concurrent DELETE of the key record https://github.com/timescale/timescaledb/pull/9327 Fix handling of generated columns with NOT NULL domain type https://github.com/timescale/timescaledb/pull/9331 Ensure search_path is set before anything else in SQL scripts https://github.com/timescale/timescaledb/pull/9339 Fix segmentwise recompression clearing unordered flag

Thanks

@CaptainCuddleCube for reporting an issue with time_bucket_gapfill and LATERAL subqueries @JacobBrejnbjerg for reporting an issue with generated columns in compressed chunks @Kusumoto for reporting an issue with continuous aggregates on hypertables with UUID columns @arfathyahiya for reporting an issue with renaming columns in continuous aggregates @desertmark for reporting an issue with DELETE/UPDATE and subqueries @flaviofernandes004 for reporting an issue with RETURNING clause and references to OLD/NEW @tureba for fixing SSL-related build errors