Re: PgAgent leap year problem

Hi Ashesh,

I have reviewed it and looks good.  I have updated the sql version in header of each sql file.

Thanks,

Neel Patel

On Wed, Mar 4, 2020 at 12:22 PM Ashesh Vashi <ashesh.vashi@enterprisedb.com> wrote:

On Wed, Mar 4, 2020 at 10:53 AM Neel Patel <neel.patel@enterprisedb.com> wrote:

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 ?

Mehmet,

Thanks for your patch.

Changes look good except it does not take care of the upgrade scenarios.

Hence - updated the patch for the same.

Neel, 

Would you please review the updated patch with the upgrade scenarios?

-- Thanks, Ashesh 

Thanks,

Neel Patel

On Mon, Mar 2, 2020 at 5:26 PM Mehmet Emin KARAKAŞ <emin100@gmail.com> wrote:

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...

--

MEHMET EMİN KARAKAŞ
PostgreSQL DBA

Turksat Satellite Communication and Cable TV Operations
Konya Yolu 40. Km. 06839 Golbasi / ANKARA - TÜRKİYE
Tel     :  +90 312 615 32 73
Faks  :  +90 312 615 32 77