2 -- Function to enforce consistency in task start/end dates
4 DROP FUNCTION projtask_insert_depend () CASCADE ;
5 CREATE OR REPLACE FUNCTION projtask_insert_depend () RETURNS OPAQUE AS '
11 -- ENFORCE START/END DATE logic
13 IF NEW.start_date > NEW.end_date THEN
14 RAISE EXCEPTION ''START DATE CANNOT BE AFTER END DATE'';
17 -- First make sure we start on or after end_date of tasks
20 FOR dependon IN SELECT * FROM project_dependon_vw
21 WHERE project_task_id=NEW.project_task_id LOOP
23 -- See if the task we are dependon on
24 -- ends after we are supposed to start
26 IF dependon.end_date > NEW.start_date THEN
27 delta := dependon.end_date-NEW.start_date;
28 RAISE NOTICE ''Bumping Back: % Delta: % '',NEW.project_task_id,delta;
29 NEW.start_date := NEW.start_date+delta;
30 NEW.end_date := NEW.end_date+delta;
39 -- Re-create the trigger
41 CREATE TRIGGER projtask_insert_depend_trig BEFORE INSERT OR UPDATE ON project_task
42 FOR EACH ROW EXECUTE PROCEDURE projtask_insert_depend();