Re: RM3079 fix for wrong sql datetime/time related datatypes - Mailing list pgadmin-hackers

From Dave Page
Subject Re: RM3079 fix for wrong sql datetime/time related datatypes
Date
Msg-id CA+OCxozOK8+6-a1RwjZoQ2MtL-GqLFpUukTWa8FG0Twz8Eoj_A@mail.gmail.com
Whole thread Raw
In response to Re: RM3079 fix for wrong sql datetime/time related datatypes  (Harshal Dhumal <harshal.dhumal@enterprisedb.com>)
List pgadmin-hackers
Thanks, applied.

On Wed, Feb 28, 2018 at 3:00 PM, Harshal Dhumal <harshal.dhumal@enterprisedb.com> wrote:
Great, thanks! 

On Feb 28, 2018 8:15 PM, "Joao De Almeida Pereira" <jdealmeidapereira@pivotal.io> wrote:
Hello Harshal,

I tried the example you showed and it works. Also passed the patch through our CI Pipeline and everything is good.

Thanks
Joao

On Wed, Feb 28, 2018 at 6:25 AM Harshal Dhumal <harshal.dhumal@enterprisedb.com> wrote:
Hi,

On Tue, Feb 27, 2018 at 8:54 PM, Dave Page <dpage@pgadmin.org> wrote:
Hi

On Tue, Feb 27, 2018 at 2:36 PM, Harshal Dhumal <harshal.dhumal@enterprisedb.com> wrote:
Hi,

Please find patch to fix wrong sql issue for time related type.

Steps to reproduce:

Alter any time/datetime array related data type, it generates sql with addition array bracket

Inline image 1

This seems to be missing the test case that you noted should be included in the original bug report! 

Please find updated patch with test cases. 


Thanks,

--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

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



--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

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

pgadmin-hackers by date:

Previous
From: Dave Page
Date:
Subject: pgAdmin 4 commit: Fix handling of tie/datetime array types whenadding
Next
From: Dave Page
Date:
Subject: pgAdmin 4 commit: PEP8 fixes for the Casts, Event triggers,Extensions