PostgreSQL: Repack Decoding Bugs and a Schema Feature Retreat
Two logical decoding crashes tied to REPACK CONCURRENTLY were fixed and backpatched to version 19, while the team reverted a set of CREATE SCHEMA feature changes after compatibility concerns outweighed the benefits. Several smaller fixes address long-standing bugs in option parsing and compiler warnings.
Duration: PT2M26S
Episode overview
This episode is a short developer briefing from PostgreSQL.
It explains recent repository work in plain language.
- Show: PostgreSQL
- Published: 2026-09-12T13:03:50Z
- Audio duration: PT2M26S
Transcript excerpt
This excerpt keeps the crawler page concise. Listen to the episode or use the RSS feed for the full update.
Good day. It's September 12, 2026, and this is your PostgreSQL briefing.
The top story today is a pair of logical decoding fixes that trace back to REPACK CONCURRENTLY, the online table rewrite feature introduced in version 19. Masahiko Sawada fixed a crash in commit 7164dcb, where heap update was suppressing logical changes for the main tuple but not for TOAST data, causing decoding to…
The second theme is a retreat on CREATE SCHEMA. Tom Lane reverted two related commits, 962e0a7 and f192043, that had changed how subcommands inside CREATE SCHEMA are ordered and expanded the set of object types allowed there. The concern was compatibility breakage outweighing the functionality gain. Notably, the…
A few smaller but practical fixes rounded out the batch. Nathan Bossart fixed two bugs in the in-tree getopt long implementation: one where a missing option argument could silently grab the wrong value, and another, over two decades old, where optional arguments could cause the parser to skip the next argument…
What's next: expect the REPACK decoding fixes to ship in the next minor releases across supported versions, and keep an eye out if you were testing the expanded CREATE SCHEMA syntax,…
T…
Nearby episodes from PostgreSQL
- Correctness Fixes Around Concurrency and Replication
- Correctness Fixes in the Query Planner and Foreign Keys
- Repack Command Gets Locked Down
- A Big Revert and a Round of Correctness Fixes
- Correctness Fixes Land Ahead of Version 19
- Weekly Recap - Query Planner Correctness & Concurrency Cleanup
- Trading Spinlocks for Atomics
- Ground Truth for Query Plans and Table Scans