Postgres Trigger Builder

This node assists in creating custom SQL trigger statements to be executed on the input database. The output port can be used for flow control, to prevent subsequent nodes from executing if one of the statements fails.

Read more about Postgres Triggers here:
https://www.postgresql.org/docs/current/sql-createtrigger.html

Postgres Python Fuctions:
https://www.postgresql.org/docs/current/plpython-funcs.html

Options

Trigger Keyword

Determines whether the function is calledbefore, after, or instead of the event. A constraint trigger can only be specified as AFTER.. Default is AFTER operation.

Trigger Event

The SQL operation that the trigger should activate on. Default is INSERT.

Trigger Name

The name to give the new trigger. This must be distinct from the name of any other trigger for the same table. The name cannot be schema-qualified — the trigger inherits the schema of its table. For a constraint trigger, this is also the name to use when modifying the trigger's behavior using SET CONSTRAINTS.

Function Name

A user-supplied function that is declared as taking no arguments and returning type trigger, which is executed when the trigger fires.

Table Selection

The name of the table you want to set the trigger on.

Called Workflow

Specify the workflow URL you want to be called by the trigger.

Nodes

• String Configuration4 ×
• Multiple Selection Configuration2 ×
• Table Row to Variable2 ×
• Component Input1 ×
• Component Output1 ×
• Show all 7 nodes

Extensions

• FeatureKNIME Base nodes
• FeatureKNIME Database
• FeatureKNIME Quick Forms

Links

• No links available