From: | navnath gadakh <navnath(dot)gadakh(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: [pgAdmin][RM5157] Default sort order at start in view table data by primary key by default |
Date: | 2020-04-20 15:46:20 |
Message-ID: | CAOAJCYo4UwDUR4GbR5jZ=nT1mTmMx46xgffFm0VyZDyZ6btuUw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-hackers |
Hi Khushboo,
I have modified the code as per review comments. Please review the
attached patch file.
Thanks!
On Mon, Apr 20, 2020 at 10:56 AM Khushboo Vashi <
khushboo(dot)vashi(at)enterprisedb(dot)com> wrote:
> Hi Navnath,
>
> Review comments:
>
> 1. If we have multiple Primary keys, then we should include all the keys
> into the Order by clause.
> 2. In the Preferences dialog, please put this option in the Query Tool >
> Options instead of Result Grid and also change the Label.
> 3. Please optimize the code, as I can see objectname.sql file is being
> used in else condition also, which is not required. Based on the parameter
> setting, Just one call of that sql is enough.
>
> Thanks,
> Khushboo
>
>
> On Fri, Apr 17, 2020 at 6:43 PM navnath gadakh <
> navnath(dot)gadakh(at)enterprisedb(dot)com> wrote:
>
>> Hello Hackers,
>>
>> Please find the modified patch with an option in Preferences for data
>> sorting by the primary key. Also, the previous patch was not working with
>> table has no primary key.
>>
>> Thanks!
>>
>>
>>
>>
>> On Thu, Apr 16, 2020 at 5:01 PM Dave Page <dave(dot)page(at)enterprisedb(dot)com>
>> wrote:
>>
>>>
>>>
>>> On Thu, Apr 16, 2020 at 12:08 PM navnath gadakh <
>>> navnath(dot)gadakh(at)enterprisedb(dot)com> wrote:
>>>
>>>> Hi Dave/Team,
>>>> This patch is related to the default sort order for the view
>>>> table data. In pgAdminIII default ordering is by primary key and this is
>>>> not working in pgAdminIV.
>>>> I have attached the patch with the back end code.
>>>>
>>>> Please review it.
>>>>
>>>> *Question*: There is one suggestion on
>>>> https://redmine.postgresql.org/issues/5157 about to put a checkbox in
>>>> the configuration for this behavior.
>>>> Do I need to implement that really? I yes, Is
>>>> preferences a good place for that? / Suggestions?
>>>>
>>>
>>> I think we should make this optional, and yes, Preferences is a good
>>> place. The reason is that sorting data is not without cost - at the very
>>> least it will require use of an index to access what may be the whole table.
>>>
>>> --
>>> Dave Page
>>> VP & Chief Architect, Database Infrastructure
>>> EnterpriseDB: http://www.enterprisedb.com
>>> The Enterprise PostgreSQL Company
>>>
>>> Blog: http://pgsnake.blogspot.com
>>> Twitter: @pgsnake
>>>
>>
>>
>> --
>> Regards,
>> Navnath Gadakh
>>
>
--
Regards,
Navnath Gadakh
Attachment | Content-Type | Size |
---|---|---|
RM-5157_v3.patch | application/octet-stream | 7.5 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | navnath gadakh | 2020-04-21 04:42:56 | Re: [pgAdmin][RM5157] Default sort order at start in view table data by primary key by default |
Previous Message | Yogesh Jain | 2020-04-20 14:35:32 | [pgAdmin][RM5352] : Rightmost & Bottom tooltip crop issues in Explain Query Plan |