pgAgent commit: Use 'YEAR' part of a date to determine the leap year.

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(-)

Browse pgadmin-hackers by date

  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