DROP TRIGGER - Return a trigger to default behavior, where it will not
fire on subscriber nodes
DROP TRIGGER (options);
Remove the special handling for the specified trigger.
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 “schemadocdroptrigger( integer, name )” [not available as a
DROP 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 remove the trigger.
This command was introduced in Slony-I 1.0
In Slony-I version 2.0, this command is removed as obsolete because
triggers are no longer ‘messed around with’ in the system catalogue.
12 May 2010 SLONIK DROP TRIGGER(7)