Received: from localhost (unknown [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id 25D596500B0
	for <pgsql-admin-postgresql.org@postgresql.org>;
	Mon,  8 Sep 2008 10:27:17 -0300 (ADT)
Received: from postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 21425-08 for <pgsql-admin-postgresql.org@postgresql.org>;
	Mon,  8 Sep 2008 10:27:12 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from coe.tamu.edu (edsun.coe.tamu.edu [165.91.232.6])
	by postgresql.org (Postfix) with ESMTP id CDC2264FD14
	for <pgsql-admin@postgresql.org>; Mon,  8 Sep 2008 10:27:10 -0300 (ADT)
Received: from coe.tamu.edu (coe.tamu.edu [165.91.232.6])
	by coe.tamu.edu (8.11.7p3+Sun/8.12.11) with ESMTP id m88DR7F09438;
	Mon, 8 Sep 2008 08:27:07 -0500 (CDT)
Date: Mon, 8 Sep 2008 08:27:06 -0500 (CDT)
From: Ben Kim <bkim@tamu.edu>
To: "Sofer, Yuval" <Yuval_Sofer@bmc.com>
cc: pgsql-admin@postgresql.org, "Abraham, Danny" <danny_abraham@bmc.com>
Subject: Re: problem with pg_stat_activity view
In-Reply-To: 
 <BE67D1149BBD5746984545ED91F702E001F43035@hou-ex-02.adprod.bmc.com>
Message-ID: <Pine.GSO.4.64.0809080824320.9078@coe.tamu.edu>
References: 
 <BE67D1149BBD5746984545ED91F702E001F43035@hou-ex-02.adprod.bmc.com>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none
X-Spam-Level: 
X-Archive-Number: 200809/65
X-Sequence-Number: 30158


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@bmc.com
>
>
>
>