1 files changed, 9 insertions, 1 deletions
diff --git a/sql/dawn.sql b/sql/dawn.sql
index 1dd8e094..c7db7a88 100644
--- a/sql/dawn.sql
+++ b/sql/dawn.sql
@@ -171,7 +171,7 @@ WHEN NEW.folder::TEXT LIKE '%STR%' THEN 'STRUCTURED'
 WHEN NEW.folder::TEXT='M_CSH_CASH' THEN 'CASH'
 WHEN NEW.folder::TEXT='TCSH' THEN 'TRANCHE'
 WHEN NEW.folder::TEXT='SER_ITRXCURVE' THEN 'CURVE'
-LIKE END)::portfolio;
+END)::portfolio;
 RETURN NEW;
 END
 $$ LANGUAGE plpgsql;
@@ -185,6 +185,14 @@ ON
 FOR EACH ROW
 EXECUTE PROCEDURE update_portf();
 
+CREATE TRIGGER fx_portf BEFORE
+INSERT OR UPDATE OF
+    folder
+ON
+    spots
+FOR EACH ROW
+EXECUTE PROCEDURE update_portf();
+
 CREATE TRIGGER bond_notify BEFORE
 INSERT OR UPDATE OF
     identifier,