1 CREATE SCHEMA timewarp;
4 CREATE OR REPLACE FUNCTION timewarp.trialbaltrigger() RETURNS trigger
10 SELECT period_id INTO v_tmp_id FROM timewarp.period LIMIT 1;
15 -- if there is no change in the trailbalance values, do not update the
21 (OLD.trialbal_beginning = NEW.trialbal_beginning)
23 (OLD.trialbal_ending = NEW.trialbal_ending)
25 (OLD.trialbal_credits = NEW.trialbal_credits)
27 (OLD.trialbal_debits = NEW.trialbal_debits)
33 PERFORM timewarp.trialbal_fill(NEW.trialbal_id);
39 LANGUAGE plpgsql VOLATILE
42 ALTER FUNCTION timewarp.trialbaltrigger()
45 GRANT ALL ON FUNCTION timewarp.trialbaltrigger() TO xtrole;
47 CREATE TRIGGER _trialbaltrigger
48 AFTER INSERT OR UPDATE ON public.trialbal
49 FOR EACH ROW EXECUTE PROCEDURE timewarp.trialbaltrigger();
52 -------- yearperiod----------------
57 CREATE OR REPLACE FUNCTION timewarp.yearperiodtrigger() RETURNS trigger
63 SELECT period_id INTO v_tmp_id FROM timewarp.period LIMIT 1;
69 PERFORM timewarp.yearperiod_fill(NEW.yearperiod_id);
75 LANGUAGE plpgsql VOLATILE
78 ALTER FUNCTION timewarp.yearperiodtrigger()
82 GRANT ALL ON FUNCTION timewarp.yearperiodtrigger() TO xtrole;
84 CREATE TRIGGER _yearperiodtrigger
85 AFTER INSERT OR UPDATE ON public.yearperiod
86 FOR EACH ROW EXECUTE PROCEDURE timewarp.yearperiodtrigger();
89 ---------------------- period--------------------------------------
93 CREATE OR REPLACE FUNCTION timewarp.periodtrigger() RETURNS trigger
98 SELECT period_id INTO v_tmp_id FROM timewarp.period LIMIT 1;
103 PERFORM timewarp.period_fill(NEW.period_id);
109 LANGUAGE plpgsql VOLATILE
112 ALTER FUNCTION timewarp.periodtrigger()
114 GRANT ALL ON FUNCTION timewarp.periodtrigger() TO xtrole;
116 CREATE TRIGGER _periodtrigger
117 AFTER INSERT OR UPDATE ON public.period
118 FOR EACH ROW EXECUTE PROCEDURE timewarp.periodtrigger();