This release contains performance improvements and bug fixes since the 2.25.1 release and a fix for a security vulnerability (#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
#9276 Fix NULL and DEFAULT handling in uniqueness check on compressed chunks
#9277 Fix SSL-related build errors
#9279 Fix EXPLAIN VERBOSE corrupting targetlist of cached ModifyHypertable plans
#9281 Fix real-time continuous aggregates on UUID hypertables
#9283 Fix plan-time error when using enum in orderby compression setting
#9290 Propagate ALTER OWNER TO to policy jobs
#9292 Fix continuous aggregate column rename
#9293 Fix time_bucket_gapfill inside LATERAL subqueries
#9294 Fix DELETEand UPDATE with WHERE EXISTS on hypertables
#9303 Fix segfault in continuous aggregate creation on Postgres 18
#9308 Fix continuous aggregate offset/origin not applied in watermark and refresh window calculations
#9314 Fix generated columns always NULL in compressed chunks
#9321 Fix segfault when using OLD/NEW refs in RETURNING clause on Postgres 18
#9324 Potential violation of a foreign key constraint referencing a hypertable caused by concurrent DELETE of the key record
#9327 Fix handling of generated columns with NOT NULL domain type
#9331 Ensure search_path is set before anything else in SQL scripts
#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