PostgreSQL: LIKE Pattern Matching Gets a Round of Bug Fixes
Three separate fixes landed for pattern matching and query planning correctness—two in nondeterministic collation handling for LIKE, and one restoring an indexscan optimization that affects psql's everyday "\d tablename" command. A handful of smaller correctness and cleanup commits round out the day.
Duration: PT2M41S
Episode overview
This episode is a short developer briefing from PostgreSQL.
It explains recent repository work in plain language.
- Show: PostgreSQL
- Published: 2026-07-07T13:04:08Z
- Audio duration: PT2M41S
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 July 7th, and today's PostgreSQL activity centers on pattern matching correctness, with three related fixes worth knowing about.
The headline theme is nondeterministic collation support for LIKE, which has needed repeated attention since it was introduced. Tom Lane fixed two distinct bugs here. In commit 42-b7-ff-3, a leading backslash in a pattern wasn't being handled correctly under nondeterministic locales, which could cause matching to go…
Related but distinct: commit 2d-78-08 from Tom Lane fixes a planner regression where LIKE or regex patterns with an exact-match form stopped being converted into an equality index lookup when collations didn't match exactly. This one has real performance stakes—Andres Freund flagged that without the fix, psql's…
A second theme: output correctness for large file offsets. Peter Eisentraut landed two cleanup commits, c22-d2-f7 and 04-fc-256, standardizing how off_t and pgoff_t values are printed and avoiding casts to 32-bit types that could silently truncate data. Mostly cosmetic today, but it sets better precedent for code…
A few standalone fixes are worth flagging. Amit Langote fixed a SQL/JSON bug where RETURNING clauses…
What'…
Nearby episodes from PostgreSQL
- Correctness Fixes for Query Planning and Cleanup
- Weekly Recap - Correctness Fixes Across Query Planning, Indexes, and Graph Features
- Cleanup Fixes for Catalog Integrity
- A Deep Cleanup of the GiST Index Internals
- Clearing the Deck for Version Twenty
- Test Infrastructure and Protocol Fixes
- Weekly Recap - Security and Stability Fixes
- Data Handling Corrections