Hubert (depesz) Lubaczewski • 3/26/2026

Waiting for PostgreSQL 19 – Add support for EXCEPT TABLE in ALTER PUBLICATION.

This article discusses a new feature in PostgreSQL 19 that extends ALTER PUBLICATION with EXCEPT TABLE support, allowing users to modify the exclusion list of tables or sequences in a publication. The patch, committed by Amit Kapila, introduces syntax to set ALL TABLES or ALL SEQUENCES with an optional EXCEPT TABLE clause, replacing existing exclusions. It covers usage examples, constraints (e.g., only root partitioned tables allowed), and behavior like resetting flags. The article is technical, focused on database development and PostgreSQL enhancements.

0 comments

#postgresql #SQL Syntax #Except Table