caseyandgina

I looked at the current code here and confirmed that it's not supported yet: https://github.com/ansible-collections/community.postgresql/blob/main/plugins/modules/postgresql_privs.py#L465 Also note that just above that, USAGE is duplicated in VALID_PRIVS.

> @caseyandgina thanks for reporting the issue! > Would you like to submit a PR? We have the [Quick start guide](https://docs.ansible.com/ansible/devel/community/create_pr_quick_start.html) if needed. Hi @Andersson007 - I am a DBA...

@Andersson007 This is related to https://github.com/ansible-collections/community.postgresql/issues/333 - Currently the "schema" option is defaulted to 'public', and there seems to be no way to not specify a schema which is another...

To be clear, when not restricting a default privilege to specific schema(s), the "in schema ____" should not be present in the SQL.

@Andersson007 I'm sorry but I really don't know how to test as I'm not a developer. I'll need some guidance on how to do this. I have been meaning to...

Per the current documentation, it is defaulted to 'public' for `default_privs`. There isn't any mention of an option for any schema. https://docs.ansible.com/ansible/latest/collections/community/postgresql/postgresql_privs_module.html

Downgrading from r179 to r178 fixes the tab UI issue, however the default order is still incorrect, and has been for as long as I can remember. I've just been...

It's interesting that two of the parts (001 and 1666) happen at very different places in the output than expected. Also curious that the order of files seems to be...

I have no desire for the password to be logged, and would hope that Patroni would not put it into the call itself as then it could be exposed via...

I do set postgresql.bindir, but I did not think to include that when attempting to replicate manually at first. Another good reason for having the entire generated command logged. I...