Jira Link: [DB-7785](https://yugabyte.atlassian.net/browse/DB-7785) ### Description Support DDL atomicity for all publication/replication slot commands in YSQL ### Warning: Please confirm that this issue does not contain any sensitive information - [X] I confirm this issue does not contain any sensitive information. [DB-7785]: https://yugabyte.atlassian.net/browse/DB-7785?atlOrigin=eyJpIjoiNWRkNTljNzYxNjVmNDY3MDlhMDU5Y2ZhYzA5YTRkZjUiLCJwIjoiZ2l0aHViLWNvbS1KU1cifQ
