Re: PATCH: improve sorting in the Data Editor - Mailing list pgadmin-hackers

From Ashesh Vashi
Subject Re: PATCH: improve sorting in the Data Editor
Date
Msg-id CAG7mmoxo9xkeo7qpgaifTMcQbVPJuz=KcZD9yr6gz9=HV4m95Q@mail.gmail.com
Whole thread Raw
In response to PATCH: improve sorting in the Data Editor  ("J.F. Oster" <jinfroster@mail.ru>)
Responses Re: PATCH: improve sorting in the Data Editor
List pgadmin-hackers
Sanket,

Can you please review it?


--

Thanks & Regards,

Ashesh Vashi
EnterpriseDB INDIA: Enterprise PostgreSQL Company


http://www.linkedin.com/in/asheshvashi


On Sun, Aug 2, 2015 at 3:49 PM, J.F. Oster <jinfroster@mail.ru> wrote:
Hello,

Here is a small improvement about sorting in the Data editor.

Problem:
If a table has a PK or OIDs, it gets sorted by PK/OID by default.
When a user wants to sort by any other column, he has first to click
"Remove sort" in the context menu, and only then click "Sort
ascending"(descending) on column of his choice.

If he doesn't remove the default sort, he will get no effect and
probably be puzzled for the first time until guesses that he makes
  ORDER BY column_pk, column_of_choice
which is totally useless.
The need to "Remove sort" each time is annoying.

Solution:
When a user chooses to sort by some column, we must discard the
default sort order.

Please see the attached patch.
Thanks.

--
Best regards,
 J.F.


--
Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers


pgadmin-hackers by date:

Previous
From: "J.F. Oster"
Date:
Subject: PATCH: improve sorting in the Data Editor
Next
From: Sanket Mehta
Date:
Subject: Re: PATCH: improve sorting in the Data Editor