Re: [pgAdmin4][Patch] - RM 4742 - Can not create Primary key with Index & 4624 - RE-SQL/MSQL test cases for Primary Keys

From: Akshay Joshi <akshay(dot)joshi(at)enterprisedb(dot)com>
To: Khushboo Vashi <khushboo(dot)vashi(at)enterprisedb(dot)com>
Cc: pgadmin-hackers <pgadmin-hackers(at)postgresql(dot)org>
Subject: Re: [pgAdmin4][Patch] - RM 4742 - Can not create Primary key with Index & 4624 - RE-SQL/MSQL test cases for Primary Keys
Date: 2019-09-16 06:37:43
Message-ID: CANxoLDd64iriu=qpu+ZZ0UEo-7DNkg-d1dCYsi=RzdOp1tPqrg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-hackers

Thanks, patch applied.

On Mon, Sep 16, 2019 at 11:36 AM Khushboo Vashi <
khushboo(dot)vashi(at)enterprisedb(dot)com> wrote:

> Hi Akshay,
>
> Please find the attached updated patch.
>
> On Fri, Sep 13, 2019 at 6:10 PM Akshay Joshi <
> akshay(dot)joshi(at)enterprisedb(dot)com> wrote:
>
>> Hi Khushboo
>>
>> Following are my review comments:
>>
>> - Test cases failed on every server.
>>
>> Fixed.
>
>>
>> - Delete table scenario is missing in check_constraints and
>> index_constraints.
>>
>> It is not necessary though I have added.
>
>>
>> - Scenario "Primary Key Constraint with Index" is missing in the
>> 11_plus folder, it is available in the default folder.
>>
>> Added.
>
>>
>> - Found one issue when we remove fill factor no MSQL is generated and
>> got the error "can't execute an empty query".
>>
>> Fixed the existing issue for the Primary key.
>
>>
>> - Index is not visible in the properties dialog when we create
>> primary key using index.
>>
>> Whenever the Primary key is created using Index, the index name is
> changed to PK's name.
> So, I have hide the Index field from the Properties and Edit dialogue.
>
> Thanks,
> Khushboo
>
>>
>> -
>>
>>
>> On Fri, Sep 13, 2019 at 2:41 PM Khushboo Vashi <
>> khushboo(dot)vashi(at)enterprisedb(dot)com> wrote:
>>
>>> Hi,
>>>
>>> Please find the attached patch to fix below RMs.
>>>
>>> 1. #4742 - Primary Key Dialog: Can not create Primary key with Index
>>> 2. #4624 - Add RE-SQL/MSQL test cases for Primary Keys
>>>
>>> Thanks,
>>> Khushboo
>>>
>>
>>
>> --
>> *Thanks & Regards*
>> *Akshay Joshi*
>>
>> *Sr. Software Architect*
>> *EnterpriseDB Software India Private Limited*
>> *Mobile: +91 976-788-8246*
>>
>

--
*Thanks & Regards*
*Akshay Joshi*

*Sr. Software Architect*
*EnterpriseDB Software India Private Limited*
*Mobile: +91 976-788-8246*

In response to

Browse pgadmin-hackers by date

  From Date Subject
Next Message Neel Patel 2019-09-16 06:44:13 Re: [pgAdmin][RM4642] port should not be mandatory when a service is provided
Previous Message Akshay Joshi 2019-09-16 06:37:07 pgAdmin 4 commit: 1) Add Reverse Engineered and Modified SQL tests for