Provided by: slony1-doc_1.2.15-1_all bug
 

NAME

        STORE  TRIGGER  -  Indicate  that  a  trigger should not be disabled by
        Slony-I on a subscriber node
 

SYNOPSIS

        STORE TRIGGER (options);
 

DESCRIPTION

        By default, all user defined triggers and constraints are  disabled  on
        all  subscriber  nodes while a table is replicated. This command can be
        used to explicitly exclude a trigger from being disabled.
 
        TABLE ID = ival
               The unique, numeric ID number of the table the  trigger  is  de‐
               fined for.
 
        TRIGGER NAME = ’string’
               The  name  of the trigger as it appears in the pg_trigger system
               catalog.
 
        EVENT NODE = ival
               (Optional) The ID of the node used to create  the  configuration
               event  that  tells all existing nodes about the special trigger.
               Default value is 1.
 
        This uses “schemadocstoretrigger( integer, name )” [not available as  a
        man page].
 

EXAMPLE

        STORE TRIGGER (
            TABLE ID = 2,
            TRIGGER NAME = ’cache_invalidation’
        );
        This  operation will need to acquire an exclusive lock on the specified
        table on each node to which it applies in order to alter table  schemas
        to add back the trigger.
        This command was introduced in Slony-I 1.0
 
                                17 November 2008               STORE TRIGGER(7)