Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.92) (envelope-from ) id 1j9MVf-0004tl-Ed for pgadmin-hackers@arkaria.postgresql.org; Wed, 04 Mar 2020 05:23:56 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1j9MVe-0003to-8O for pgadmin-hackers@arkaria.postgresql.org; Wed, 04 Mar 2020 05:23:54 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1j9MVd-0003th-SH for pgadmin-hackers@lists.postgresql.org; Wed, 04 Mar 2020 05:23:54 +0000 Received: from mail-lj1-x234.google.com ([2a00:1450:4864:20::234]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1j9MVa-0000s2-Ar for pgadmin-hackers@postgresql.org; Wed, 04 Mar 2020 05:23:53 +0000 Received: by mail-lj1-x234.google.com with SMTP id f13so556881ljp.0 for ; Tue, 03 Mar 2020 21:23:49 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=enterprisedb-com.20150623.gappssmtp.com; s=20150623; h=mime-version:references:in-reply-to:from:date:message-id:subject:to :cc; bh=ku2tfRuLS66Dhijr5s2xjxirAn6AwO211r9jcPZ0goQ=; b=mSnOGnwntIffS87LGl5accEKIR4y3A0/CLc3Sqt1mBJ7vdsHTAUeNPr+lLIoip94id eoLG13drv2d/Lcm8IPjT5QbT2OCBkFilI37jNcH23sD0rHRYpLf9jtU7NRnllP+YWs8f KXZfzrrvfSO7Knd967cWqWfPDNdGZjTbB9J9MMX124wWt1WkC4OVwNA+ERZ1Bc8RE84z st8vn5mWBw7+j6cthms4UZyWqcNmwwqTVuxV5Ey6cDtEpuzDxWNDWqorFz+OJdJB6H3y 4G/bQOg2iHnDoKAm5dVWCNX3W4y+iUaL6BLDwaKW8TKpYoGcfjpTuhwaGY1G2Ie6VeWi BBLg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:references:in-reply-to:from:date :message-id:subject:to:cc; bh=ku2tfRuLS66Dhijr5s2xjxirAn6AwO211r9jcPZ0goQ=; b=lPwS+CHH8NjXDkkyXxXebZ+X8eGXK1HfWA8XOXPld8WXE5BgMMQM9tjtUHwxjXJ8Dy TzWUr+nBn8dE68iMv1EAzCtGZIm9spIogQfiVLM4O5hKrBbZMwWw2AABo1S+rcbOYS1F Ro2cVSuuCr1DsGtzOImbMXsPB2mbkGORpj8nDVy2nr01iQmd0Y8gwjgLy2DKQjrdg0Nh asmT4oPLTd6qaZM7wgMZf/eoYkz0p2D4jaUMdFdIyO6ZXum/kidUnm4vG1VR5rEd4yQL eSE8Ki6dMjUZ2YGMSwBmi3I+JJ43NjuJXmjq/bLXZldVHNFsmMrsBdGBEMuh5vBEBh/G S65g== X-Gm-Message-State: ANhLgQ3L4GbP4mMy8DnnB0LhwaViaoXnaPbahnqlUO7VxzOxnkWbTz0c a/BTj27xnnfjdmg2e79BxwHlR+zBoRut488XtvoY4PzqUf3iEoEQsvy3SSqIFKRbiGH6p5+nYK7 iaabT0bKlh1BXNvzK/y3IHDOHK5UfHFE0HW+2C3/Lwe8DsaEuUb5/ux5/qT2va3NyHeRWLbtW8p Fd236wW7CXIIjHSRluAG5tuN0eETVTTXTuyC+G0ij+Wy+am/d30ks= X-Google-Smtp-Source: ADFU+vuIfrXv26Ffgn+fzmXQ9XbnhXGz/eSOdNR0w5SUBegmtlL+2SC/d/1KdQ/G9b+68fcuJ1lg64C+dRA27BqSAtI= X-Received: by 2002:a2e:884c:: with SMTP id z12mr857400ljj.55.1583299427917; Tue, 03 Mar 2020 21:23:47 -0800 (PST) MIME-Version: 1.0 References: In-Reply-To: From: Neel Patel Date: Wed, 4 Mar 2020 10:53:36 +0530 Message-ID: Subject: Re: PgAgent leap year problem To: =?UTF-8?Q?Mehmet_Emin_KARAKA=C5=9E?= , Dave Page , Ashesh Vashi Cc: pgadmin-hackers Content-Type: multipart/alternative; boundary="000000000000f977ce05a0009f1b" X-CLOUD-SEC-AV-Info: edb,google_mail,monitor X-CLOUD-SEC-AV-Sent: true X-Gm-Spam: 0 X-Gm-Phishy: 0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --000000000000f977ce05a0009f1b Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Hi Mehmet, It was a bug in pgAgent. Thank you for sharing the patch. I have reviewed and tested, it is working fine. Dave/Ashesh:- Can we commit this patch ? Thanks, Neel Patel On Mon, Mar 2, 2020 at 5:26 PM Mehmet Emin KARAKA=C5=9E wrote: > Hi, > > Scheduled tasks set as the last day of February this year did not work. I= n > 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... > > -- > 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 > --000000000000f977ce05a0009f1b Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi Mehmet,

It was a bug in pgAgent. Tha= nk you for sharing the patch. I have reviewed and tested, it is working fin= e.

Dave/Ashesh:-=C2=A0 Can we commit this patch ?<= /div>

Thanks,
Neel Patel

On Mon, Mar 2, 2= 020 at 5:26 PM Mehmet Emin KARAKA=C5=9E <emin100@gmail.com> wrote:
Hi,

Scheduled ta= sks set as the last day of February this year did not work. In your schedul= e function have a small bug.=C2=A0 Leap year function get year parameter, b= ut your code is sending day as a parameter.=C2=A0 Fixing patch attached in = this mail.

Best Regards...
<= br>
--
MEHMET EM=C4=B0N KAR= AKA=C5=9E
PostgreSQL DBA

Turksat Satelli= te Communication and Cable TV Operations
Konya Yolu 40. Km. 06839 Golbas= i / ANKARA - T=C3=9CRK=C4=B0YE
Tel=C2=A0 =C2=A0=C2=A0 :=C2=A0 +90 312 61= 5 32 73
Faks=C2=A0 :=C2=A0 +90 312 615 32 77
--000000000000f977ce05a0009f1b--