SVN Commit by dpage: r4852 - branches/REL-1_4_0_PATCHES/pgadmin3/xtra/pgagent

Author: dpage
Date: 2005-12-23 08:30:47 +0000 (Fri, 23 Dec 2005)
New Revision: 4852

Modified:
branches/REL-1_4_0_PATCHES/pgadmin3/xtra/pgagent/pgagent.sql
Log:
Use ELSIF not ELSEIF for compatibility with 7.x servers [Glen Sasek]

Modified: branches/REL-1_4_0_PATCHES/pgadmin3/xtra/pgagent/pgagent.sql
===================================================================
--- branches/REL-1_4_0_PATCHES/pgadmin3/xtra/pgagent/pgagent.sql 2005-12-21 14:10:30 UTC (rev 4851)
+++ branches/REL-1_4_0_PATCHES/pgadmin3/xtra/pgagent/pgagent.sql 2005-12-23 08:30:47 UTC (rev 4852)
@@ -275,31 +275,31 @@
IF nextday = 32 THEN
IF nextmonth = 1 THEN
nextday := 31;
- ELSEIF nextmonth = 2 THEN
+ ELSIF nextmonth = 2 THEN
IF pgagent.pga_is_leap_year(nextyear) = TRUE THEN
nextday := 29;
ELSE
nextday := 28;
END IF;
- ELSEIF nextmonth = 3 THEN
+ ELSIF nextmonth = 3 THEN
nextday := 31;
- ELSEIF nextmonth = 4 THEN
+ ELSIF nextmonth = 4 THEN
nextday := 30;
- ELSEIF nextmonth = 5 THEN
+ ELSIF nextmonth = 5 THEN
nextday := 31;
- ELSEIF nextmonth = 6 THEN
+ ELSIF nextmonth = 6 THEN
nextday := 30;
- ELSEIF nextmonth = 7 THEN
+ ELSIF nextmonth = 7 THEN
nextday := 31;
- ELSEIF nextmonth = 8 THEN
+ ELSIF nextmonth = 8 THEN
nextday := 31;
- ELSEIF nextmonth = 9 THEN
+ ELSIF nextmonth = 9 THEN
nextday := 30;
- ELSEIF nextmonth = 10 THEN
+ ELSIF nextmonth = 10 THEN
nextday := 31;
- ELSEIF nextmonth = 11 THEN
+ ELSIF nextmonth = 11 THEN
nextday := 30;
- ELSEIF nextmonth = 12 THEN
+ ELSIF nextmonth = 12 THEN
nextday := 31;
END IF;
END IF;
@@ -337,7 +337,7 @@
-- Wrap into next month
IF (nextmonth = 1 OR nextmonth = 3 OR nextmonth = 5 OR nextmonth = 7 OR nextmonth = 8 OR nextmonth = 10 OR nextmonth = 12) THEN
d = 31;
- ELSEIF (nextmonth = 4 OR nextmonth = 6 OR nextmonth = 9 OR nextmonth = 11) THEN
+ ELSIF (nextmonth = 4 OR nextmonth = 6 OR nextmonth = 9 OR nextmonth = 11) THEN
d = 30;
ELSE
IF pgagent.pga_is_leap_year(nextyear) = TRUE THEN
@@ -405,7 +405,7 @@
-- Wrap into next hour
IF (nextmonth = 1 OR nextmonth = 3 OR nextmonth = 5 OR nextmonth = 7 OR nextmonth = 8 OR nextmonth = 10 OR nextmonth = 12) THEN
d = 31;
- ELSEIF (nextmonth = 4 OR nextmonth = 6 OR nextmonth = 9 OR nextmonth = 11) THEN
+ ELSIF (nextmonth = 4 OR nextmonth = 6 OR nextmonth = 9 OR nextmonth = 11) THEN
d = 30;
ELSE
IF pgagent.pga_is_leap_year(nextyear) = TRUE THEN
@@ -638,4 +638,4 @@
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';