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Ş <emin...@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(-)
