A few issues with pgAdmin4 Query Tool

From: Jack Royal-Gordon <jackrg(at)pobox(dot)com>
To: pgadmin-support(at)postgresql(dot)org
Subject: A few issues with pgAdmin4 Query Tool
Date: 2016-08-25 22:43:52
Message-ID: 62F325B9-D335-4289-9E61-7777BEEDBEF2@pobox.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Not sure whether these issues are unique to the OS X version, but I tried it with Beta-1, Beta-3, and Beta-4 of pgAdmin4.

1) Copy and Paste can only be accessed via the context menu (when editing the query command). The icons are disabled and the usual shortcut keys (cmd-c, cmd-x, cmd-v) do not work (nor do any variants such as ctrl-c).

2) Auto-complete (ctrl-space) inserts a space and does not invoke auto-complete.

3) Misspelled field name in SQL command does not give error when command executed. It just quickly flashes the “Waiting for query execution” message and gives no message. Also happens with all variants of Execute, including Explain.

4) SQL command with “ORDER BY” clause does not display in the correct order. First page appears in correct order, all successive pages appear in reverse order (second page starts with the highest ID, last page ends with the next ID after the last one on the first page. Note that output appears in the correct order with pgAdminIII.

Full SQL Command:
select * from logs where distributor_id = 7 and task = 'Sales' and process_id not like 'scheduler%' and created_at > '8/25/16 17:00’
and message not like '%invalid byte%' order by id

Page 1: 333,261,528

333,261,969

Page 2: 333,264,500

333,264,417

Page 10: 333,262,013

333,261,974

Browse pgadmin-support by date

  From Date Subject
Next Message Jack Royal-Gordon 2016-08-25 22:59:16 Unable to get pgAdmin4 to connect to local database
Previous Message Jon Raiford/Employee/LW-US 2016-08-25 14:27:31 pgAdmin3 server status blank