Stream triggers reference

!!!SeeAlso

Stream triggers for an introduction to Stream Triggers.

In PL/pgSQL, you can use the predefined variables and functions that follow:

• Stream triggers row variables

• Stream triggers row functions

  • bdr.trigger_get_row

  • bdr.trigger_get_committs

  • bdr.trigger_get_xid

  • bdr.trigger_get_type

  • bdr.trigger_get_conflict_type

  • bdr.trigger_get_origin_node_id

  • bdr.ri_fkey_on_del_trigger

Creating and dropping stream triggers is managed through the manipulation interfaces:

• Stream triggers manipulation interfaces

  • bdr.create_conflict_trigger

  • bdr.create_transform_trigger

  • bdr.drop_trigger

• Stream triggers manipulation interfaces
  • bdr.create_conflict_trigger
    • Synopsis
    • Parameters
    • Notes
  • bdr.create_transform_trigger
    • Synopsis
    • Parameters
    • Notes
  • bdr.drop_trigger
    • Synopsis
    • Parameters
    • Notes
• Stream triggers row functions
  • bdr.trigger_get_row
  • Synopsis
  • Parameters
  • bdr.trigger_get_committs
  • Synopsis
  • Parameters
  • bdr.trigger_get_xid
  • Synopsis
  • Parameters
  • bdr.trigger_get_type
  • Synopsis
  • bdr.trigger_get_conflict_type
  • Synopsis
  • bdr.trigger_get_origin_node_id
  • Synopsis
  • Parameters
  • bdr.ri_fkey_on_del_trigger
  • Synopsis
• Stream triggers row variables
  • TG_NAME
  • TG_WHEN
  • TG_LEVEL
  • TG_OP
  • TG_RELID
  • TG_TABLE_NAME
  • TG_TABLE_SCHEMA
  • TG_NARGS
  • TG_ARGV[]