2.28.1
2.28.1 (2026-06-23)
Fixed 10
- Fix potential crash on DML on compressed tables when the plan uses Bitmap Heap Scan
- Fix column rename for compressed chunks
- Enforce CHECK, NOT NULL and view WITH CHECK OPTION constraints for direct compress inserts
- Fix error when using first/last aggregates in a HAVING clause
- Fix first/last optimization returning the same value for aggregates that share the value column but order by different columns
- Fix internal error in first/last for unsortable types
- Fix bgw_job_stat_history definition
- Fix uncompressed size estimate for varlen
- Fix deleting every row on compressed hypertable with subquery returning constant false
- Fix use-after-free in ALTER TABLE ADD CONSTRAINT
From TimescaleDB
This release contains performance improvements and bug fixes since the 2.28.0 release. We recommend that you upgrade at the next available opportunity.
Bugfixes
- #9913 Fix potential crash on
DMLon compressed tables when the plan usesBitmap Heap Scan - #10091 Fix column rename for compressed chunks
- #10056 Enforce
CHECK,NOT NULLand viewWITH CHECK OPTIONconstraints for direct compress inserts - #10059 Fix error when using
first/lastaggregates in aHAVINGclause - #10060 Fix
first/lastoptimization returning the same value for aggregates that share the value column but order by different columns - #10061 Fix internal error in
first/lastfor unsortable types - #10069 Fix
bgw_job_stat_historydefinition - #10073 Fix uncompressed size estimate for
varlen - #10089 Fix deleting every row on compressed hypertable with subquery returning constant false
- #10094 Fix use-after-free in
ALTER TABLE ADD CONSTRAINT
Thanks
- @skrenes for reporting a problem with the
job_historyview when upgrading to 2.28.0