MIME-Version: 1.0
From: =?UTF-8?Q?Mehmet_Emin_KARAKA=C5=9E?= <emin100@gmail.com>
Date: Mon, 2 Mar 2020 14:56:30 +0300
Message-ID: 
 <CANQrdXBzJNK+_tDgju_qTq-OuG7dKdqNZ6Xv=-n0-RoYM0PXhA@mail.gmail.com>
Subject: PgAgent leap year problem
To: pgadmin-hackers <pgadmin-hackers@postgresql.org>
Content-Type: multipart/mixed; boundary="000000000000635591059fdde15d"
Precedence: bulk

--000000000000635591059fdde15d
Content-Type: multipart/alternative; boundary="000000000000635590059fdde15b"

--000000000000635590059fdde15b
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Hi,

Scheduled tasks set as the last day of February this year did not work. In
your schedule function have a small bug.  Leap year function get year
parameter, but your code is sending day as a parameter.  Fixing patch
attached in this mail.

Best Regards...

--=20
MEHMET EM=C4=B0N KARAKA=C5=9E
PostgreSQL DBA

Turksat Satellite Communication and Cable TV Operations
Konya Yolu 40. Km. 06839 Golbasi / ANKARA - T=C3=9CRK=C4=B0YE
Tel     :  +90 312 615 32 73
Faks  :  +90 312 615 32 77

--000000000000635590059fdde15b
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Hi,<div><br></div><div>Scheduled tasks set as the last day=
 of February this year did not work. In your schedule function have a small=
 bug.=C2=A0 Leap year function get year parameter, but your code is sending=
 day as a parameter.=C2=A0 Fixing patch attached in this mail.</div><div><b=
r></div><div>Best Regards...<br clear=3D"all"><div><br></div>-- <br><div di=
r=3D"ltr" class=3D"gmail_signature" data-smartmail=3D"gmail_signature"><div=
 dir=3D"ltr"><div>MEHMET EM=C4=B0N KARAKA=C5=9E<br><span style=3D"font-fami=
ly:Arial,Helvetica,sans-serif;font-size:small;letter-spacing:normal">Postgr=
eSQL DBA</span><br><br>Turksat Satellite Communication and Cable TV Operati=
ons<br>Konya Yolu 40. Km. 06839 Golbasi / ANKARA - T=C3=9CRK=C4=B0YE<br>Tel=
=C2=A0 =C2=A0=C2=A0 :=C2=A0 +90 312 615 32 73<br>Faks=C2=A0 :=C2=A0 +90 312=
 615 32 77</div></div></div></div></div>

--000000000000635590059fdde15b--

--000000000000635591059fdde15d
Content-Type: text/x-patch; charset="US-ASCII";
 name="pgagent_leap_year_problem.diff"
Content-Disposition: attachment; filename="pgagent_leap_year_problem.diff"
Content-Transfer-Encoding: base64
Content-ID: <f_k7aej98x0>
X-Attachment-Id: f_k7aej98x0

ZGlmZiAtLWdpdCBhL3NxbC9wZ2FnZW50LnNxbCBiL3NxbC9wZ2FnZW50LnNxbAppbmRleCA3ZWI0
MmJhLi43ZmY1NTJiIDEwMDY0NAotLS0gYS9zcWwvcGdhZ2VudC5zcWwKKysrIGIvc3FsL3BnYWdl
bnQuc3FsCkBAIC00NzYsNyArNDc2LDcgQEAgQkVHSU4KICAgICAgICAgICAgIChqc2Ntb250aGRh
eXMgPSAnJ3tmLGYsZixmLGYsZixmLGYsZixmLGYsZixmLGYsZixmLGYsZixmLGYsZixmLGYsZixm
LGYsZixmLGYsZixmLHR9JycgQU5ECiAgICAgICAgICAgICAgKChkYXRlX3BhcnQoJydNT05USCcn
LCBuZXh0cnVuKSBJTiAoMSwzLDUsNyw4LDEwLDEyKSBBTkQgZGF0ZV9wYXJ0KCcnREFZJycsIG5l
eHRydW4pID0gMzEpIE9SCiAgICAgICAgICAgICAgIChkYXRlX3BhcnQoJydNT05USCcnLCBuZXh0
cnVuKSBJTiAoNCw2LDksMTEpIEFORCBkYXRlX3BhcnQoJydEQVknJywgbmV4dHJ1bikgPSAzMCkg
T1IKLSAgICAgICAgICAgICAgKGRhdGVfcGFydCgnJ01PTlRIJycsIG5leHRydW4pID0gMiBBTkQg
KChwZ2FnZW50LnBnYV9pc19sZWFwX3llYXIoZGF0ZV9wYXJ0KCcnREFZJycsIG5leHRydW4pOjpp
bnQyKSBBTkQgZGF0ZV9wYXJ0KCcnREFZJycsIG5leHRydW4pID0gMjkpIE9SIGRhdGVfcGFydCgn
J0RBWScnLCBuZXh0cnVuKSA9IDI4KSkpKSkgQU5ECisgICAgICAgICAgICAgIChkYXRlX3BhcnQo
JydNT05USCcnLCBuZXh0cnVuKSA9IDIgQU5EICgocGdhZ2VudC5wZ2FfaXNfbGVhcF95ZWFyKGRh
dGVfcGFydCgnJ1lFQVInJywgbmV4dHJ1bik6OmludDIpIEFORCBkYXRlX3BhcnQoJydEQVknJywg
bmV4dHJ1bikgPSAyOSkgT1IgZGF0ZV9wYXJ0KCcnREFZJycsIG5leHRydW4pID0gMjgpKSkpKSBB
TkQKICAgICAgICAgICAgIChqc2Ntb250aHMgPSAnJ3tmLGYsZixmLGYsZixmLGYsZixmLGYsZn0n
JyBPUiBqc2Ntb250aHNbZGF0ZV9wYXJ0KCcnTU9OVEgnJywgbmV4dHJ1bildID0gVFJVRSkpIFRI
RU4KIAogCg==
--000000000000635591059fdde15d--