PostgreSQL: I/O Return Types and JSON_TABLE Cleanup
Peter Eisentraut led a sweep to fix inconsistent handling of read, write, and secure I/O return types across core code, while Alexander Korotkov and others closed out a cluster of JSON_TABLE correctness bugs found by Thom Brown's testing.
Duration: PT2M44S
Episode overview
This episode is a short developer briefing from PostgreSQL.
It explains recent repository work in plain language.
- Show: PostgreSQL
- Published: 2026-07-15T13:03:41Z
- Audio duration: PT2M44S
Transcript excerpt
This excerpt keeps the crawler page concise. Listen to the episode or use the RSS feed for the full update.
This is PostgreSQL, your development briefing for July 15, 2026.
Today's activity centers on two threads: quiet but important type-correctness fixes to I/O handling, and a cleanup of JSON_TABLE edge cases.
Start with the I/O work. Peter Eisentraut landed three related commits - ca326e9, 1f8c504, and 7d45a6d - all addressing the same root issue: read, write, and secure read and write calls return a signed size type, not a plain integer, and several callers across the codebase weren't respecting that. This matters…
Second theme: JSON_TABLE correctness. Alexander Korotkov fixed three separate issues reported by Thom Brown from the same discussion thread. Commit af6fad8 reverts a recent change that made table-level ON ERROR cascade into column-level errors - correct per SQL standard, but judged too risky to ship without separate…
A smaller but related thread: Michael Paquier reworked and then partly reverted changes to how stats files are written, in commit 572c3b2 and 381b3cf, aiming for symmetric, predictable error handling between reads and writes without exposing a half-finished public API during beta.
Also worth noting: Richard Guo fixed a planner assertion failure tied to stale…
Nearby episodes from PostgreSQL
- Five Bug Fixes, One Pattern of Care in Correctness
- Late-Beta Cleanup and Correctness Fixes
- Silent Corruption, Loud Fixes
- Visibility Map Bug Fixed, Old Baggage Dropped
- Cleaning Up the Codebase's Foundations
- Tightening File System Type Safety
- Weekly Recap - Code Hygiene and Quiet Bug Fixes
- Hardening the Data Checksum Rollout