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
1
Webinar Series – SQL Server Indexing
Koen Verbeeck
•
1 votes
2
Risks and Limitations of AI in the Life Sciences
Jeremy Howard
•
1 votes
3
1M context is now generally available for Opus 4.6 and Sonnet 4.6
Simon Willison
•
1 votes
4
AI is my CMS
Chris Coyier
•
1 votes
5
When your coding agent doesn’t understand your project, you’ll get junk
Benjamin Cane
•
1 votes
6
LLM Use in the Python Source Code
Miguel Grinberg
•
1 votes