New in version 1.7.
when dropping a language, also delete object that depend on this language.
only used when
name of database where the language will be added, removed or changed
in some cases, it is not possible to remove a language (used by the db-system). When dependencies block the removal, consider using
marks the language as trusted, even if it's marked as untrusted in pg_pltemplate.
use with care!
name of the procedural language to add, remove or change
Host running PostgreSQL where you want to execute the actions.
Password used to authenticate with PostgreSQL (must match
User used to authenticate with PostgreSQL
Database port to connect to.
The state of the language for the selected database
make this language trusted for the selected db
# Add language pltclu to database testdb if it doesn't exist: - postgresql_lang db=testdb lang=pltclu state=present # Add language pltclu to database testdb if it doesn't exist and mark it as trusted: # Marks the language as trusted if it exists but isn't trusted yet # force_trust makes sure that the language will be marked as trusted - postgresql_lang: db: testdb lang: pltclu state: present trust: yes force_trust: yes # Remove language pltclu from database testdb: - postgresql_lang: db: testdb lang: pltclu state: absent # Remove language pltclu from database testdb and remove all dependencies: - postgresql_lang: db: testdb lang: pltclu state: absent cascade: yes # Remove language c from database testdb but ignore errors if something prevents the removal: - postgresql_lang: db: testdb lang: pltclu state: absent fail_on_drop: no
This module is flagged as preview which means that it is not guaranteed to have a backwards compatible interface.
This module is community maintained without core committer oversight.
For more information on what this means please read Module Support