From: | Ashesh Vashi <ashesh(dot)vashi(at)enterprisedb(dot)com> |
---|---|
To: | pgadmin-hackers(at)lists(dot)postgresql(dot)org |
Subject: | pgAgent commit: Use 'YEAR' part of a date to determine the leap year. |
Date: | 2020-03-04 07:51:29 |
Message-ID: | E1j9OoT-0002fh-3w@gothos.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-hackers |
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(at)gmail(dot)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(-)
From | Date | Subject | |
---|---|---|---|
Next Message | Ashesh Vashi | 2020-03-04 07:52:31 | Re: PgAgent leap year problem |
Previous Message | Neel Patel | 2020-03-04 07:06:20 | Re: PgAgent leap year problem |