fe80::104d:416e:a8dc:c02e %12
Since %12 is a "space" character, it seems first thing to do might be an extra space in your code. Just a quick guess.
Regards, Ben Kim On Mon, 8 Sep 2008, Sofer, Yuval wrote:
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 [EMAIL PROTECTED]
-- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
