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