Re: [SQL] problem with pg_stat_activity view

2008-09-08 Thread Tom Lane
"Sofer, Yuval" <[EMAIL PROTECTED]> writes: > postgres version: 8.2.0.4 > ERROR: invalid input syntax for type inet: > "fe80::104d:416e:a8dc:c02e%12" This is fixed in 8.2.5 and later. regards, tom lane -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To ma

[SQL] problem with pg_stat_activity view

2008-09-08 Thread Sofer, Yuval
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(); but for a local connection (simple login us