Use 'YEAR' part of a date to determine the leap year.
In order to calculate the last day of the month, we were using 'DAY'
part of a date to determine the leap year, which was wrong. We should
have used 'YEAR' part for the date for that caculation as proposed in
this change.
Original Patch by: Mehmet Emin KARAKAŞ <emin100@gmail.com>
Bumped the version of pgAgent to 4.1.
Created the upgrade sql scripts to allow upgrading from older version
(i.e. unpacked/3.4/4.0) to 4.1 (latest) version.
Reviewed by: Neel Patel
Branch
------
master
Details
-------
https://git.postgresql.org/gitweb?p=pgagent.git;a=commitdiff;h=943add861a6becec2503191ed6523543e0dd35d7
Modified Files
--------------
CMakeLists.txt | 2 +-
pgAgent.rc | 12 +-
pgaevent/pgamsgevent.rc | 12 +-
sql/pgagent--3.4--4.0.sql | 19 --
sql/pgagent--3.4--4.1.sql | 395 ++++++++++++++++++++++++++++++++++++
sql/pgagent--4.0--4.1.sql | 387 +++++++++++++++++++++++++++++++++++
sql/pgagent--unpackaged--4.0.sql | 52 -----
sql/pgagent--unpackaged--4.1.sql | 428 +++++++++++++++++++++++++++++++++++++++
sql/pgagent.sql | 2 +-
9 files changed, 1224 insertions(+), 85 deletions(-)