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
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