A few issues with pgAdmin4 Query Tool - Mailing list pgadmin-support

From Jack Royal-Gordon
Subject A few issues with pgAdmin4 Query Tool
Date
Msg-id 62F325B9-D335-4289-9E61-7777BEEDBEF2@pobox.com
Whole thread Raw
List pgadmin-support
<div class="">Not sure whether these issues are unique to the OS X version, but I tried it with  Beta-1, Beta-3, and
Beta-4of pgAdmin4.</div><div class=""><br class="" /></div>1) Copy and Paste can only be accessed via the context menu
(whenediting the query command). The icons are disabled and the usual shortcut keys (cmd-c, cmd-x, cmd-v) do not work
(nordo any variants such as ctrl-c).<div class=""><br class="" /></div><div class=""><div class="">2) Auto-complete
(ctrl-space)inserts a space and does not invoke auto-complete.<div class=""><br class="" /></div><div class="">3)
Misspelledfield name in SQL command does not give error when command executed. It just quickly flashes the “Waiting for
queryexecution” message and gives no message. Also happens with all variants of Execute, including Explain.<br class=""
/><divclass=""><br class="" /></div><div class="">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
highestID, last page ends with the next ID after the last one on the first page. Note that output appears in the
correctorder with pgAdminIII.</div><div class=""><br class="" /></div><div class=""><span class="Apple-tab-span"
style="white-space:pre"></span>Full SQL Command:</div><div class=""><span class="Apple-tab-span"
style="white-space:pre"></span>select * from logs where distributor_id = 7 and task = 'Sales' and process_id not like
'scheduler%'and created_at > '8/25/16 17:00’ </div><div class=""><span class="Apple-tab-span"
style="white-space:pre"></span>and message not like '%invalid byte%' order by id</div></div></div><div class=""><br
class=""/></div><div class=""><span class="Apple-tab-span" style="white-space: pre;"> </span>Page 1: <span
class="Apple-tab-span"style="white-space: pre;"> </span><span class="" style="color: rgb(51, 51, 51); font-family:
'HelveticaNeue', Helvetica, Arial, sans-serif; text-align: right; white-space: pre-wrap; background-color: rgb(241,
241,241);">333,261,528</span></div></div><div class=""><span class="" style="color: rgb(51, 51, 51); font-family:
'HelveticaNeue', Helvetica, Arial, sans-serif; text-align: right; white-space: pre-wrap; background-color: rgb(241,
241,241);"><span class="Apple-tab-span" style="white-space: pre;"> </span></span><font class="" color="#333333"
face="HelveticaNeue, Helvetica, Arial, sans-serif"><span class="" style="white-space:
pre-wrap;">…</span></font></div><divclass=""><span class="" style="color: rgb(51, 51, 51); font-family: 'Helvetica
Neue',Helvetica, Arial, sans-serif; text-align: right; white-space: pre-wrap; background-color: rgb(241, 241,
241);"><spanclass="Apple-tab-span" style="white-space: pre;"> </span></span><span class="" style="color: rgb(51, 51,
51);font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; text-align: right; white-space: pre-wrap;
background-color:rgb(241, 241, 241);">333,261,969</span></div><div class=""><span class="" style="color: rgb(51, 51,
51);font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; text-align: right; white-space: pre-wrap;
background-color:rgb(241, 241, 241);"><br class="" /></span></div><div class=""><span class="" style="color: rgb(51,
51,51); font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; text-align: right; white-space: pre-wrap;
background-color:rgb(241, 241, 241);"><span class="Apple-tab-span" style="white-space: pre;"> </span>Page 2:<span
class="Apple-tab-span"style="white-space: pre;"> </span></span><span class="" style="color: rgb(51, 51, 51);
font-family:'Helvetica Neue', Helvetica, Arial, sans-serif; text-align: right; white-space: pre-wrap; background-color:
rgb(241,241, 241);">333,264,500</span></div><div class=""><span class="" style="color: rgb(51, 51, 51); font-family:
'HelveticaNeue', Helvetica, Arial, sans-serif; text-align: right; white-space: pre-wrap; background-color: rgb(241,
241,241);"><span class="Apple-tab-span" style="white-space: pre;"> </span></span><font class="" color="#333333"
face="HelveticaNeue, Helvetica, Arial, sans-serif"><span class="" style="white-space:
pre-wrap;">…</span></font></div><divclass=""><span class="" style="color: rgb(51, 51, 51); font-family: 'Helvetica
Neue',Helvetica, Arial, sans-serif; text-align: right; white-space: pre-wrap; background-color: rgb(241, 241,
241);"><spanclass="Apple-tab-span" style="white-space: pre;"> </span></span><span class="" style="color: rgb(51, 51,
51);font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; text-align: right; white-space: pre-wrap;
background-color:rgb(241, 241, 241);">333,264,417</span></div><div class=""><span class="" style="color: rgb(51, 51,
51);font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; white-space: pre-wrap; text-align: right;"><span
class="Apple-tab-span"style="white-space:pre"> </span>…</span></div><div class=""><br class="" /></div><div
class=""><spanclass="Apple-tab-span" style="white-space: pre;"> </span>Page 10:<span class="Apple-tab-span"
style="white-space:pre;"> </span><span class="" style="color: rgb(51, 51, 51); font-family: 'Helvetica Neue',
Helvetica,Arial, sans-serif; text-align: right; white-space: pre-wrap; background-color: rgb(241, 241,
241);">333,262,013</span></div><divclass=""><span class="Apple-tab-span" style="white-space: pre;"> </span>…</div><div
class=""><spanclass="Apple-tab-span" style="white-space: pre;"> </span><span class="" style="color: rgb(51, 51, 51);
font-family:'Helvetica Neue', Helvetica, Arial, sans-serif; text-align: right; white-space: pre-wrap; background-color:
rgb(241,241, 241);">333,261,974</span></div><div class=""><span class="" style="color: rgb(51, 51, 51); font-family:
'HelveticaNeue', Helvetica, Arial, sans-serif; text-align: right; white-space: pre-wrap; background-color: rgb(241,
241,241);"><br class="" /></span></div><div class="" style="text-align: right;"><br class="" /></div> 

pgadmin-support by date:

Previous
From: "Jon Raiford/Employee/LW-US"
Date:
Subject: pgAdmin3 server status blank
Next
From: Jack Royal-Gordon
Date:
Subject: Unable to get pgAdmin4 to connect to local database