Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1bmh68-0005iU-CG for pgadmin-hackers@arkaria.postgresql.org; Wed, 21 Sep 2016 12:58:00 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1bmh67-0002XV-O1 for pgadmin-hackers@arkaria.postgresql.org; Wed, 21 Sep 2016 12:57:59 +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 1bmh66-0002XP-UQ for pgadmin-hackers@postgresql.org; Wed, 21 Sep 2016 12:57:59 +0000 Received: from mail-oi0-x236.google.com ([2607:f8b0:4003:c06::236]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1bmh63-0000gS-UW for pgadmin-hackers@postgresql.org; Wed, 21 Sep 2016 12:57:57 +0000 Received: by mail-oi0-x236.google.com with SMTP id t83so58352627oie.3 for ; Wed, 21 Sep 2016 05:57:55 -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=k7tpW3MyyRLfQ9NNnip2ZFEV9Tgu/0z11TlcMakyTiQ=; b=I4IwP4OxK1gbQ9KwiYba554YnxipQ7BjVj+iNSHrlKGRhFnLyjLZwpxDuTWMVCpVg7 wGk1kIoRAS3k5jMWZS79eykteYPcbzcxZJNy/8JFdlxsKIg/kUZB6i+2d+mp/pcrRk/v HAv5P3+1wohrrNuAocP+n8K3q8q1riRvYecfIrTA6Y/tH/ZWjzYyHAkJBaJTX6tKB7fP krfntdFua7sHHgKqouOMuTCjhtJDOxIsiwCub83BKagrwuUHzPFSqPJ35+8yNe4qj3PP MPFtBScBPkwCYgnWuYZsUpsGbS4I8FOf8ccAt50dpz0u8Iev68+f68vr5rXjL0y3h1LX CWyA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:mime-version:from:date:message-id:subject:to; bh=k7tpW3MyyRLfQ9NNnip2ZFEV9Tgu/0z11TlcMakyTiQ=; b=byCIjFhP2RSCMdMqy7LHhx59lBbHDfdY1Q7Nn8bwVvHm9Pfe2jkCXH23kJibaIB5tC tm98ctygH8wYIpX8ezbKIbmmgxR+jwclF0ZI3QJ9CpjtM5Bb/p0OHebxt9gizk3fIvv/ KgbqDtYkTXUvZ7C4konY2v0pmBoBcgh0P8FlYJryr3v9ysRUrogfG2ndXyZhbXxbEXcB pDaaD701ItcI0w7BHf9++UwAeKHBloLeEtR/c7JErtUy1zuft31NfZhlAU4MxtACveAJ upYefNdDM3Iii1hoUitJz0BiUpujkkUG94smQ7phxRS9oBeuiGTmCm9+j9SKeXTK8IsS Ok3w== X-Gm-Message-State: AE9vXwNBMo56B6nHwRQmajm4LrBCu2ERu1LuIEBH8X3FtM8P3M4M7YQkCTXqF+ww4dDtHTdYJYxqWdMDewOR3+BW X-Received: by 10.202.204.83 with SMTP id c80mr24473283oig.138.1474462674828; Wed, 21 Sep 2016 05:57:54 -0700 (PDT) MIME-Version: 1.0 Received: by 10.157.42.85 with HTTP; Wed, 21 Sep 2016 05:57:54 -0700 (PDT) From: Harshal Dhumal Date: Wed, 21 Sep 2016 18:27:54 +0530 Message-ID: Subject: Patch for RM1720 [pgadmin4] To: pgadmin-hackers Content-Type: multipart/mixed; boundary=001a113532acf7f5b3053d041789 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 --001a113532acf7f5b3053d041789 Content-Type: multipart/alternative; boundary=001a113532acf7f5b0053d041787 --001a113532acf7f5b0053d041787 Content-Type: text/plain; charset=UTF-8 Hi, PFA patch for RM1720 Issue: In pgAdmin4 we use server id (sid, which is id of server table in sqlite db) as key to keep track of server connection (server manger). But sqlite reuses these ids and therefore pgadmin4 connection manager assigns connection details of one database server to another in some cases. To avoid this issue we now deleting server connection details (server manger) when user drops server. -- *Harshal Dhumal* *Software Engineer* EnterpriseDB India: http://www.enterprisedb.com The Enterprise PostgreSQL Company --001a113532acf7f5b0053d041787 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Hi,

PFA patch for RM1720

Issue: In pgAdmin4 we use server id (sid, which is id of server tabl= e in sqlite db) as key to keep track of server connection (server manger). = But sqlite reuses these ids and therefore pgadmin4 connection manager assig= ns connection details of one database server to another in some cases.
<= div>

To avoid this issue we now deleting server connecti= on details (server manger) when user drops server.

--=C2=A0
Harshal Dhumal
Software Engineer

EnterpriseDB India:=C2=A0http://www.enterprisedb.com
The Enterprise PostgreSQL Company
--001a113532acf7f5b0053d041787-- --001a113532acf7f5b3053d041789 Content-Type: text/x-patch; charset=US-ASCII; name="RM1720.patch" Content-Disposition: attachment; filename="RM1720.patch" Content-Transfer-Encoding: base64 X-Attachment-Id: f_itcwl4nw0 ZGlmZiAtLWdpdCBhL3dlYi9wZ2FkbWluL2Jyb3dzZXIvc2VydmVyX2dyb3Vw cy9zZXJ2ZXJzL19faW5pdF9fLnB5IGIvd2ViL3BnYWRtaW4vYnJvd3Nlci9z ZXJ2ZXJfZ3JvdXBzL3NlcnZlcnMvX19pbml0X18ucHkKaW5kZXggMGI2YzZj YS4uNjI3Y2M1ZiAxMDA2NDQKLS0tIGEvd2ViL3BnYWRtaW4vYnJvd3Nlci9z ZXJ2ZXJfZ3JvdXBzL3NlcnZlcnMvX19pbml0X18ucHkKKysrIGIvd2ViL3Bn YWRtaW4vYnJvd3Nlci9zZXJ2ZXJfZ3JvdXBzL3NlcnZlcnMvX19pbml0X18u cHkKQEAgLTI0LDYgKzI0LDcgQEAgZnJvbSBwZ2FkbWluLnV0aWxzLm1lbnUg aW1wb3J0IE1lbnVJdGVtCiBpbXBvcnQgY29uZmlnCiBmcm9tIGNvbmZpZyBp bXBvcnQgUEdfREVGQVVMVF9EUklWRVIKIGZyb20gcGdhZG1pbi5tb2RlbCBp bXBvcnQgZGIsIFNlcnZlciwgU2VydmVyR3JvdXAsIFVzZXIKK2Zyb20gcGdh ZG1pbi51dGlscy5kcml2ZXIgaW1wb3J0IGdldF9kcml2ZXIKIAogCiBkZWYg aGFzX2FueShkYXRhLCBrZXlzKToKQEAgLTY0LDcgKzY1LDYgQEAgY2xhc3Mg U2VydmVyTW9kdWxlKHNnLlNlcnZlckdyb3VwUGx1Z2luTW9kdWxlKToKICAg ICAgICAgc2VydmVycyA9IFNlcnZlci5xdWVyeS5maWx0ZXJfYnkodXNlcl9p ZD1jdXJyZW50X3VzZXIuaWQsCiAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgIHNlcnZlcmdyb3VwX2lkPWdpZCkKIAotICAgICAg ICBmcm9tIHBnYWRtaW4udXRpbHMuZHJpdmVyIGltcG9ydCBnZXRfZHJpdmVy CiAgICAgICAgIGRyaXZlciA9IGdldF9kcml2ZXIoUEdfREVGQVVMVF9EUklW RVIpCiAKICAgICAgICAgZm9yIHNlcnZlciBpbiBzZXJ2ZXJzOgpAQCAtMTU2 LDcgKzE1Niw2IEBAIGNsYXNzIFNlcnZlck1vZHVsZShzZy5TZXJ2ZXJHcm91 cFBsdWdpbk1vZHVsZSk6CiAgICAgICAgIHN1Yi1tb2R1bGVzIGF0IG9uY2Uu CiAgICAgICAgICIiIgogICAgICAgICBpZiBmaXJzdF9yZWdpc3RyYXRpb246 Ci0gICAgICAgICAgICBmcm9tIHBnYWRtaW4udXRpbHMuZHJpdmVyIGltcG9y dCBnZXRfZHJpdmVyCiAgICAgICAgICAgICBkcml2ZXIgPSBnZXRfZHJpdmVy KFBHX0RFRkFVTFRfRFJJVkVSLCBhcHApCiAgICAgICAgICAgICBhcHAuamlu amFfZW52LmZpbHRlcnNbJ3F0TGl0ZXJhbCddID0gZHJpdmVyLnF0TGl0ZXJh bAogICAgICAgICAgICAgYXBwLmppbmphX2Vudi5maWx0ZXJzWydxdElkZW50 J10gPSBkcml2ZXIucXRJZGVudApAQCAtMjI0LDcgKzIyMyw2IEBAIGNsYXNz IFNlcnZlck5vZGUoUEdDaGlsZE5vZGVWaWV3KToKICAgICAgICAgc2VydmVy cyA9IFNlcnZlci5xdWVyeS5maWx0ZXJfYnkodXNlcl9pZD1jdXJyZW50X3Vz ZXIuaWQsCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgIHNlcnZlcmdyb3VwX2lkPWdpZCkKIAotICAgICAgICBmcm9tIHBnYWRt aW4udXRpbHMuZHJpdmVyIGltcG9ydCBnZXRfZHJpdmVyCiAgICAgICAgIGRy aXZlciA9IGdldF9kcml2ZXIoUEdfREVGQVVMVF9EUklWRVIpCiAKICAgICAg ICAgZm9yIHNlcnZlciBpbiBzZXJ2ZXJzOgpAQCAtMjkzLDcgKzI5MSw2IEBA IGNsYXNzIFNlcnZlck5vZGUoUEdDaGlsZE5vZGVWaWV3KToKICAgICAgICAg ICAgICAgICApCiAgICAgICAgICAgICApCiAKLSAgICAgICAgZnJvbSBwZ2Fk bWluLnV0aWxzLmRyaXZlciBpbXBvcnQgZ2V0X2RyaXZlcgogICAgICAgICBt YW5hZ2VyID0gZ2V0X2RyaXZlcihQR19ERUZBVUxUX0RSSVZFUikuY29ubmVj dGlvbl9tYW5hZ2VyKHNlcnZlci5pZCkKICAgICAgICAgY29ubiA9IG1hbmFn ZXIuY29ubmVjdGlvbigpCiAgICAgICAgIGNvbm5lY3RlZCA9IGNvbm4uY29u bmVjdGVkKCkKQEAgLTM1NSw2ICszNTIsOCBAQCBjbGFzcyBTZXJ2ZXJOb2Rl KFBHQ2hpbGROb2RlVmlldyk6CiAgICAgICAgICAgICAgICAgZm9yIHMgaW4g c2VydmVyczoKICAgICAgICAgICAgICAgICAgICAgZGIuc2Vzc2lvbi5kZWxl dGUocykKICAgICAgICAgICAgICAgICBkYi5zZXNzaW9uLmNvbW1pdCgpCisg ICAgICAgICAgICAgICAgZ2V0X2RyaXZlcihQR19ERUZBVUxUX0RSSVZFUiku ZGVsZXRlX21hbmFnZXIoc2lkKQorCiAgICAgICAgICAgICBleGNlcHQgRXhj ZXB0aW9uIGFzIGU6CiAgICAgICAgICAgICAgICAgY3VycmVudF9hcHAubG9n Z2VyLmV4Y2VwdGlvbihlKQogICAgICAgICAgICAgICAgIHJldHVybiBtYWtl X2pzb25fcmVzcG9uc2UoCkBAIC00MDUsNyArNDA0LDYgQEAgY2xhc3MgU2Vy dmVyTm9kZShQR0NoaWxkTm9kZVZpZXcpOgogICAgICAgICAgICAgcmVxdWVz dC5kYXRhLCBlbmNvZGluZz0ndXRmLTgnCiAgICAgICAgICkKIAotICAgICAg ICBmcm9tIHBnYWRtaW4udXRpbHMuZHJpdmVyIGltcG9ydCBnZXRfZHJpdmVy CiAgICAgICAgIG1hbmFnZXIgPSBnZXRfZHJpdmVyKFBHX0RFRkFVTFRfRFJJ VkVSKS5jb25uZWN0aW9uX21hbmFnZXIoc2lkKQogICAgICAgICBjb25uID0g bWFuYWdlci5jb25uZWN0aW9uKCkKICAgICAgICAgY29ubmVjdGVkID0gY29u bi5jb25uZWN0ZWQoKQpAQCAtNDczLDcgKzQ3MSw2IEBAIGNsYXNzIFNlcnZl ck5vZGUoUEdDaGlsZE5vZGVWaWV3KToKICAgICAgICAgKS5maXJzdCgpCiAg ICAgICAgIHJlcyA9IFtdCiAKLSAgICAgICAgZnJvbSBwZ2FkbWluLnV0aWxz LmRyaXZlciBpbXBvcnQgZ2V0X2RyaXZlcgogICAgICAgICBkcml2ZXIgPSBn ZXRfZHJpdmVyKFBHX0RFRkFVTFRfRFJJVkVSKQogCiAgICAgICAgIGZvciBz ZXJ2ZXIgaW4gc2VydmVyczoKQEAgLTUxOSw3ICs1MTYsNiBAQCBjbGFzcyBT ZXJ2ZXJOb2RlKFBHQ2hpbGROb2RlVmlldyk6CiAgICAgICAgICAgICBpZD1z ZXJ2ZXIuc2VydmVyZ3JvdXBfaWQKICAgICAgICAgKS5maXJzdCgpCiAKLSAg ICAgICAgZnJvbSBwZ2FkbWluLnV0aWxzLmRyaXZlciBpbXBvcnQgZ2V0X2Ry aXZlcgogICAgICAgICBkcml2ZXIgPSBnZXRfZHJpdmVyKFBHX0RFRkFVTFRf RFJJVkVSKQogCiAgICAgICAgIG1hbmFnZXIgPSBkcml2ZXIuY29ubmVjdGlv bl9tYW5hZ2VyKHNpZCkKQEAgLTU5NCw3ICs1OTAsNiBAQCBjbGFzcyBTZXJ2 ZXJOb2RlKFBHQ2hpbGROb2RlVmlldyk6CiAgICAgICAgICAgICB1c2VyID0g Tm9uZQogCiAgICAgICAgICAgICBpZiAnY29ubmVjdF9ub3cnIGluIGRhdGEg YW5kIGRhdGFbJ2Nvbm5lY3Rfbm93J106Ci0gICAgICAgICAgICAgICAgZnJv bSBwZ2FkbWluLnV0aWxzLmRyaXZlciBpbXBvcnQgZ2V0X2RyaXZlcgogICAg ICAgICAgICAgICAgIG1hbmFnZXIgPSBnZXRfZHJpdmVyKFBHX0RFRkFVTFRf RFJJVkVSKS5jb25uZWN0aW9uX21hbmFnZXIoc2VydmVyLmlkKQogICAgICAg ICAgICAgICAgIG1hbmFnZXIudXBkYXRlKHNlcnZlcikKICAgICAgICAgICAg ICAgICBjb25uID0gbWFuYWdlci5jb25uZWN0aW9uKCkKQEAgLTY2Myw3ICs2 NTgsNiBAQCBjbGFzcyBTZXJ2ZXJOb2RlKFBHQ2hpbGROb2RlVmlldyk6CiAg ICAgICAgIHJldHVybiBtYWtlX2pzb25fcmVzcG9uc2UoZGF0YT0nJykKIAog ICAgIGRlZiBzdGF0aXN0aWNzKHNlbGYsIGdpZCwgc2lkKToKLSAgICAgICAg ZnJvbSBwZ2FkbWluLnV0aWxzLmRyaXZlciBpbXBvcnQgZ2V0X2RyaXZlcgog ICAgICAgICBtYW5hZ2VyID0gZ2V0X2RyaXZlcihQR19ERUZBVUxUX0RSSVZF UikuY29ubmVjdGlvbl9tYW5hZ2VyKHNpZCkKICAgICAgICAgY29ubiA9IG1h bmFnZXIuY29ubmVjdGlvbigpCiAKQEAgLTcxNyw3ICs3MTEsNiBAQCBjbGFz cyBTZXJ2ZXJOb2RlKFBHQ2hpbGROb2RlVmlldyk6CiAKICAgICBkZWYgY29u bmVjdF9zdGF0dXMoc2VsZiwgZ2lkLCBzaWQpOgogICAgICAgICAiIiJDaGVj ayBhbmQgcmV0dXJuIHRoZSBjb25uZWN0aW9uIHN0YXR1cy4iIiIKLSAgICAg ICAgZnJvbSBwZ2FkbWluLnV0aWxzLmRyaXZlciBpbXBvcnQgZ2V0X2RyaXZl cgogICAgICAgICBtYW5hZ2VyID0gZ2V0X2RyaXZlcihQR19ERUZBVUxUX0RS SVZFUikuY29ubmVjdGlvbl9tYW5hZ2VyKHNpZCkKICAgICAgICAgY29ubiA9 IG1hbmFnZXIuY29ubmVjdGlvbigpCiAgICAgICAgIHJlcyA9IGNvbm4uY29u bmVjdGVkKCkKQEAgLTc2OSw3ICs3NjIsNiBAQCBjbGFzcyBTZXJ2ZXJOb2Rl KFBHQ2hpbGROb2RlVmlldyk6CiAgICAgICAgIHNhdmVfcGFzc3dvcmQgPSBG YWxzZQogCiAgICAgICAgICMgQ29ubmVjdCB0aGUgU2VydmVyCi0gICAgICAg IGZyb20gcGdhZG1pbi51dGlscy5kcml2ZXIgaW1wb3J0IGdldF9kcml2ZXIK ICAgICAgICAgbWFuYWdlciA9IGdldF9kcml2ZXIoUEdfREVGQVVMVF9EUklW RVIpLmNvbm5lY3Rpb25fbWFuYWdlcihzaWQpCiAgICAgICAgIGNvbm4gPSBt YW5hZ2VyLmNvbm5lY3Rpb24oKQogCkBAIC05MDIsNyArODk0LDYgQEAgY2xh c3MgU2VydmVyTm9kZShQR0NoaWxkTm9kZVZpZXcpOgogICAgICAgICAgICAg cmV0dXJuIGJhZF9yZXF1ZXN0KGdldHRleHQoIlNlcnZlciBub3QgZm91bmQu IikpCiAKICAgICAgICAgIyBSZWxlYXNlIENvbm5lY3Rpb24KLSAgICAgICAg ZnJvbSBwZ2FkbWluLnV0aWxzLmRyaXZlciBpbXBvcnQgZ2V0X2RyaXZlcgog ICAgICAgICBtYW5hZ2VyID0gZ2V0X2RyaXZlcihQR19ERUZBVUxUX0RSSVZF UikuY29ubmVjdGlvbl9tYW5hZ2VyKHNpZCkKIAogICAgICAgICBzdGF0dXMg PSBtYW5hZ2VyLnJlbGVhc2UoKQpAQCAtOTIzLDcgKzkxNCw2IEBAIGNsYXNz IFNlcnZlck5vZGUoUEdDaGlsZE5vZGVWaWV3KToKICAgICAgICAgIiIiUmVs b2FkIHRoZSBzZXJ2ZXIgY29uZmlndXJhdGlvbiIiIgogCiAgICAgICAgICMg UmVsb2FkIHRoZSBzZXJ2ZXIgY29uZmlndXJhdGlvbnMKLSAgICAgICAgZnJv bSBwZ2FkbWluLnV0aWxzLmRyaXZlciBpbXBvcnQgZ2V0X2RyaXZlcgogICAg ICAgICBtYW5hZ2VyID0gZ2V0X2RyaXZlcihQR19ERUZBVUxUX0RSSVZFUiku Y29ubmVjdGlvbl9tYW5hZ2VyKHNpZCkKICAgICAgICAgY29ubiA9IG1hbmFn ZXIuY29ubmVjdGlvbigpCiAKQEAgLTk1OCw3ICs5NDgsNiBAQCBjbGFzcyBT ZXJ2ZXJOb2RlKFBHQ2hpbGROb2RlVmlldyk6CiAgICAgICAgIHRyeToKICAg ICAgICAgICAgIGRhdGEgPSByZXF1ZXN0LmZvcm0KICAgICAgICAgICAgIHJl c3RvcmVfcG9pbnRfbmFtZSA9IGRhdGFbJ3ZhbHVlJ10gaWYgZGF0YSBlbHNl IE5vbmUKLSAgICAgICAgICAgIGZyb20gcGdhZG1pbi51dGlscy5kcml2ZXIg aW1wb3J0IGdldF9kcml2ZXIKICAgICAgICAgICAgIG1hbmFnZXIgPSBnZXRf ZHJpdmVyKFBHX0RFRkFVTFRfRFJJVkVSKS5jb25uZWN0aW9uX21hbmFnZXIo c2lkKQogICAgICAgICAgICAgY29ubiA9IG1hbmFnZXIuY29ubmVjdGlvbigp CiAKQEAgLTEwMzMsNyArMTAyMiw2IEBAIGNsYXNzIFNlcnZlck5vZGUoUEdD aGlsZE5vZGVWaWV3KToKICAgICAgICAgICAgIGlmIHVzZXIgaXMgTm9uZToK ICAgICAgICAgICAgICAgICByZXR1cm4gdW5hdXRob3JpemVkKGdldHRleHQo IlVuYXV0aG9yaXplZCByZXF1ZXN0LiIpKQogCi0gICAgICAgICAgICBmcm9t IHBnYWRtaW4udXRpbHMuZHJpdmVyIGltcG9ydCBnZXRfZHJpdmVyCiAgICAg ICAgICAgICBtYW5hZ2VyID0gZ2V0X2RyaXZlcihQR19ERUZBVUxUX0RSSVZF UikuY29ubmVjdGlvbl9tYW5hZ2VyKHNpZCkKICAgICAgICAgICAgIGNvbm4g PSBtYW5hZ2VyLmNvbm5lY3Rpb24oKQogCkBAIC0xMTAwLDcgKzEwODgsNiBA QCBjbGFzcyBTZXJ2ZXJOb2RlKFBHQ2hpbGROb2RlVmlldyk6CiAgICAgICAg ICAgICApCiAKICAgICAgICAgdHJ5OgotICAgICAgICAgICAgZnJvbSBwZ2Fk bWluLnV0aWxzLmRyaXZlciBpbXBvcnQgZ2V0X2RyaXZlcgogICAgICAgICAg ICAgbWFuYWdlciA9IGdldF9kcml2ZXIoUEdfREVGQVVMVF9EUklWRVIpLmNv bm5lY3Rpb25fbWFuYWdlcihzaWQpCiAgICAgICAgICAgICBjb25uID0gbWFu YWdlci5jb25uZWN0aW9uKCkKIApkaWZmIC0tZ2l0IGEvd2ViL3BnYWRtaW4v dXRpbHMvZHJpdmVyL3BzeWNvcGcyL19faW5pdF9fLnB5IGIvd2ViL3BnYWRt aW4vdXRpbHMvZHJpdmVyL3BzeWNvcGcyL19faW5pdF9fLnB5CmluZGV4IDJk NjIzOWYuLjVjMmM1M2MgMTAwNjQ0Ci0tLSBhL3dlYi9wZ2FkbWluL3V0aWxz L2RyaXZlci9wc3ljb3BnMi9fX2luaXRfXy5weQorKysgYi93ZWIvcGdhZG1p bi91dGlscy9kcml2ZXIvcHN5Y29wZzIvX19pbml0X18ucHkKQEAgLTE3MjEs NiArMTcyMSwxNiBAQCBjbGFzcyBEcml2ZXIoQmFzZURyaXZlcik6CiAgICAg ICAgICIiIgogICAgICAgICByZXR1cm4gc2VsZi5jb25uZWN0aW9uX21hbmFn ZXIoc2lkKS5yZWxlYXNlKGRhdGFiYXNlLCBjb25uX2lkKQogCisgICAgZGVm IGRlbGV0ZV9tYW5hZ2VyKHNlbGYsIHNpZCk6CisgICAgICAgICIiIgorICAg ICAgICBEZWxldGUgbWFuYWdlciBmb3IgZ2l2ZW4gc2VydmVyIGlkLgorICAg ICAgICAiIiIKKyAgICAgICAgbWFuYWdlciA9IHNlbGYuY29ubmVjdGlvbl9t YW5hZ2VyKHNpZCkKKyAgICAgICAgbWFuYWdlci5yZWxlYXNlKCkKKyAgICAg ICAgaWYgc2Vzc2lvblsnX2lkJ10gaW4gc2VsZi5tYW5hZ2VycyBhbmQgXAor ICAgICAgICAgICAgICAgIHN0cihzaWQpIGluIHNlbGYubWFuYWdlcnNbc2Vz c2lvblsnX2lkJ11dOgorICAgICAgICAgICAgZGVsIHNlbGYubWFuYWdlcnNb c2Vzc2lvblsnX2lkJ11dW3N0cihzaWQpXQorCiAgICAgZGVmIGdjKHNlbGYp OgogICAgICAgICAiIiIKICAgICAgICAgUmVsZWFzZSB0aGUgY29ubmVjdGlv bnMgZm9yIHRoZSBzZXNzaW9ucywgd2hpY2ggaGF2ZSBub3QgcGluZ2VkIHRo ZQo= --001a113532acf7f5b3053d041789 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 --001a113532acf7f5b3053d041789--