Stream triggers row variables v5

TG_NAME

Data type name. This variable contains the name of the trigger actually fired. The actual trigger name has a \_bdrt or \_bdrc suffix (depending on trigger type) compared to the name provided during trigger creation.

TG_WHEN

Data type text. This variable says BEFORE for both conflict and transform triggers. You can get the stream trigger type by calling the bdr.trigger_get_type() information function. See bdr.trigger_get_type.

TG_LEVEL

Data type text: a string of ROW.

TG_OP

Data type text: a string of INSERT, UPDATE, or DELETE identifying the operation for which the trigger was fired.

TG_RELID

Data type oid: the object ID of the table that caused the trigger invocation.

TG_TABLE_NAME

Data type name: the name of the table that caused the trigger invocation.

TG_TABLE_SCHEMA

Data type name: the name of the schema of the table that caused the trigger invocation. For partitioned tables, this is the name of the root table.

TG_NARGS

Data type integer: the number of arguments given to the trigger function in the bdr.create_conflict_trigger() or bdr.create_transform_trigger() statement.

TG_ARGV[]

Data type array of text: the arguments from the bdr.create_conflict_trigger() or bdr.create_transform_trigger() statement. The index counts from 0. Invalid indexes (less than 0 or greater than or equal to TG_NARGS) result in a NULL value.