Обсуждение: pgAdmin 4 1.1, query error while browsing columns

Working with pgAdmin 4 1.1 on Mac 10.11.5<br /><br /> I connected to a postgres 9.1 database and I'm just clicking
aroundlooking at individual columns in the tree within:<br /> db<br />   schema<br />      table<br />         col1<br
/>        col2<br />         ..etc..<br /><br /> If I click on 'col1', I get this:<br /><br /><span style="color:
rgb(0,0, 0); font-family: Roboto, sans-serif;     font-size: 14px; font-style: normal; font-variant: normal;
font-weight:normal; letter-spacing: normal; line-height: 20px;     orphans: auto; text-align: start; text-indent: 0px;
  text-transform: none; white-space: normal; widows: auto;     word-spacing: 0px; -webkit-text-stroke-width: 0px;
background-color:rgb(255, 255, 255); display: inline !important;     float: none;">ERROR: syntax error at or near
"WHERE"</span><brstyle="box-sizing: border-box; color: rgb(0, 0, 0); font-family:     Roboto, sans-serif; font-size:
14px;font-style: normal;     font-variant: normal; font-weight: normal; letter-spacing: normal;     line-height: 20px;
orphans:auto; text-align: start; text-indent:     0px; text-transform: none; white-space: normal; widows: auto;
word-spacing:0px; -webkit-text-stroke-width: 0px;     background-color: rgb(255, 255, 255);" /><span style="color:
rgb(0,0, 0); font-family: Roboto, sans-serif;     font-size: 14px; font-style: normal; font-variant: normal;
font-weight:normal; letter-spacing: normal; line-height: 20px;     orphans: auto; text-align: start; text-indent: 0px;
  text-transform: none; white-space: normal; widows: auto;     word-spacing: 0px; -webkit-text-stroke-width: 0px;
background-color:rgb(255, 255, 255); display: inline !important;     float: none;">LINE 21: ...ider || '=' || label)
FROMpg_seclabels sl1 WHERE WHERE sl1....</span><br style="box-sizing: border-box;     color: rgb(0, 0, 0); font-family:
Roboto,sans-serif; font-size:     14px; font-style: normal; font-variant: normal; font-weight:     normal;
letter-spacing:normal; line-height: 20px; orphans: auto;     text-align: start; text-indent: 0px; text-transform: none;
   white-space: normal; widows: auto; word-spacing: 0px;     -webkit-text-stroke-width: 0px; background-color: rgb(255,
255,    255);" /><span style="color: rgb(0, 0, 0); font-family: Roboto, sans-serif;     font-size: 14px; font-style:
normal;font-variant: normal;     font-weight: normal; letter-spacing: normal; line-height: 20px;     orphans: auto;
text-align:start; text-indent: 0px;     text-transform: none; white-space: normal; widows: auto;     word-spacing: 0px;
-webkit-text-stroke-width:0px;     background-color: rgb(255, 255, 255); display: inline !important;     float:
none;">^</span><br/> 

Hi,

pgAdmin 4 supports PostgreSql 9.2 and above.  I guess that’s the problem.

Regards,

Ben

On 2 Nov 2016, at 14:43, Mark Murawski <markm-lists@intellasoft.net> wrote:

Working with pgAdmin 4 1.1 on Mac 10.11.5

I connected to a postgres 9.1 database and I'm just clicking around looking at individual columns in the tree within:
db
  schema
     table
        col1
        col2
        ..etc..

If I click on 'col1', I get this:

ERROR: syntax error at or near "WHERE"
LINE 21: ...ider || '=' || label) FROM pg_seclabels sl1 WHERE WHERE sl1....
^