Hi Shlok, I applied the latest v11 patch series and tested it on my setup. I verified the new EXCEPT support for both CREATE PUBLICATION and ALTER PUBLICATION with FOR ALL SEQUENCES. I tested single and multiple sequence exclusions, replacing and clearing exclusion lists, and checked the output using \dRp+. I also tried a number of edge cases, including non-existent sequences, temporary sequences, unlogged sequences, duplicate entries in the EXCEPT list, schema-qualified sequence names, and sequences with the same name in different schemas. All of these behaved as expected. In addition, I verified that pg_dump correctly preserves the EXCEPT (SEQUENCE...)clause and that psql tab completion suggests sequence names correctly for both CREATE PUBLICATION and ALTER PUBLICATION. Overall, the patch applied cleanly, built successfully, and all the test cases I tried worked as expected. I didn't notice any issues during testing.
Regards, solai
