automation: Update community.postgresql to version 3.7.0

This MR contains the following updates:

Package	Type	Update	Change
community.postgresql	galaxy-collection	minor	3.4.1 -> 3.7.0

---

Release Notes

ansible-collections/community.postgresql (community.postgresql)

v3.7.0

Compare Source

======

Release Summary

This is a minor release of the community.postgresql collection. This changelog contains all changes to the modules and plugins in this collection that have been made after the previous release.

Minor Changes

• postgresql_set - adds the queries return value to return executed DML statements.

Bugfixes

• postgresql_set - fixes resetting logic to allow resetting shared_preload_libraries with reset: true (https://github.com/ansible-collections/community.postgresql/issues/744).
• postgresql_set - forbids resetting shared_preload_libraries by passing an empty string (https://github.com/ansible-collections/community.postgresql/issues/744).

v3.6.1

Compare Source

======

Release Summary

This is a patch release of the community.postgresql collection. This changelog contains all changes to the modules and plugins in this collection that have been added after the previous release.

Bugfixes

• postgresql_user - remove a comment from unit tests that breaks pre-compile (https://github.com/ansible-collections/community.postgresql/issues/737).

v3.6.0

Compare Source

======

Release Summary

This is a minor release of the community.postgresql collection. This changelog contains all changes to the modules and plugins in this collection that have been made after the previous release.

Minor Changes

• postgresql_privs - adds support for granting and revoking privileges on foreign tables (https://github.com/ansible-collections/community.postgresql/issues/724).
• postgresql_subscription - adds support for managing subscriptions in the situation where the subconninfo column is unavailable (such as in CloudSQL) (https://github.com/ansible-collections/community.postgresql/issues/726).

Bugfixes

• postgresql_db - fix issues due to columns in pg_database changing in Postgres 17. (https://github.com/ansible-collections/community.postgresql/issues/729).
• postgresql_info - Use a server check that works on beta and rc versions as well as on actual releases.

v3.5.0

Compare Source

======

Release Summary

This is a minor release of the community.postgresql collection. This changelog contains all changes to the modules and plugins in this collection that have been made after the previous release.

Minor Changes

• postgres - add support for postgres infinity timestamps by replacing them with datetime.min / datetime.max values (https://github.com/ansible-collections/community.postgresql/pull/714).
• postgresql_publication - add the tables_in_schema argument to implement FOR TABLES IN SCHEMA feature (https://github.com/ansible-collections/community.postgresql/issues/709).
• postgresql_user - adds the configuration argument that allows to manage user-specific default configuration (https://github.com/ansible-collections/community.postgresql/issues/598).

Bugfixes

• postgres - psycopg2 automatically sets the datestyle on the connection to iso whenever it encounters a datestyle configuration it doesn't recognize, but psycopg3 does not. Fix now enforces iso datestyle when using psycopg3 (https://github.com/ansible-collections/community.postgresql/issues/711).

---

Configuration

📅 Schedule: Branch creation - At any time (no schedule defined), Automerge - At any time (no schedule defined).

🚦 Automerge: Disabled by config. Please merge this manually once you are satisfied.

♻ Rebasing: Whenever MR becomes conflicted, or you tick the rebase/retry checkbox.

🔕 Ignore: Close this MR and you won't be reminded about this update again.

---

• If you want to rebase/retry this MR, check this box

---

This MR has been generated by Renovate Bot.