| From: | Dave Page <dpage(at)pgadmin(dot)org> |
|---|---|
| To: | Neel Patel <neel(dot)patel(at)enterprisedb(dot)com> |
| Cc: | pgadmin-hackers <pgadmin-hackers(at)lists(dot)postgresql(dot)org>, Vik Fearing <vik(dot)fearing(at)enterprisedb(dot)com> |
| Subject: | Re: [pgagent]: Modified 'next_schedule' function and updated pgagent 4.2 version |
| Date: | 2020-04-24 09:09:51 |
| Message-ID: | CA+OCxow_PByivYNaC8ZGD0sFh-O8H_xzzTdnQQYgzmBSG+0-oQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgadmin-hackers |
Hi
On Thu, Apr 23, 2020 at 12:21 PM Neel Patel <neel(dot)patel(at)enterprisedb(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Vik Fearing | 2020-04-24 09:23:27 | Re: [pgagent]: Modified 'next_schedule' function and updated pgagent 4.2 version |
| Previous Message | Pradip Parkale | 2020-04-24 08:18:11 | [pgAdmin][RM4504] Make like options disable if Relation is not selected. |