Curious record sorting in pgadmin4

From: Colin Beckingham <colbec(at)kingston(dot)net>
To: pgadmin-hackers <pgadmin-hackers(at)postgresql(dot)org>
Subject: Curious record sorting in pgadmin4
Date: 2016-06-30 07:37:00
Message-ID: 5774CC1C.6050703@kingston.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-hackers

On openSUSE Leap 42.1 using very latest pgadmin4 version using git pull,
when I open a database, select a table and use the default view data all
records I observe a very curious effect. With SQL such as select * order
by ID ascending, when the output is paged across more than one set of 50
records I see the first page correctly sorted on the primary key
ascending, then page/tab 2 has the records sorted on primary key
descending starting at the last record, and subsequent pages are also
sorted descending starting from last ID less 50. This seems to happen
with long or short data sets as long as the cardinality is > 50.

Also, primary key integers are formatted with a comma when > 999. This
may be correct but looks odd for some reason and may incur some
internationalization overhead.

Browse pgadmin-hackers by date

  From Date Subject
Next Message Dave Page 2016-06-30 07:51:13 Re: PATCH: to fix jsonb type rendering in runtime (pgAdmin4)
Previous Message Murtuza Zabuawala 2016-06-30 07:11:40 Re: PATCH: to fix jsonb type rendering in runtime (pgAdmin4)