postgresql_privs should allow to set default privileges globally

[michaelkebe]

SUMMARY

postgresql_privs should allow to create global default privileges (without a schema) on a database.

ISSUE TYPE

• Feature Idea

COMPONENT NAME

postgresql_privs

ADDITIONAL INFORMATION

Currently it only possible to create default privileges with a schema (which defaults to public, if not set). The PostgreSQL documentation says:

The privileges can be set globally (i.e., for all objects created in the current database), or just for objects created in specified schemas.
(from https://www.postgresql.org/docs/current/sql-alterdefaultprivileges.html)

If the IN SCHEMA schema_name part is omitted, the created privileges is set globally.

[Andersson007]

@michaelkebe hello, thanks for reporting this! @tcraxs would you like to take a look?

[tcraxs]

@michaelkebe Thanks for pointing that out. It's true, the code just set schema = 'default', if there is no schema present in the ansible module call.
After a short look, it might not so easy to remove that part, as we rely on that default set in several other calls as well. I will have a look if that could be changed.