From: | "Temp key: basic, via spamcop" <pgadmin-gts(at)snkmail(dot)com> |
---|---|
To: | pgadmin-support(at)postgresql(dot)org |
Subject: | Re: [pgAdmin4] Invalid field order in "Data Output" |
Date: | 2016-08-14 04:29:47 |
Message-ID: | 10069-1471149027-359109@sneakemail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
On 8/12/16 at 7:51 AM, Krzysztof Otręba wrote:
>Hi,
>
>When I execute query like this:
>
>SELECT generate_series(0, 999)
>ORDER BY 1 ASC;
>
>On first page I see rows 0-49, on second page 999-950 descending!,
>last - 99-50 descending!
>
>Should be:
>- first page 0-49
>- second 50-99
>- next 100-149
>- etc.
>- page number 20: 950-999
>
>Tested on:
>- Fedora 24 x64 (commit 035066bd; Tue, 9 Aug 2016 15:23:24),
>PostgreSQL 9.2, 9.3, 9.5
>- Windows 7 x64; Pgadmin4 1.0-beta3; PostgreSQL 9.6beta4
>
>
>Regards,
>Krzysztof Otręba
>
>
Ditto, and similar ordering problems also happen when the
underlying field type is text derived from a table as opposed to
a generated numeric sequence.
PostgreSQL 9.4.5 on x86_64-apple-darwin
OSX 10.11.6
Regards
Gavan Schneider
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 2016-08-15 09:01:47 | Re: funny that pgadmin4-1.0-beta3-x86.exe even cann't connect to greenplumb db |
Previous Message | Krzysztof O | 2016-08-12 21:51:42 | [pgAdmin4] Invalid field order in "Data Output" |