DROP TRIGGER (options);
Remove the special handling for the specified trigger.
The unique, numeric ID number of the table the trigger is defined for.
The name of the trigger as it appears in the pg_trigger system catalog.
(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.
DROP TRIGGER ( TABLE ID = 2, TRIGGER NAME = 'cache_invalidation' );