Received: from localhost (unknown [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id 8FA0364FD14
	for <pgsql-admin-postgresql.org@postgresql.org>;
	Mon,  8 Sep 2008 10:37:47 -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 23408-04 for <pgsql-admin-postgresql.org@postgresql.org>;
	Mon,  8 Sep 2008 10:37:40 -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 2E15964FCED
	for <pgsql-admin@postgresql.org>; Mon,  8 Sep 2008 10:37:37 -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 m88DbZF09921;
	Mon, 8 Sep 2008 08:37:35 -0500 (CDT)
Date: Mon, 8 Sep 2008 08:37:35 -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: <Pine.GSO.4.64.0809080824320.9078@coe.tamu.edu>
Message-ID: <Pine.GSO.4.64.0809080833290.9078@coe.tamu.edu>
References: 
 <BE67D1149BBD5746984545ED91F702E001F43035@hou-ex-02.adprod.bmc.com>
	<Pine.GSO.4.64.0809080824320.9078@coe.tamu.edu>
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/66
X-Sequence-Number: 30159


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@bmc.com
>> 
>> 
>> 
>> 
>
> -- 
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>