postgresql_alter_system fails for parameters with a reserved keyword after the dot (e.g., online_analyze.verbose)

SUMMARY

postgresql_alter_system fails for parameters with a reserved keyword after the dot (e.g., online_analyze.verbose)

ISSUE TYPE

• Bug Report

COMPONENT NAME

postgresql_alter_system

ANSIBLE VERSION

ansible [core 2.19.11]

COLLECTION VERSION

Collection           Version
-------------------- -------
community.postgresql 4.2.0  

OS / ENVIRONMENT

debian 12

STEPS TO REPRODUCE

- name: Apply postgres settings
  become_user: "postgres"
  community.postgresql.postgresql_alter_system:
    login_unix_socket: "/var/lib/postrgesql" #or your socket
    param: '"online_analyze.verbose"'
    value: 'on'

-------------------------------------------------------------------

- name: Apply postgres settings
  become_user: "postgres"
  community.postgresql.postgresql_alter_system:
    login_unix_socket: "/var/lib/postrgesql"
    param: "online_analyze.verbose"
    value: 'on'

ACTUAL RESULTS

[ERROR]: Task failed: Module failed: Parameter "online_analyze.verbose" does not exist
Origin: /myprocject/configure.yml:50:3

48 - meta: flush_handlers
49
50 - name: Apply postgres settings
     ^ column 3

fatal: [hostname]: FAILED! => {"changed": false, "msg": "Parameter \"online_analyze.verbose\" does not exist"}

-------------------------------------------------------------------

[ERROR]: Task failed: Module failed: Cannot set online_analyze.verbose: syntax error at or near "verbose"
LINE 1: ALTER SYSTEM SET online_analyze.verbose = 'on'
                                        ^

Origin: /myprocject/configure.yml:50:3

48 - meta: flush_handlers
49
50 - name: Apply postgres settings
     ^ column 3

fatal: [hostname]: FAILED! => {"changed": false, "msg": "Cannot set online_analyze.verbose: syntax error at or near \"verbose\"\nLINE 1: ALTER SYSTEM SET online_analyze.verbose = 'on'\n                                        ^\n"}