Navigation

  • index
  • next |
  • previous |
  • EDB Postgres Distributed 5.2.0 documentation »
  • Reference »
  • PGD Reference »
  • Stream Triggers Reference

Stream Triggers Reference¶

See also

Stream Triggers Reference for an introduction to Stream Triggers. !!!

Both Conflict triggers and Transform triggers have access to information about rows and metadata by way of the predefined variables provided by the trigger API and additional information functions provided by PGD.

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

  • Stream triggers row variables

  • Row Information 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[]

Logo

Previous topic

Autopartition

Next topic

Stream triggers manipulation interfaces

Quick search

Table of Contents

  • Compatibility matrix
  • EDB Postgres Distributed Release notes
  • Known issues
  • Introducing PGD quick starts
  • Concepts
  • Planning
  • Installing
  • Using
  • Reference
    • PGD Reference
      • Stream Triggers Reference
«

Navigation

  • index
  • next |
  • previous |
  • EDB Postgres Distributed 5.2.0 documentation »
  • Reference »
  • PGD Reference »
  • Stream Triggers Reference
  • © Copyright EnterpriseDB Corporation.
  • index
  • next |
  • previous |