problem with pg_stat_activity view - Mailing list pgsql-sql

<div class="Section1"><p class="MsoNormal"><font color="navy" face="Arial" size="3"><span style="font-size:
12.0pt;font-family:Arial;color:navy">Hello,</span></font><p class="MsoNormal"><font color="navy" face="Arial"
size="3"><spanstyle="font-size: 
12.0pt;font-family:Arial;color:navy"> </span></font><p class="MsoNormal"><font color="navy" face="Arial" size="3"><span
style="font-size:
12.0pt;font-family:Arial;color:navy">postgres version:  8.2.0.4</span></font><p class="MsoNormal"><font color="navy"
face="Arial"size="3"><span style="font-size: 
12.0pt;font-family:Arial;color:navy">platform windows: server 2008</span></font><p class="MsoNormal"><font color="navy"
face="Arial"size="3"><span style="font-size: 
12.0pt;font-family:Arial;color:navy"> </span></font><p class="MsoNormal"><font color="navy" face="Arial" size="3"><span
style="font-size:
12.0pt;font-family:Arial;color:navy">I check connections using: </span></font><p class="MsoNormal"><font color="navy"
face="Arial"size="3"><span style="font-size: 
12.0pt;font-family:Arial;color:navy"> </span></font><p class="MsoNormal"><font color="navy" face="Arial" size="3"><span
style="font-size:
12.0pt;font-family:Arial;color:navy">SELECT pg_stat_get_backend_idset()</span></font><p class="MsoNormal"><font
color="navy"face="Arial" size="3"><span style="font-size: 
12.0pt;font-family:Arial;color:navy"> </span></font><p class="MsoNormal"><font color="navy" face="Arial" size="3"><span
style="font-size:
12.0pt;font-family:Arial;color:navy">Now, I take the output and try to get the ip addresses using </span></font><p
class="MsoNormal"><fontcolor="navy" face="Arial" size="3"><span style="font-size: 
12.0pt;font-family:Arial;color:navy"> </span></font><p class="MsoNormal"><font color="navy" face="Arial" size="3"><span
style="font-size:
12.0pt;font-family:Arial;color:navy">select pg_stat_get_backend_client_addr(<integer>);</span></font><p
class="MsoNormal"><fontcolor="navy" face="Arial" size="3"><span style="font-size: 
12.0pt;font-family:Arial;color:navy"> </span></font><p class="MsoNormal"><font color="navy" face="Arial" size="3"><span
style="font-size:
12.0pt;font-family:Arial;color:navy">but for a local connection (simple login using psql), I get the next error:
</span></font><pclass="MsoNormal"><font color="navy" face="Arial" size="3"><span style="font-size: 
12.0pt;font-family:Arial;color:navy"> </span></font><p class="MsoNormal"><font color="navy" face="Arial" size="3"><span
style="font-size:
12.0pt;font-family:Arial;color:navy">ERROR:  invalid input syntax for type inet:
"fe80::104d:416e:a8dc:c02e%12"</span></font><pclass="MsoNormal"><font color="navy" face="Arial" size="3"><span
style="font-size:
12.0pt;font-family:Arial;color:navy">SQL state: 22P02</span></font><p class="MsoNormal"><font color="navy" face="Arial"
size="3"><spanstyle="font-size: 
12.0pt;font-family:Arial;color:navy"> </span></font><p class="MsoNormal"><font color="navy" face="Arial" size="3"><span
style="font-size:
12.0pt;font-family:Arial;color:navy">The same error occurs for simple “select * pg_stat_activity” (of course, as it is
basedon the former function)</span></font><p class="MsoNormal"><font color="navy" face="Arial" size="3"><span
style="font-size:
12.0pt;font-family:Arial;color:navy"> </span></font><p class="MsoNormal"><font color="navy" face="Arial" size="3"><span
style="font-size:
12.0pt;font-family:Arial;color:navy">I noticed that for netstat –r –n, I got the next line (among the
others):</span></font><pclass="MsoNormal"><font color="navy" face="Arial" size="3"><span style="font-size: 
12.0pt;font-family:Arial;color:navy"> </span></font><p class="MsoNormal"><font color="navy" face="Arial" size="3"><span
style="font-size:
12.0pt;font-family:Arial;color:navy">12    266 fe80::104d:416e:a8dc:c02e/128</span></font><p class="MsoNormal"><font
color="navy"face="Arial" size="3"><span style="font-size: 
12.0pt;font-family:Arial;color:navy"> </span></font><p class="MsoNormal"><font color="navy" face="Arial" size="3"><span
style="font-size:
12.0pt;font-family:Arial;color:navy">May the last 8 was removed and therefore the ip became illegal ? </span></font><p
class="MsoNormal"><fontcolor="navy" face="Arial" size="3"><span style="font-size: 
12.0pt;font-family:Arial;color:navy"> </span></font><p class="MsoNormal"><font color="navy" face="Arial" size="3"><span
style="font-size:
12.0pt;font-family:Arial;color:navy">Need your help </span></font><p class="MsoNormal"><font color="navy" face="Arial"
size="3"><spanstyle="font-size: 
12.0pt;font-family:Arial;color:navy"> </span></font><p class="MsoNormal"><font color="navy" face="Arial" size="3"><span
style="font-size:
12.0pt;font-family:Arial;color:navy">Thanks, </span></font><p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size:10.0pt;
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">Yuval Sofer<br /> BMC Software<br /> CTM&D Business Unit</span></font><p class="MsoNormal"><font
face="Arial"size="2"><span style="font-size:10.0pt; 
font-family:Arial">DBA Team<br /> 972-52-4286-282<br /><a
href="mailto:yuval_sofer@bmc.com">yuval_sofer@bmc.com</a></span></font><pclass="MsoNormal"><font face="Times New Roman"
size="3"><spanstyle="font-size: 
12.0pt"> </span></font></div>