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
exceptionchanges'; 
\ 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
exceptionchanges';