let's get build_app running on a masterref database

[xtuple] / foundation-database / public / trigger_functions / crmacct.sql

diff --git a/foundation-database/public/trigger_functions/crmacct.sql b/foundation-database/public/trigger_functions/crmacct.sql
index 619ba4e..b73aa3d 100644 (file)
--- a/foundation-database/public/trigger_functions/crmacct.sql
+++ b/foundation-database/public/trigger_functions/crmacct.sql
@@ -1,6 +1,6 @@
 -- TODO: add special handling for converting prospects <-> customers?
 CREATE OR REPLACE FUNCTION _crmacctBeforeTrigger () RETURNS TRIGGER AS $$
--- Copyright (c) 1999-2014 by OpenMFG LLC, d/b/a xTuple. 
+-- Copyright (c) 1999-2014 by OpenMFG LLC, d/b/a xTuple.
 -- See www.xtuple.com/CPAL for the full text of the software license.
 DECLARE
   _count        INTEGER;
@@ -58,12 +58,12 @@ BEGIN
 END;
 $$ LANGUAGE 'plpgsql';
 
-DROP TRIGGER crmacctBeforeTrigger ON crmacct;
+DROP TRIGGER IF EXISTS crmacctBeforeTrigger ON crmacct;
 CREATE TRIGGER crmacctBeforeTrigger BEFORE INSERT OR UPDATE OR DELETE
   ON crmacct FOR EACH ROW EXECUTE PROCEDURE _crmacctBeforeTrigger();
 
 CREATE OR REPLACE FUNCTION _crmacctAfterTrigger () RETURNS TRIGGER AS $$
--- Copyright (c) 1999-2014 by OpenMFG LLC, d/b/a xTuple. 
+-- Copyright (c) 1999-2014 by OpenMFG LLC, d/b/a xTuple.
 -- See www.xtuple.com/CPAL for the full text of the software license.
 DECLARE
   _cmnttypeid INTEGER;
@@ -255,5 +255,5 @@ BEGIN
 END;
 $$ LANGUAGE 'plpgsql';
 
-DROP TRIGGER crmacctAfterTrigger ON crmacct;
+DROP TRIGGER IF EXISTS crmacctAfterTrigger ON crmacct;
 CREATE TRIGGER crmacctAfterTrigger AFTER INSERT OR UPDATE OR DELETE ON crmacct FOR EACH ROW EXECUTE PROCEDURE _crmacctAfterTrigger();