Changes between Version 6 and Version 7 of drmsSumRm

Timestamp:

09/11/14 14:51:07 (10 years ago)

Author:

joe

Comment:

fixed trigger

drmsSumRm

@@ -117 +117 @@
 CREATE OR REPLACE FUNCTION no_retention ( ) RETURNS TRIGGER LANGUAGE PLPGSQL AS $$
 BEGIN
-NEW.effective_date := to_char( (now()+INTERVAL '2 hours'), 'YYYYMMDDHH24MI' );
+NEW.effective_date := to_char( (now()+INTERVAL '6 hours'), 'YYYYMMDDHH24MI' );
+RETURN NEW;
 END
 $$;
 
-CREATE TRIGGER no_retention BEFORE INSERT ON sum_partn_alloc FOR EACH ROW EXECUTE PROCEDURE no_retention();
-}}}
+CREATE TRIGGER no_retention BEFORE INSERT ON sum_partn_alloc FOR EACH ROW EXECUTE PROCEDURE no_retention();}}}