problem with pg_stat_activity view

["Sofer, Yuval" <Yuval_Sofer@xxxxxxx>]

Hello,

 

postgres version:  8.2.0.4

platform windows: server 2008

 

I check connections using:

 

SELECT pg_stat_get_backend_idset()

 

Now, I take the output and try to get the ip addresses using

 

select pg_stat_get_backend_client_addr(<integer>);

 

but for a local connection (simple login using psql), I get the next error:

 

ERROR:  invalid input syntax for type inet: "fe80::104d:416e:a8dc:c02e%12"

SQL state: 22P02

 

The same error occurs for simple “select * pg_stat_activity” (of course, as it is based on the former function)

 

I noticed that for netstat –r –n, I got the next line (among the others):

 

12    266 fe80::104d:416e:a8dc:c02e/128

 

May the last 8 was removed and therefore the ip became illegal ?

 

Need your help

 

Thanks,

 

Yuval Sofer
BMC Software
CTM&D Business Unit

DBA Team
972-52-4286-282
yuval_sofer@xxxxxxx