PostgreSQL: Publication Testing and Docs Get a Cleanup

Two commits from Fujii Masao tighten up logical replication publications this cycle - one fixes documentation gaps for CREATE and ALTER PUBLICATION, the other repairs a test that wasn't actually testing what it claimed to test.

Duration: PT2M11S

Episode overview

This episode is a short developer briefing from PostgreSQL.

It explains recent repository work in plain language.

  • Show: PostgreSQL
  • Published: 2026-07-24T13:03:28Z
  • Audio duration: PT2M11S

Transcript excerpt

This excerpt keeps the crawler page concise. Listen to the episode or use the RSS feed for the full update.

Good day, and welcome to PostgreSQL for July 24th, 2026.

Today's activity is small but worth your attention if you work with logical replication - both changes circle around publications, one in documentation, one in test integrity.

First, the docs. Commit b77868f, authored by Peter Smith and reviewed by Fujii Masao, adds missing parameter descriptions for table name, column name, and schema name in the CREATE PUBLICATION and ALTER PUBLICATION reference pages. It also brings ALTER PUBLICATION's parameter list anchors in line with CREATE…

Second, and more interesting: commit c5f1f41 fixes a test bug in the EXCEPT publication tests. The original test, added back in commit fd366065e06, was meant to confirm that when you use multiple publications - one excluding a table with EXCEPT, another including it - the right rows get replicated to the subscriber.…

Put together, the theme here is quality control around publication features - making sure the behavior is both correctly documented and correctly tested, not just assumed to work.

What's next: if you maintain replication test suites, this is a good reminder to double-check which side of a publisher-subscriber setup your assertions…

Nearby episodes from PostgreSQL

  1. Version 19's Growing Pains
  2. Polish Pass on Messages and Edge Cases
  3. Cleaning Up After Recent Features
  4. Closing the Gaps Between Correctness and Convention
  5. Weekly Recap - Correctness Fixes and Late-Beta Caution
  6. Five Bug Fixes, One Pattern of Care in Correctness
  7. Late-Beta Cleanup and Correctness Fixes
  8. Silent Corruption, Loud Fixes