A few issues with pgAdmin4 Query Tool

От:

Jack Royal-Gordon <jackrg@pobox.com>

Дата:

25 августа 2016 г. в 22:43:58

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