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

NAME

       DROP  TRIGGER - Return a trigger to default behavior, where it will not
       fire on subscriber nodes

SYNOPSIS

       DROP TRIGGER (options);

DESCRIPTION

       Remove the special handling for the specified trigger.

       TABLE ID = ival
              The unique, numeric ID  number  of  the  table  the  trigger  is
              defined 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 “schemadocdroptrigger( integer, name )” [not available  as  a
       man page].

EXAMPLE

       DROP TRIGGER (
           TABLE ID = 2,
           TRIGGER NAME = ’cache_invalidation’
       );

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 remove the trigger.

VERSION INFORMATION

       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)