PostgreSQL: Cross-Version Upgrade Test Fix
A targeted fix addresses test failures in PostgreSQL's cross-version upgrade process, specifically handling differences in how the seg extension's output function behaves between older and newer releases.
Duration: PT2M1S
Episode overview
This episode is a short developer briefing from PostgreSQL.
It explains recent repository work in plain language.
- Show: PostgreSQL
- Published: 2026-06-13T13:04:04Z
- Audio duration: PT2M1S
Transcript excerpt
This excerpt keeps the crawler page concise. Listen to the episode or use the RSS feed for the full update.
Good morning, it's June 13th, 2026, and this is your PostgreSQL developer briefing.
Today's activity centers on a maintenance fix that resolves a specific but important issue in PostgreSQL's upgrade testing infrastructure.
The primary change comes from commit 3e3d787, where Andrew Dunstan addressed a cross-version upgrade test problem related to the seg extension. The issue stems from a previous fix to the seg_out function that taught it to print certainty indicators on interval upper boundaries. However, this improvement was only…
This created a testing problem: when upgrading from older PostgreSQL releases, the pre-upgrade and post-upgrade database dumps wouldn't match. The older server would output a test row as '4.6 .. ~7.0' without the certainty indicator, while the newer version would include it. The solution adjusts the upgrade test…
What makes this change significant is that it's being back-patched to all supported branches, indicating the importance of maintaining reliable upgrade testing across the entire supported version range. The fix was prompted by buildfarm failures on the crake and fairywren systems, showing how PostgreSQL's continuous…
For developers, this…