Re: PATCH: improve sorting in the Data Editor - Mailing 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