postgresql_table does not track changes in unlogged
#878 opened on Aug 5, 2025
Repository metrics
- Stars
- (142 stars)
- PR merge metrics
- (PR metrics pending)
Description
SUMMARY
the community.postgresql.postgresql_table is able to create an unlogged table but is not able to change it from logged to unlogged.
ISSUE TYPE
- Bug Report
COMPONENT NAME
community.postgresql.postgresql_table
ANSIBLE VERSION
> ansible --version
ansible [core 2.17.12]
config file = None
configured module search path = ['/home/ajackson/.ansible/plugins/modules', '/usr/share/ansible/plugins/modules']
ansible python module location = /home/ajackson/monorepo/.venv/lib/python3.10/site-packages/ansible
ansible collection location = /home/ajackson/.ansible/collections:/usr/share/ansible/collections
executable location = /home/ajackson/monorepo/.venv/bin/ansible
python version = 3.10.12 (main, May 27 2025, 17:12:29) [GCC 11.4.0] (/home/ajackson/monorepo/.venv/bin/python)
jinja version = 3.1.6
libyaml = True
COLLECTION VERSION
-->
> ansible-galaxy collection list community.general
# /home/ajackson/.ansible/collections/ansible_collections
Collection Version
----------------- -------
community.general 11.1.0
OS / ENVIRONMENT
Linux
STEPS TO REPRODUCE
create a table using community.postgresql.postgresql_table with unlogged: true. Then subsequently change unlogged to false. Run the ansible again, it will show no changes and make no attempt to change the table from unlogged to logged.
EXPECTED RESULTS
I would expect the table to change from unlogged to logged and for a change to show up in the summary.
ACTUAL RESULTS
Ansible does not make any change to the table and shows up as OK in the summary.