Index: pgagent.sql
===================================================================
RCS file: /projects/pgagent/pgagent.sql,v
retrieving revision 1.7
retrieving revision 1.8
diff -Lpgagent.sql -Lpgagent.sql -u -w -r1.7 -r1.8
--- pgagent.sql
+++ pgagent.sql
@@ -86,11 +86,11 @@
 jscweekdays          bool[7]              NOT NULL DEFAULT '{f,f,f,f,f,f,f}',
 jscmonthdays         bool[32]             NOT NULL DEFAULT '{f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f}',
 jscmonths            bool[12]             NOT NULL DEFAULT '{f,f,f,f,f,f,f,f,f,f,f,f}',
-CONSTRAINT pga_schedule_jscminutes_size CHECK (array_upper(jscminutess, 1) = 60),
+CONSTRAINT pga_schedule_jscminutes_size CHECK (array_upper(jscminutes, 1) = 60),
 CONSTRAINT pga_schedule_jschours_size CHECK (array_upper(jschours, 1) = 24),
 CONSTRAINT pga_schedule_jscweekdays_size CHECK (array_upper(jscweekdays, 1) = 7),
 CONSTRAINT pga_schedule_jscmonthdays_size CHECK (array_upper(jscmonthdays, 1) = 32),
-CONSTRAINT pga_schedule_jscmonths_size CHECK (array_upper(jscmonths, 1) = 12),
+CONSTRAINT pga_schedule_jscmonths_size CHECK (array_upper(jscmonths, 1) = 12)
 ) WITHOUT OIDS;
 CREATE INDEX pga_jobschedule_jobid ON pgagent.pga_schedule(jscjobid);
 COMMENT ON TABLE pgagent.pga_schedule IS 'Schedule for a job';
@@ -550,10 +550,12 @@
 COMMENT ON FUNCTION pgagent.pga_is_leap_year(int2) IS 'Returns TRUE is $1 is a leap year';
   
   
+/*
+!!! not yet implemented?
 CREATE TRIGGER pga_job_trigger BEFORE UPDATE
    ON pgagent.pga_job FOR EACH ROW
    EXECUTE PROCEDURE pgagent.pga_job_trigger();
-
+*/
 
 
 CREATE OR REPLACE FUNCTION pgagent.pga_schedule_trigger() RETURNS trigger AS '
@@ -573,14 +575,14 @@
     END IF;
 END;
 ' LANGUAGE 'plpgsql';
-COMMENT ON FUNCTION pgagent.pga_schedule_trigger() IS 'Update the job\'s next run time whenever a schedule changes';
+COMMENT ON FUNCTION pgagent.pga_schedule_trigger() IS 'Update the job''s next run time whenever a schedule changes';
 
 
 
 CREATE TRIGGER pga_schedule_trigger AFTER INSERT OR UPDATE OR DELETE
    ON pgagent.pga_schedule FOR EACH ROW
    EXECUTE PROCEDURE pgagent.pga_schedule_trigger();
-COMMENT ON TRIGGER pga_schedule_trigger ON pgagent.pga_schedule IS 'Update the job\'s next run time whenever a schedule changes';
+COMMENT ON TRIGGER pga_schedule_trigger ON pgagent.pga_schedule IS 'Update the job''s next run time whenever a schedule changes';
 
 
 CREATE OR REPLACE FUNCTION pgagent.pga_exception_trigger() RETURNS "trigger" AS '
@@ -611,11 +613,11 @@
     END IF;
 END;
 ' LANGUAGE 'plpgsql' VOLATILE;
-COMMENT ON FUNCTION pgagent.pga_schedule_trigger() IS 'Update the job\'s next run time whenever an exception changes';
+COMMENT ON FUNCTION pgagent.pga_schedule_trigger() IS 'Update the job''s next run time whenever an exception changes';
 
 
 
 CREATE TRIGGER pga_exception_trigger AFTER INSERT OR UPDATE OR DELETE
   ON pgagent.pga_exception FOR EACH ROW
   EXECUTE PROCEDURE pgagent.pga_exception_trigger();
-COMMENT ON TRIGGER pga_exception_trigger ON pgagent.pga_exception IS 'Update the job\'s next run time whenever an exception changes';
\ No newline at end of file
+COMMENT ON TRIGGER pga_exception_trigger ON pgagent.pga_exception IS 'Update the job''s next run time whenever an exception changes';
\ No newline at end of file