Stream triggers row variables v5.6
Documentation improvements are made only to the latest version.
As per semantic versioning, PGD minor releases remain backward compatible and may include important bug fixes and enhancements.
We recommend upgrading the latest minor release as soon as possible.
If you want up-to-date information, read the latest PGD documentation.
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.