Sorry, I apologize for the mistake. %20 is the space, and the extra %12
seems to be DC3 (device control 3).
Regards,
Ben Kim
On Mon, 8 Sep 2008, Ben Kim wrote:
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
yuval_sofer@xxxxxxx
--
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
