Waiting for PostgreSQL 19 – Allow table exclusions in publications via EXCEPT TABLE.
Read OriginalThe article details a new feature committed for PostgreSQL 19 that extends the 'FOR ALL TABLES' publication syntax to support 'EXCEPT TABLE'. This allows database administrators to logically replicate all tables in a database while explicitly excluding specific ones, with exclusions applying to entire partitioned table hierarchies. The patch introduces a new 'preexcept' column in the system catalog and is a foundational step before ALTER PUBLICATION support for managing these exclusions.
Comments
No comments yet
Be the first to share your thoughts!
Browser Extension
Get instant access to AllDevBlogs from your browser
Top of the Week
No top articles yet