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: