PostgreSQL: JSON Revert and CI Overhaul
A change to JSON immutability checks is reverted due to upgrade breakage for indexes and generated columns, while file foreign table crashes, security docs, and JIT sanitizer fixes land alongside three CI modernization commits.
Duration: PT2M3S
Episode overview
This episode is a short developer briefing from PostgreSQL.
It explains recent repository work in plain language.
- Show: PostgreSQL
- Published: 2026-11-07T14:02:30Z
- Audio duration: PT2M3S
Transcript excerpt
This excerpt keeps the crawler page concise. Listen to the episode or use the RSS feed for the full update.
Hello, and welcome to your PostgreSQL briefing for November seventh, twenty twenty-six.
The top story is an upgrade risk around JSON handling, alongside a coordinated push to fix crashes and streamline testing.
First, the revert, in commit b58a9a9. Developers are rolling back a change that tightened immutability checks in the JSON and JSON-B conversion functions. The problem: any expression indexes, generated columns, or partition keys created under that behavior won't be automatically removed, but dump and restore and P G…
Second, reliability and security hardening. An analyze operation on a file-based foreign table, fixed in commit 72b9498, could hit an assertion or crash when input contained a default marker. The sampler wasn't providing an evaluation context for defaults, and that is now fixed, backpatched to version sixteen where…
Third, continuous integration. Three related changes, all backpatched to nineteen to keep it aligned with main after the Cirrus shutdown, move to smaller per-job containers to cut download time, switch Windows builds to a maintained setup action with caching, and allow runner types to be overridden for faster or…
What's next: audit any JSON-dependent…
Nearby episodes from PostgreSQL
- Silent Wrong-Result Fixes and Worker Reliability
- Composite Type Security Hardening
- Standby Inspection Guards and psql Interrupt Fix
- Weekly Recap - Reverts, Query Fixes, and Standby Safety
- Window Hangs, Planner Crashes and Replication Hardening
- Silent Correctness Fixes for Backups, Sorting and JSON
- Wrong-Result Fixes and Memory Hardening
- Backup Safety, Planner Correctness, and Maintenance Tuning