OpenAPI 3.0.3Apache 2.0raw.githubusercontent.com2026-08-148243531000.1 KB

5f7e0c3a8f59

postgres_trigger

update postgres trigger

post/w/{workspace}/postgres_triggers/update/{path}

Path parameters

workspacestring required
pathstring required

Request body

replication_slot_namestring required

Name of the PostgreSQL logical replication slot to use

publication_namestring required

Name of the PostgreSQL publication to subscribe to for change data capture

pathstring required

The unique Windmill path for this trigger. Must be of the form u/<user>/<path> or f/<folder>/<path>. This is the trigger object path, not the HTTP route path.

script_pathstring required

Path to the script or flow to execute when database changes are detected

is_flowboolean required

True if script_path points to a flow, false if it points to a script

mode'enabled' | 'disabled' | 'suspended'

job trigger mode

postgres_resource_pathstring required

Path to the PostgreSQL resource containing connection configuration

error_handler_pathstring

Path to a script or flow to run when the triggered job fails

error_handler_argsScriptArgs

The arguments to pass to the script or flow

retryRetry — unresolved $ref
permissioned_asstring

The user or group this trigger runs as. Used during deployment to preserve the original trigger owner.

preserve_permissioned_asboolean

When true and the caller is a member of the 'wm_deployers' group, preserves the original permissioned_as value instead of overwriting it.

labelsstring[]

Response

postgres trigger updated