Pastie Support Pastie or read my Pastie << self blog

  SELECT COUNT(*) INTO triggers from (pg_trigger join pg_class on tgrelid=pg_class.oid)
  join pg_proc on (tgfoid=pg_proc.oid) WHERE tgname = 'compute_best_prices_for_amazon_item_on_update';
  
  if triggers > 0 then
    DROP TRIGGER compute_best_prices_for_amazon_item_on_update ON amazon_items;
  end if;