STORE_TRIGGER7

Indicate that a trigger should not be disabled by slony-i on a subscriber node

Usage

STORE TRIGGER (options);

Overview

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.

FCTABLE ID = ival F[0]: The unique, numeric ID number of the table the trigger is defined for.

FCTRIGGER NAME = 'string' F[0]: The name of the trigger as it appears in the pg_trigger system catalog.

FCEVENT NODE = ival F[0]: (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].

Examples

FCSTORE TRIGGER (
    TABLE ID = 2,
    TRIGGER NAME = 'cache_invalidation'
);
    F[0]

Locking behaviour

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.

Version information

This command was introduced in Slony-I 1.0

Releases

2 releases since Debian 4.0 (Etch); the text changed 1 time.