Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1dAedM-0003w4-6f for pgadmin-hackers@arkaria.postgresql.org; Tue, 16 May 2017 15:43:36 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1dAedL-0006w0-No for pgadmin-hackers@arkaria.postgresql.org; Tue, 16 May 2017 15:43:35 +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 1dAedL-0006vr-7w for pgadmin-hackers@postgresql.org; Tue, 16 May 2017 15:43:35 +0000 Received: from mail-wm0-x22e.google.com ([2a00:1450:400c:c09::22e]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1dAedH-0002G2-VA for pgadmin-hackers@postgresql.org; Tue, 16 May 2017 15:43:33 +0000 Received: by mail-wm0-x22e.google.com with SMTP id d127so125020703wmf.0 for ; Tue, 16 May 2017 08:43:31 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=enterprisedb-com.20150623.gappssmtp.com; s=20150623; h=mime-version:from:date:message-id:subject:to; bh=b/9+v1e1d5dfmLs2tMdhPiLbR01HVNUCiFzqzKQPrwI=; b=XiCiG/9hsNYhR8aVVh5ngIGJqIHzBICBOnnPkryoxO9+an2JtFg7LnxGC+dEwkDlED 7ByAQqVI97QFYc0tsFa1piNAcjAd2bXT1lM7BLPfKByqhtbLSJJ+Liw9mwLWgQweSe8V W3wAV4ZUkZm1cIwKbuw7mtjj0wPkx6h7hjXLx+ZZQNXMVAeq0z9HY7utK0Z9EEXqlwRn o1AMukeRkPTnXy2t7wpN169UqC6FIkcUlo7Ol6utB3R+l2QK99mnHg36ZILHrN3HB7bb vfTchdSvzq2GpV0r28kf8yfEve/j2ysZslFrdmOc4azy3nPpi2tKpJyxXSgDgXPX++xb ybpg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:from:date:message-id:subject:to; bh=b/9+v1e1d5dfmLs2tMdhPiLbR01HVNUCiFzqzKQPrwI=; b=J/5fHhMC25gtH+u1dBM5Cbw7azvQD5T2YgnER9RwuCjcRvWkKs8PK2gO2LB0fFqq/R D9tiuS65IVMMrB+1t+Z8XzM9dQz1q1dHHmZqsJnaNmN/mzibvk0CssGVErFNLcLspxFK O3VupHUTmeI/RZfeI20bk/C1xES7sXn3SjTN68GuU7MP5y+ZZAewK7RkhXeKCKEhjz/9 MH8EuZFcN1udW4ier9SYKdMWa36gHresnyIPwYmY5oHEoCET2SaTxK1P/tlx5RiX1Azt J3x263w7bdJg1mfrMTARahRP57MzuVPeRTPZ8z/qBvH1GLcxGka651U3twHoVNcylvTk g0ZQ== X-Gm-Message-State: AODbwcArwsF3+ghpbfF3Uxdp2LG9wOiriCu7FBW6p4pV/TOCwmXAU+Wo CTvpszvW2AaHtVd9LG0/+B2ogRcjIRs3eWI= X-Received: by 10.28.167.72 with SMTP id q69mr7402482wme.73.1494949410186; Tue, 16 May 2017 08:43:30 -0700 (PDT) MIME-Version: 1.0 Received: by 10.223.136.70 with HTTP; Tue, 16 May 2017 08:43:09 -0700 (PDT) From: Murtuza Zabuawala Date: Tue, 16 May 2017 21:13:09 +0530 Message-ID: Subject: [pgAdmin4][PATCH] To fix the issue in server stats sql (PPAS9.2) To: pgadmin-hackers Content-Type: multipart/mixed; boundary="001a114b41868e5955054fa60859" 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 --001a114b41868e5955054fa60859 Content-Type: multipart/alternative; boundary="001a114b41868e5951054fa60857" --001a114b41868e5951054fa60857 Content-Type: text/plain; charset="UTF-8" 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 --001a114b41868e5951054fa60857 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi,

PFA minor patch to fix the in serve= r 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_sta= t_activity

Works:
select clie= nt_addr::text || ':' || client_port from pg_stat_activity
=

Fixes RM#1831

--
Regards,
Murtuza Zabuawala
EnterpriseDB:=C2=A0http://www.enterprisedb.com
The Ente= rprise PostgreSQL Company
--001a114b41868e5951054fa60857-- --001a114b41868e5955054fa60859 Content-Type: text/plain; charset="US-ASCII"; name="fix_server_stats.diff" Content-Disposition: attachment; filename="fix_server_stats.diff" Content-Transfer-Encoding: base64 X-Attachment-Id: f_j2rq75p70 ZGlmZiAtLWdpdCBhL3dlYi9wZ2FkbWluL2Jyb3dzZXIvc2VydmVyX2dyb3Vw cy9zZXJ2ZXJzL3RlbXBsYXRlcy9zZXJ2ZXJzL3NxbC85LjJfcGx1cy9zdGF0 cy5zcWwgYi93ZWIvcGdhZG1pbi9icm93c2VyL3NlcnZlcl9ncm91cHMvc2Vy dmVycy90ZW1wbGF0ZXMvc2VydmVycy9zcWwvOS4yX3BsdXMvc3RhdHMuc3Fs CmluZGV4IDBiMzk3ZjYuLjE4OWRiMjggMTAwNjQ0Ci0tLSBhL3dlYi9wZ2Fk bWluL2Jyb3dzZXIvc2VydmVyX2dyb3Vwcy9zZXJ2ZXJzL3RlbXBsYXRlcy9z ZXJ2ZXJzL3NxbC85LjJfcGx1cy9zdGF0cy5zcWwKKysrIGIvd2ViL3BnYWRt aW4vYnJvd3Nlci9zZXJ2ZXJfZ3JvdXBzL3NlcnZlcnMvdGVtcGxhdGVzL3Nl cnZlcnMvc3FsLzkuMl9wbHVzL3N0YXRzLnNxbApAQCAtNyw3ICs3LDcgQEAg U0VMRUNUCiAgICAgV0hFTiBjbGllbnRfaG9zdG5hbWUgSVMgTk9UIE5VTEwg QU5EIGNsaWVudF9ob3N0bmFtZSAhPSAnJyBUSEVOCiAgICAgICAgIGNsaWVu dF9ob3N0bmFtZSB8fCAnOicgfHwgY2xpZW50X3BvcnQKICAgICBXSEVOIGNs aWVudF9hZGRyIElTIE5PVCBOVUxMIEFORCBjbGllbnRfYWRkcjo6dGV4dCAh PSAnJyBUSEVOCi0gICAgICAgIGNsaWVudF9hZGRyIHx8ICc6JyB8fCBjbGll bnRfcG9ydAorICAgICAgICBjbGllbnRfYWRkcjo6dGV4dCB8fCAnOicgfHwg Y2xpZW50X3BvcnQKICAgICBXSEVOIGNsaWVudF9wb3J0ID0gLTEgVEhFTgog ICAgICAgICAnbG9jYWwgcGlwZScKICAgICBFTFNFCkBAIC0zMiw3ICszMiw3 IEBAIFNFTEVDVAogICAgIFdIRU4gY2xpZW50X2hvc3RuYW1lIElTIE5PVCBO VUxMIEFORCBjbGllbnRfaG9zdG5hbWUgIT0gJycgVEhFTgogICAgICAgICBj bGllbnRfaG9zdG5hbWUgfHwgJzonIHx8IGNsaWVudF9wb3J0CiAgICAgV0hF TiBjbGllbnRfYWRkciBJUyBOT1QgTlVMTCBBTkQgY2xpZW50X2FkZHI6OnRl eHQgIT0gJycgVEhFTgotICAgICAgICBjbGllbnRfYWRkciB8fCAnOicgfHwg Y2xpZW50X3BvcnQKKyAgICAgICAgY2xpZW50X2FkZHI6OnRleHQgfHwgJzon IHx8IGNsaWVudF9wb3J0CiAgICAgV0hFTiBjbGllbnRfcG9ydCA9IC0xIFRI RU4KICAgICAgICAgJ2xvY2FsIHBpcGUnCiAgICAgRUxTRQpkaWZmIC0tZ2l0 IGEvd2ViL3BnYWRtaW4vYnJvd3Nlci9zZXJ2ZXJfZ3JvdXBzL3NlcnZlcnMv dGVtcGxhdGVzL3NlcnZlcnMvc3FsLzkuNl9wbHVzL3N0YXRzLnNxbCBiL3dl Yi9wZ2FkbWluL2Jyb3dzZXIvc2VydmVyX2dyb3Vwcy9zZXJ2ZXJzL3RlbXBs YXRlcy9zZXJ2ZXJzL3NxbC85LjZfcGx1cy9zdGF0cy5zcWwKaW5kZXggYTFk YmMzNy4uOTliZjJmNCAxMDA2NDQKLS0tIGEvd2ViL3BnYWRtaW4vYnJvd3Nl ci9zZXJ2ZXJfZ3JvdXBzL3NlcnZlcnMvdGVtcGxhdGVzL3NlcnZlcnMvc3Fs LzkuNl9wbHVzL3N0YXRzLnNxbAorKysgYi93ZWIvcGdhZG1pbi9icm93c2Vy L3NlcnZlcl9ncm91cHMvc2VydmVycy90ZW1wbGF0ZXMvc2VydmVycy9zcWwv OS42X3BsdXMvc3RhdHMuc3FsCkBAIC03LDcgKzcsNyBAQCBTRUxFQ1QKICAg ICBXSEVOIGNsaWVudF9ob3N0bmFtZSBJUyBOT1QgTlVMTCBBTkQgY2xpZW50 X2hvc3RuYW1lICE9ICcnIFRIRU4KICAgICAgICAgY2xpZW50X2hvc3RuYW1l IHx8ICc6JyB8fCBjbGllbnRfcG9ydAogICAgIFdIRU4gY2xpZW50X2FkZHIg SVMgTk9UIE5VTEwgQU5EIGNsaWVudF9hZGRyOjp0ZXh0ICE9ICcnIFRIRU4K LSAgICAgICAgY2xpZW50X2FkZHIgfHwgJzonIHx8IGNsaWVudF9wb3J0Cisg ICAgICAgIGNsaWVudF9hZGRyOjp0ZXh0IHx8ICc6JyB8fCBjbGllbnRfcG9y dAogICAgIFdIRU4gY2xpZW50X3BvcnQgPSAtMSBUSEVOCiAgICAgICAgICds b2NhbCBwaXBlJwogICAgIEVMU0UKQEAgLTMzLDcgKzMzLDcgQEAgU0VMRUNU CiAgICAgV0hFTiBjbGllbnRfaG9zdG5hbWUgSVMgTk9UIE5VTEwgQU5EIGNs aWVudF9ob3N0bmFtZSAhPSAnJyBUSEVOCiAgICAgICAgIGNsaWVudF9ob3N0 bmFtZSB8fCAnOicgfHwgY2xpZW50X3BvcnQKICAgICBXSEVOIGNsaWVudF9h ZGRyIElTIE5PVCBOVUxMIEFORCBjbGllbnRfYWRkcjo6dGV4dCAhPSAnJyBU SEVOCi0gICAgICAgIGNsaWVudF9hZGRyIHx8ICc6JyB8fCBjbGllbnRfcG9y dAorICAgICAgICBjbGllbnRfYWRkcjo6dGV4dCB8fCAnOicgfHwgY2xpZW50 X3BvcnQKICAgICBXSEVOIGNsaWVudF9wb3J0ID0gLTEgVEhFTgogICAgICAg ICAnbG9jYWwgcGlwZScKICAgICBFTFNFCmRpZmYgLS1naXQgYS93ZWIvcGdh ZG1pbi9icm93c2VyL3NlcnZlcl9ncm91cHMvc2VydmVycy90ZW1wbGF0ZXMv c2VydmVycy9zcWwvZGVmYXVsdC9zdGF0cy5zcWwgYi93ZWIvcGdhZG1pbi9i cm93c2VyL3NlcnZlcl9ncm91cHMvc2VydmVycy90ZW1wbGF0ZXMvc2VydmVy cy9zcWwvZGVmYXVsdC9zdGF0cy5zcWwKaW5kZXggNTQ0NDdiYS4uNjI1NTIx OSAxMDA2NDQKLS0tIGEvd2ViL3BnYWRtaW4vYnJvd3Nlci9zZXJ2ZXJfZ3Jv dXBzL3NlcnZlcnMvdGVtcGxhdGVzL3NlcnZlcnMvc3FsL2RlZmF1bHQvc3Rh dHMuc3FsCisrKyBiL3dlYi9wZ2FkbWluL2Jyb3dzZXIvc2VydmVyX2dyb3Vw cy9zZXJ2ZXJzL3RlbXBsYXRlcy9zZXJ2ZXJzL3NxbC9kZWZhdWx0L3N0YXRz LnNxbApAQCAtNyw3ICs3LDcgQEAgU0VMRUNUCiAgICAgV0hFTiBjbGllbnRf aG9zdG5hbWUgSVMgTk9UIE5VTEwgQU5EIGNsaWVudF9ob3N0bmFtZSAhPSAn JyBUSEVOCiAgICAgICAgIGNsaWVudF9ob3N0bmFtZSB8fCAnOicgfHwgY2xp ZW50X3BvcnQKICAgICBXSEVOIGNsaWVudF9hZGRyIElTIE5PVCBOVUxMIEFO RCBjbGllbnRfYWRkcjo6dGV4dCAhPSAnJyBUSEVOCi0gICAgICAgIGNsaWVu dF9hZGRyIHx8ICc6JyB8fCBjbGllbnRfcG9ydAorICAgICAgICBjbGllbnRf YWRkcjo6dGV4dCB8fCAnOicgfHwgY2xpZW50X3BvcnQKICAgICBXSEVOIGNs aWVudF9wb3J0ID0gLTEgVEhFTgogICAgICAgICAnbG9jYWwgcGlwZScKICAg ICBFTFNFCkBAIC0zMiw3ICszMiw3IEBAIFNFTEVDVAogICAgIFdIRU4gY2xp ZW50X2hvc3RuYW1lIElTIE5PVCBOVUxMIEFORCBjbGllbnRfaG9zdG5hbWUg IT0gJycgVEhFTgogICAgICAgICBjbGllbnRfaG9zdG5hbWUgfHwgJzonIHx8 IGNsaWVudF9wb3J0CiAgICAgV0hFTiBjbGllbnRfYWRkciBJUyBOT1QgTlVM TCBBTkQgY2xpZW50X2FkZHI6OnRleHQgIT0gJycgVEhFTgotICAgICAgICBj bGllbnRfYWRkciB8fCAnOicgfHwgY2xpZW50X3BvcnQKKyAgICAgICAgY2xp ZW50X2FkZHI6OnRleHQgfHwgJzonIHx8IGNsaWVudF9wb3J0CiAgICAgV0hF TiBjbGllbnRfcG9ydCA9IC0xIFRIRU4KICAgICAgICAgJ2xvY2FsIHBpcGUn CiAgICAgRUxTRQo= --001a114b41868e5955054fa60859 Content-Type: text/plain Content-Disposition: inline Content-Transfer-Encoding: 8bit MIME-Version: 1.0 -- Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-hackers --001a114b41868e5955054fa60859--