SVN Commit by dpage: r4853 - in trunk/pgadmin3: . xtra/pgagent

Author: dpage
Date: 2005-12-23 08:34:38 +0000 (Fri, 23 Dec 2005)
New Revision: 4853

Modified:
   trunk/pgadmin3/CHANGELOG.txt
   trunk/pgadmin3/xtra/pgagent/pgagent.sql
Log:
Use ELSIF not ELSEIF for compatibility with 7.x servers [Glen Sasek]

Modified: trunk/pgadmin3/CHANGELOG.txt
===================================================================
--- trunk/pgadmin3/CHANGELOG.txt    2005-12-23 08:30:47 UTC (rev 4852)
+++ trunk/pgadmin3/CHANGELOG.txt    2005-12-23 08:34:38 UTC (rev 4853)
@@ -18,7 +18,8 @@
 </ul>
 <br>
 <ul>
-    <li>2005-12-2� AP         dlgLanguage name+comment, dlgDatabase comment [Hiroshi]
+    <li>2005-12-23 DP  1.4.2  Use ELSIF not ELSEIF in pgagent.sql for compatibility with 7.x servers [Glen Sasek]
+    <li>2005-12-22 HS         dlgLanguage name+comment, dlgDatabase comment
     <li>2005-12-15 DP  1.4.2  Exclude system schemas by name rather than OID, so that 'public' can be safely renamed.
     <li>2005-12-12 AP  1.4.2  fix slony node statistics
     <li>2005-12-11 AP         support 8.1 language templates

Modified: trunk/pgadmin3/xtra/pgagent/pgagent.sql
===================================================================
--- trunk/pgadmin3/xtra/pgagent/pgagent.sql    2005-12-23 08:30:47 UTC (rev 4852)
+++ trunk/pgadmin3/xtra/pgagent/pgagent.sql    2005-12-23 08:34:38 UTC (rev 4853)
@@ -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';