On 7/3/26 02:11, Amit Kapila wrote:
On Fri, Mar 6, 2026 at 6:25 PM Andrei Lepikhov <[email protected]> wrote: So, to summarize based on your and Dilip's inputs, the following syntax will be preferable to set/reset EXCEPT list: (a) To set a except table list to a different list than what is defined originally, we will use: "ALTER PUBLICATION pub1 SET ALL TABLES EXCEPT TABLE (t1, ..)" (b) To reset the entire except list, we will use "ALTER PUBLICATION pub1 SET ALL TABLES". Do let me know if I misunderstood your response?
Yes, that's correct. Variants a and b seem the clearest to me.
-- regards, Andrei Lepikhov, pgEdge
