A few issues with pgAdmin4 Query Tool

Поиск
Список
Период
Сортировка
От Jack Royal-Gordon
Тема A few issues with pgAdmin4 Query Tool
Дата
Msg-id 62F325B9-D335-4289-9E61-7777BEEDBEF2@pobox.com
обсуждение исходный текст
Список 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 по дате отправления:

Предыдущее
От: "Jon Raiford/Employee/LW-US"
Дата:
Сообщение: pgAdmin3 server status blank
Следующее
От: Jack Royal-Gordon
Дата:
Сообщение: Unable to get pgAdmin4 to connect to local database