let's get build_app running on a masterref database

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

diff --git a/foundation-database/public/trigger_functions/itemuomconv.sql b/foundation-database/public/trigger_functions/itemuomconv.sql
index 2350510..2750f6c 100644 (file)
--- a/foundation-database/public/trigger_functions/itemuomconv.sql
+++ b/foundation-database/public/trigger_functions/itemuomconv.sql
@@ -1,5 +1,5 @@
 CREATE OR REPLACE FUNCTION _itemuomconvTrigger () 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.
 BEGIN
 
@@ -7,10 +7,10 @@ BEGIN
    IF (NOT checkPrivilege(''MaintainItemMasters'')) THEN
      RAISE EXCEPTION ''You do not have privileges to maintain Items.'';
    END IF;
-  
+
   RETURN NEW;
 END;
 ' LANGUAGE 'plpgsql';
 
-DROP TRIGGER itemuomconvTrigger ON itemuomconv;
+DROP TRIGGER IF EXISTS itemuomconvTrigger ON itemuomconv;
 CREATE TRIGGER itemuomconvTrigger AFTER INSERT OR UPDATE ON itemuomconv FOR EACH ROW EXECUTE PROCEDURE _itemuomconvTrigger();