Documentation
 
 
 

DROP TRIGGER

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.

Example

DROP TRIGGER (
    TABLE ID = 2,
    TRIGGER NAME = 'cache_invalidation'
);
    
 
 ©2004-2007 EnterpriseDB All Rights Reserved