search

ansible-collections / community.postgresql

Manage PostgreSQL with Ansible
https://galaxy.ansible.com/ui/repo/published/community/postgresql/
Other
100 stars 81 forks source link

publication creation does not support all tables in specific schemas #709

Closed commodis closed 4 days ago

commodis commented 3 weeks ago
SUMMARY

The current publication-module does not support the creation of a publication with all tables in specific schemas.

CREATE PUBLICATION sales_publication FOR TABLES IN SCHEMA marketing, sales;

https://www.postgresql.org/docs/current/sql-createpublication.html

ISSUE TYPE
COMPONENT NAME

community.postgresql.postgresql_publication

ADDITIONAL INFORMATION

Current link to the documentation https://docs.ansible.com/ansible/latest/collections/community/postgresql/postgresql_publication_module.html

Andersson007 commented 2 weeks ago

@commodis hello, thanks for reporting the issue! I'll put the help_wanted label on it hoping someone has time soon to take a look For newcomers, there's a quick start dev guide that can help. If anyone's gonna take a look, please put explicitly in a comment

Andersson007 commented 5 days ago

the pr https://github.com/ansible-collections/community.postgresql/pull/718 is ready for review