Re: RM3079 fix for wrong sql datetime/time related datatypes

From: Dave Page <dpage(at)pgadmin(dot)org>
To: Harshal Dhumal <harshal(dot)dhumal(at)enterprisedb(dot)com>
Cc: Joao Pedro De Almeida Pereira <jdealmeidapereira(at)pivotal(dot)io>, pgadmin-hackers <pgadmin-hackers(at)postgresql(dot)org>
Subject: Re: RM3079 fix for wrong sql datetime/time related datatypes
Date: 2018-03-02 11:52:02
Message-ID: CA+OCxozOK8+6-a1RwjZoQ2MtL-GqLFpUukTWa8FG0Twz8Eoj_A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-hackers

Thanks, applied.

On Wed, Feb 28, 2018 at 3:00 PM, Harshal Dhumal <
harshal(dot)dhumal(at)enterprisedb(dot)com> wrote:

> Great, thanks!
>
> On Feb 28, 2018 8:15 PM, "Joao De Almeida Pereira" <
> jdealmeidapereira(at)pivotal(dot)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(dot)dhumal(at)enterprisedb(dot)com> wrote:
>>
>>> Hi,
>>>
>>> On Tue, Feb 27, 2018 at 8:54 PM, Dave Page <dpage(at)pgadmin(dot)org> wrote:
>>>
>>>> Hi
>>>>
>>>> On Tue, Feb 27, 2018 at 2:36 PM, Harshal Dhumal <
>>>> harshal(dot)dhumal(at)enterprisedb(dot)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
>>>>>
>>>>> [image: 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

In response to

Browse pgadmin-hackers by date

  From Date Subject
Next Message Dave Page 2018-03-02 11:59:17 pgAdmin 4 commit: PEP8 fixes for the Casts, Event triggers, Extensions
Previous Message Dave Page 2018-03-02 11:51:56 pgAdmin 4 commit: Fix handling of tie/datetime array types when adding