PostgreSQL: Weekly Recap - Reverts, Query Fixes, and Standby Safety
A quiet week by count with 30 commits centered on stabilization before version 19 RC2. Two major reverts paused risky changes while query correctness, standby safety, and OAuth docs tightened reliability.
Duration: PT3M1S
Episode overview
This episode is a short developer briefing from PostgreSQL.
It explains recent repository work in plain language.
- Show: PostgreSQL
- Published: 2026-11-09T09:10:51Z
- Audio duration: PT3M1S
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 weekly recap for November 2nd through November 9th, 2026.
0 pull request activity items, 30 additional commits this week.
The dominant pattern is caution before release, with two major reverts and a set of crash and correctness fixes that tighten upgrade paths, query results, and standby behavior.
First, reverts and upgrade action. Commit b58a9a9 reverts the change that made immutability checks in to JSON and to JSON-B complete. Any expression indexes, generated columns, or partition keys created under that reverted behavior are not automatically removed, but a dump and restore or P-G upgrade will now fail to…
Second, query correctness and crash fixes. Commit e d b e 7 f f fixes a crash with single-input aggregates that have multiple sort keys, where an order-by listing the same key with different operators could confuse datum sorting and distinct handling. Commit e405a46 fixes missing collation assignment in JSON table,…
Third, safer standbys and clearer security docs. Commits 0091c24 and 553262a block P-G stat tuple and page inspect functions from accessing temporary and unlogged relations during recovery, where standbys have no data. Instead…
Nearby episodes from PostgreSQL
- Stats, Planner and Replication Crash Fixes
- Silent Wrong-Result Fixes and Worker Reliability
- Composite Type Security Hardening
- Standby Inspection Guards and psql Interrupt Fix
- JSON Revert and CI Overhaul
- Window Hangs, Planner Crashes and Replication Hardening
- Silent Correctness Fixes for Backups, Sorting and JSON
- Wrong-Result Fixes and Memory Hardening