Re: [pgAdmin4][Patch]: RM #3638 Syntax Error displayed when user tryto create new Schedule and select start date and time in Exception - Mailing list pgadmin-hackers

From Dave Page
Subject Re: [pgAdmin4][Patch]: RM #3638 Syntax Error displayed when user tryto create new Schedule and select start date and time in Exception
Date
Msg-id CA+OCxox4oeAGv6E00_F=r2RnqDO9X+7LG0AvR=UEMaMWep_U0g@mail.gmail.com
Whole thread Raw
In response to [pgAdmin4][Patch]: RM #3638 Syntax Error displayed when user try tocreate new Schedule and select start date and time in Exception  (Akshay Joshi <akshay.joshi@enterprisedb.com>)
List pgadmin-hackers
Thanks, patch applied.

On Fri, Oct 12, 2018 at 12:18 PM Akshay Joshi <akshay.joshi@enterprisedb.com> wrote:
Hi Hackers,

Attached is the patch to fix the RM 3638 "Syntax Error displayed when user try to create new Schedule and select start date and time in Exception". Patch contains following fixes:
  • Fixed syntax error.
  • Update/Delete exceptions are not working, SQL is wrong.
  • Wrong exception time is shown, it should shown in UTC as datatype of the column is timestamp with out timezone.
  • Added test cases for Schedule and Steps of pgAgent Job.    
Please review it.
--
Akshay Joshi
Sr. Software Architect


Phone: +91 20-3058-9517
Mobile: +91 976-788-8246


--
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: Dave Page
Date:
Subject: pgAdmin 4 commit: Fix syntax error when creating new pgAgentschedules
Next
From: Dave Page
Date:
Subject: pgAdmin 4 commit: Release note update