Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1dB0Ki-00069u-Ce for pgadmin-hackers@arkaria.postgresql.org; Wed, 17 May 2017 14:53:48 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1dB0Kh-0004Gp-Vj for pgadmin-hackers@arkaria.postgresql.org; Wed, 17 May 2017 14:53:48 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1dB0KT-0003iD-6l for pgadmin-hackers@postgresql.org; Wed, 17 May 2017 14:53:33 +0000 Received: from mail-it0-x234.google.com ([2607:f8b0:4001:c0b::234]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1dB0KQ-0003Nf-7i for pgadmin-hackers@postgresql.org; Wed, 17 May 2017 14:53:32 +0000 Received: by mail-it0-x234.google.com with SMTP id c15so82713196ith.0 for ; Wed, 17 May 2017 07:53:29 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=pgadmin-org.20150623.gappssmtp.com; s=20150623; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :cc; bh=dTS+uQr2fddiotrmuomH3vk4qPCkj3SLVC15tqeIurY=; b=QsrsFLBZOd1H7Wj8BRSuQKBlddZeUn+wdzfWHuxe7QSYV10ohQn4eSJUAShilQMpdi AYkdaEuTdIDZYzQpNOKyNKC9lmThDDRwdrmuCGUvXBlpowYqkKn5ARKOwX13YGPqfi3L wnOqJZhfILWbp6RFpYN6s/zN0QAuPQBJ26VlxMkRDD48j4IBf99JVYim0X7BioaOxiTh Ic0gjRSXPQMqyxiIkxzLu+B7u8BMriMpxY2azKwanGhpIkZ+2beDR9FsiUslZj0+1pyZ B2V06+f0i0ereJfT7KeoFCTQ8XDi2uPc6lV/WlSLZ0ns0S5ZWUqe+/o7pyKVb6Qi7RxT dNrQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:in-reply-to:references:from:date :message-id:subject:to:cc; bh=dTS+uQr2fddiotrmuomH3vk4qPCkj3SLVC15tqeIurY=; b=JiWMsPaxCNHx0x+UCwrnuydPZgYwAvlLSCkhCi+qio/w2FppfiAN0n8Jh8WzH6TbDT KeR+bWhjYytIkAv2Y8uhxfNWOv/8rOAlCgWIusBSmncZdbeUgJ/+59eMQFYCMlqGhU4R OJO9SV+eXTTPn7TNmHgrOi16L4NPnuQRTgf5VqHgGInXCoaFaMSte87AOwl+sUo/saiq xwr6nkE2Fs/NUfZtH8DROCUD3VR2HJlY0j2lx118o+RZ9J4L0lii3jXIZP1peft1U54i qz1kqsIaXJxCsQ70ii0W7ldCS32hbQPNf+KfrNtrSEF+22hCcow/oEcUVbque5QwUYbI gExA== X-Gm-Message-State: AODbwcDLNJutcXqTdzZ+UKznbFYxLp3fyPjtvDSQ9Y87bGFiYE5N6dvj Cp52kMjWfK24C7QbvoAl2lEjxjQIYJlW X-Received: by 10.36.31.74 with SMTP id d71mr4309430itd.85.1495032809122; Wed, 17 May 2017 07:53:29 -0700 (PDT) MIME-Version: 1.0 Received: by 10.107.174.147 with HTTP; Wed, 17 May 2017 07:53:28 -0700 (PDT) In-Reply-To: References: From: Dave Page Date: Wed, 17 May 2017 15:53:28 +0100 Message-ID: Subject: Re: [pgAdmin4][PATCH] To fix the issue in server stats sql (PPAS9.2) To: Murtuza Zabuawala Cc: pgadmin-hackers Content-Type: multipart/alternative; boundary="001a1145ecc68426d5054fb97343" X-Pg-Spam-Score: -2.6 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgadmin-hackers Precedence: bulk Sender: pgadmin-hackers-owner@postgresql.org --001a1145ecc68426d5054fb97343 Content-Type: text/plain; charset="UTF-8" Thanks - patch applied. On Tue, May 16, 2017 at 4:43 PM, Murtuza Zabuawala < murtuza.zabuawala@enterprisedb.com> wrote: > Hi, > > PFA minor patch to fix the in server stats sql where it was fails to > execute because it is not able to concat inet (type) when using with || > operator. > > *Fails:* > select client_addr || ':' || client_port from pg_stat_activity > > *Works:* > select client_addr::text || ':' || client_port from pg_stat_activity > > Fixes RM#1831 > > -- > Regards, > Murtuza Zabuawala > EnterpriseDB: http://www.enterprisedb.com > The Enterprise PostgreSQL Company > > > -- > Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgadmin-hackers > > -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company --001a1145ecc68426d5054fb97343 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Thanks - patch applied.
On Tue, May 16, 2017 at 4:43 PM, Murtuza Zabua= wala <murtuza.zabuawala@enterprisedb.com> w= rote:
Hi,

=
PFA minor patch to fix the in server stats sql where it was fails to e= xecute because it is not able to concat inet (type) when using with || oper= ator.

Fails:
select client_addr |= | ':' || client_port from pg_stat_activity

=
Works:
select client_addr::text || ':' || cli= ent_port from pg_stat_activity

Fixes RM#1831

--
Regards,
Murtuza Zabuawala
<= span style=3D"color:rgb(136,136,136)">EnterpriseDB:=C2=A0http://www.enterprisedb.com
The Enterprise = PostgreSQL Company


--
Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-ha= ckers




--
--001a1145ecc68426d5054fb97343--