Postgres Pro
Downloads
Home   >   mailing lists

Re: [pgagent]: Modified 'next_schedule' function and updated pgagent4.2 version - Mailing list pgadmin-hackers

From Dave Page
Subject Re: [pgagent]: Modified 'next_schedule' function and updated pgagent4.2 version
Date
Msg-id CA+OCxow_PByivYNaC8ZGD0sFh-O8H_xzzTdnQQYgzmBSG+0-oQ@mail.gmail.com
Whole thread Raw
In response to [pgagent]: Modified 'next_schedule' function and updated pgagent 4.2 version  (Neel Patel <neel.patel@enterprisedb.com>)
Responses Re: [pgagent]: Modified 'next_schedule' function and updated pgagent4.2 version  (Vik Fearing <vik.fearing@enterprisedb.com>)
List pgadmin-hackers
Tree view
Hi

On Thu, Apr 23, 2020 at 12:21 PM Neel Patel <neel.patel@enterprisedb.com> wrote:
Hi,

Please find an updated patch that fixes a bug in 'next_schedule' function where minute should be extracted instead of year for calculation.

Issue found by: Vik Fearing

Please find the attached patch that fixed the issue in respective pgagent files and updated pgagent for 4.2 version.

Do review it and let me know for comments.

Any reason not to use the rewritten version of the function that Vik wrote? It updated it to use much more modern features of pl/pgsql, rather than the now 15 year old syntax that's currently used.
 
--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

pgadmin-hackers by date:

Previous
From: Pradip Parkale
Date:
Subject: [pgAdmin][RM4504] Make like options disable if Relation is not selected.
Next
From: Vik Fearing
Date:
Subject: Re: [pgagent]: Modified 'next_schedule' function and updated pgagent4.2 version