Provided by: slony1-doc_1.2.15-1_all
STORE TRIGGER - Indicate that a trigger should not be disabled by
Slony-I on a subscriber node
STORE TRIGGER (options);
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
TRIGGER NAME = ’string’
The name of the trigger as it appears in the pg_trigger system
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
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)