community.postgresql.postgresql_info is showing the namespaces of "db" variable for every database

[marcosdiez]

SUMMARY

let's say I have :

• db1, with namespaces ns1A and ns1B
• db2 with namespaces ns2A and ns2B

whenever I use

  - community.postgresql.postgresql_info:
      login_host: 127.0.0.1
      login_user: root
      login_password: super_secret_password
      db: "db1"
    register: db_info

  - debug:
      msg: "{{ db_info }}"

it will print ns1A and ns1B both as the namespaces of both db1 and db2.
Not only that, ns2A and ns2B won't be returned at all.

ISSUE TYPE

• Bug Report

COMPONENT NAME

community.postgresql.postgresql_info

ANSIBLE VERSION

ansible 2.9.6
  config file = /etc/ansible/ansible.cfg
  configured module search path = ['/home/mdiez/.ansible/plugins/modules', '/usr/share/ansible/plugins/modules']
  ansible python module location = /usr/lib/python3/dist-packages/ansible
  executable location = /usr/bin/ansible
  python version = 3.8.10 (default, Sep 28 2021, 16:10:42) [GCC 9.3.0]

COLLECTION VERSION