Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1d2wcC-0004bu-QH for pgadmin-hackers@arkaria.postgresql.org; Tue, 25 Apr 2017 09:18:33 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1d2wcC-0002ER-Cu for pgadmin-hackers@arkaria.postgresql.org; Tue, 25 Apr 2017 09:18:32 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1d2wcB-0002CF-FZ for pgadmin-hackers@postgresql.org; Tue, 25 Apr 2017 09:18:31 +0000 Received: from mail-oi0-x22a.google.com ([2607:f8b0:4003:c06::22a]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1d2wc7-0000g4-3q for pgadmin-hackers@postgresql.org; Tue, 25 Apr 2017 09:18:31 +0000 Received: by mail-oi0-x22a.google.com with SMTP id x184so165262549oia.1 for ; Tue, 25 Apr 2017 02:18:26 -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=BY+Xwbgfq+S7pfZ+fc+Kjy4kYE+Mc6sZrwpcK31dzBw=; b=aJeq1W1UmnFuLSHnFexVTm2VVe3IGzrFQU7bVZ5lfSGDs7KXBshP/kiKPx+7KJPFo0 yW1SedLEpBy4oyOiIUMLk3rxgmLzUgI/FCDhXX1Xo+BvhTJBQ9ui1H3HuuhDCmBVWvj6 Rtt+sCj7MEZXv59M/Bs0LaeGTrUm3u8hbdBWz0hghK7mQ6tkJZsur4nh7nCgQSIV8QzD +4u7+e1MMb8EK6YDXi1zBeSyZflwR7wOwUxpJ+KwVnyL7TOfkrZhVazrHPZ5rJ67zvka p54zfJKKuF7g34FGFqobPO4GOW3eIybyN8yZSsUXlUCRyQm86swpS3PT9Ou5Ho+6vG4k JI7w== 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=BY+Xwbgfq+S7pfZ+fc+Kjy4kYE+Mc6sZrwpcK31dzBw=; b=Vok11RZog+TjQaiphtxctvYTKia4qLHRRxcWsUySXWbRbyArlqfLLFQARPzGS5jnE3 x23yobSG4pAWwa4DsRe+3PJi8q9pdWU5c0KrL+6hnaYOFm8T4z9DU5iGARKuEzrUHBUf qjokRGaBcaKDbqfJN4vsSRvPE4ScPxEmXYGsNCF9DKd9iZraVM0CcaY1NIJtaejuHAHh OCFEtTGnEPQjYEc15ukQGjgCWxJ6pZRzOz29feAsQQF08kRdgTVmj4G4h0FqV3P+5x45 JoawzLtY/nBuwC4+H+/g5BcqgK0R+pLjNYvcxIHCCs7+FvPKDs5ySfO0TJfx6eS01KUC iSrw== X-Gm-Message-State: AN3rC/5qa2HC/1E0xScPH7npe8SzxeRSDELKvhVi35nEPT8VUbvBj3Fp l+UpvIJ1Ep3nZKu3EHBxxj7TzMslUVZH X-Received: by 10.157.82.25 with SMTP id e25mr1533591oth.153.1493111904419; Tue, 25 Apr 2017 02:18:24 -0700 (PDT) MIME-Version: 1.0 Received: by 10.74.153.229 with HTTP; Tue, 25 Apr 2017 02:18:23 -0700 (PDT) From: Khushboo Vashi Date: Tue, 25 Apr 2017 14:48:23 +0530 Message-ID: Subject: [pgAdmin4][Patch]: Fixed RM #2315 : Sorting by size is broken To: pgadmin-hackers Content-Type: multipart/mixed; boundary=f40304354dd4ac7e76054dfa34e3 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 --f40304354dd4ac7e76054dfa34e3 Content-Type: multipart/alternative; boundary=f40304354dd4ac7e71054dfa34e1 --f40304354dd4ac7e71054dfa34e1 Content-Type: text/plain; charset=UTF-8 Hi, Fixed RM #2315 : Sorting by size is broken. Removed the pg_size_pretty function from query for the collection and introduced the client side function to convert size into human readable format. So, the sorting issue is fixed as the algorithm will get the actual value of size instead of formatted value. Thanks, Khushboo --f40304354dd4ac7e71054dfa34e1 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Hi,

Fixed RM #2315 : Sorting by size is= broken.

Removed the pg_size_pretty function from = query for the collection and introduced the client side function to convert= size into human readable format. So, the sorting issue is fixed as the alg= orithm will get the actual value of size instead of formatted value.=C2=A0<= /div>
=C2=A0

Thanks,
Khushboo


--f40304354dd4ac7e71054dfa34e1-- --f40304354dd4ac7e76054dfa34e3 Content-Type: text/x-patch; charset=US-ASCII; name="RM_2315.patch" Content-Disposition: attachment; filename="RM_2315.patch" Content-Transfer-Encoding: base64 X-Attachment-Id: f_j1xc4f3n0 ZGlmZiAtLWdpdCBhL3dlYi9wZ2FkbWluL2Jyb3dzZXIvc2VydmVyX2dyb3Vw cy9zZXJ2ZXJzL2RhdGFiYXNlcy9fX2luaXRfXy5weSBiL3dlYi9wZ2FkbWlu L2Jyb3dzZXIvc2VydmVyX2dyb3Vwcy9zZXJ2ZXJzL2RhdGFiYXNlcy9fX2lu aXRfXy5weQppbmRleCA3NjFmNzU3Li44NTgxNzFlIDEwMDY0NAotLS0gYS93 ZWIvcGdhZG1pbi9icm93c2VyL3NlcnZlcl9ncm91cHMvc2VydmVycy9kYXRh YmFzZXMvX19pbml0X18ucHkKKysrIGIvd2ViL3BnYWRtaW4vYnJvd3Nlci9z ZXJ2ZXJfZ3JvdXBzL3NlcnZlcnMvZGF0YWJhc2VzL19faW5pdF9fLnB5CkBA IC04NDIsNiArODQyLDEzIEBAIGNsYXNzIERhdGFiYXNlVmlldyhQR0NoaWxk Tm9kZVZpZXcpOgogICAgICAgICBpZiBub3Qgc3RhdHVzOgogICAgICAgICAg ICAgcmV0dXJuIGludGVybmFsX3NlcnZlcl9lcnJvcihlcnJvcm1zZz1yZXMp CiAKKyAgICAgICAgaWYgbm90IGRpZDoKKyAgICAgICAgICAgICMgV2hldGhl ciB0aGUgY29sdW1uIG5lZWRzIHByZXR0aWZ5IGF0IHRoZSBjbGllbnQgc2lk ZSBvciBub3QKKyAgICAgICAgICAgIGlmICdjb2x1bW5zJyBpbiByZXM6Cisg ICAgICAgICAgICAgICAgZm9yIGNvbCBpbiByZXNbJ2NvbHVtbnMnXToKKyAg ICAgICAgICAgICAgICAgICAgaWYgY29sWyduYW1lJ10gaW4gWydTaXplJywg J1NpemUgb2YgdGVtcG9yYXJ5IGZpbGVzJ106CisgICAgICAgICAgICAgICAg ICAgICAgICBjb2xbJ2Nhbl9wcmV0dGlmeSddID0gVHJ1ZQorCiAgICAgICAg IHJldHVybiBtYWtlX2pzb25fcmVzcG9uc2UoCiAgICAgICAgICAgICBkYXRh PXJlcywKICAgICAgICAgICAgIHN0YXR1cz0yMDAKZGlmZiAtLWdpdCBhL3dl Yi9wZ2FkbWluL2Jyb3dzZXIvc2VydmVyX2dyb3Vwcy9zZXJ2ZXJzL2RhdGFi YXNlcy9zY2hlbWFzL3RhYmxlcy9fX2luaXRfXy5weSBiL3dlYi9wZ2FkbWlu L2Jyb3dzZXIvc2VydmVyX2dyb3Vwcy9zZXJ2ZXJzL2RhdGFiYXNlcy9zY2hl bWFzL3RhYmxlcy9fX2luaXRfXy5weQppbmRleCBlMTE4Y2FiLi5kMTVjN2Nl IDEwMDY0NAotLS0gYS93ZWIvcGdhZG1pbi9icm93c2VyL3NlcnZlcl9ncm91 cHMvc2VydmVycy9kYXRhYmFzZXMvc2NoZW1hcy90YWJsZXMvX19pbml0X18u cHkKKysrIGIvd2ViL3BnYWRtaW4vYnJvd3Nlci9zZXJ2ZXJfZ3JvdXBzL3Nl cnZlcnMvZGF0YWJhc2VzL3NjaGVtYXMvdGFibGVzL19faW5pdF9fLnB5CkBA IC0yOTEzLDYgKzI5MTMsMTMgQEAgY2xhc3MgVGFibGVWaWV3KFBHQ2hpbGRO b2RlVmlldywgRGF0YVR5cGVSZWFkZXIsIFZhY3V1bVNldHRpbmdzKToKICAg ICAgICAgICAgICAgICAgICAgY29ubj1zZWxmLmNvbm4sIHNjaGVtYV9uYW1l PXNjaGVtYV9uYW1lCiAgICAgICAgICAgICAgICAgKQogICAgICAgICAgICAg KQorCisgICAgICAgICAgICAjIFdoZXRoZXIgdGhlIGNvbHVtbiBuZWVkcyBw cmV0dGlmeSBhdCB0aGUgY2xpZW50IHNpZGUgb3Igbm90CisgICAgICAgICAg ICBpZiAnY29sdW1ucycgaW4gcmVzOgorICAgICAgICAgICAgICAgIGZvciBj b2wgaW4gcmVzWydjb2x1bW5zJ106CisgICAgICAgICAgICAgICAgICAgIGlm IGNvbFsnbmFtZSddIGluIFsnU2l6ZSddOgorICAgICAgICAgICAgICAgICAg ICAgICAgY29sWydjYW5fcHJldHRpZnknXSA9IFRydWUKKwogICAgICAgICBl bHNlOgogICAgICAgICAgICAgIyBGb3IgSW5kaXZpZHVhbCB0YWJsZSBzdGF0 cwogCmRpZmYgLS1naXQgYS93ZWIvcGdhZG1pbi9icm93c2VyL3NlcnZlcl9n cm91cHMvc2VydmVycy9kYXRhYmFzZXMvc2NoZW1hcy90YWJsZXMvaW5kZXhl cy9fX2luaXRfXy5weSBiL3dlYi9wZ2FkbWluL2Jyb3dzZXIvc2VydmVyX2dy b3Vwcy9zZXJ2ZXJzL2RhdGFiYXNlcy9zY2hlbWFzL3RhYmxlcy9pbmRleGVz L19faW5pdF9fLnB5CmluZGV4IDZkODY4MGQuLmU0MDY0ZjcgMTAwNjQ0Ci0t LSBhL3dlYi9wZ2FkbWluL2Jyb3dzZXIvc2VydmVyX2dyb3Vwcy9zZXJ2ZXJz L2RhdGFiYXNlcy9zY2hlbWFzL3RhYmxlcy9pbmRleGVzL19faW5pdF9fLnB5 CisrKyBiL3dlYi9wZ2FkbWluL2Jyb3dzZXIvc2VydmVyX2dyb3Vwcy9zZXJ2 ZXJzL2RhdGFiYXNlcy9zY2hlbWFzL3RhYmxlcy9pbmRleGVzL19faW5pdF9f LnB5CkBAIC05NzgsNiArOTc4LDEyIEBAIGNsYXNzIEluZGV4ZXNWaWV3KFBH Q2hpbGROb2RlVmlldyk6CiAgICAgICAgICAgICAgICAgKQogICAgICAgICAg ICAgKQogCisgICAgICAgICAgICAjIFdoZXRoZXIgdGhlIGNvbHVtbiBuZWVk cyBwcmV0dGlmeSBhdCB0aGUgY2xpZW50IHNpZGUgb3Igbm90CisgICAgICAg ICAgICBpZiAnY29sdW1ucycgaW4gcmVzOgorICAgICAgICAgICAgICAgIGZv ciBjb2wgaW4gcmVzWydjb2x1bW5zJ106CisgICAgICAgICAgICAgICAgICAg IGlmIGNvbFsnbmFtZSddIGluIFsnU2l6ZSddOgorICAgICAgICAgICAgICAg ICAgICAgICAgY29sWydjYW5fcHJldHRpZnknXSA9IFRydWUKKwogICAgICAg ICBpZiBub3Qgc3RhdHVzOgogICAgICAgICAgICAgcmV0dXJuIGludGVybmFs X3NlcnZlcl9lcnJvcihlcnJvcm1zZz1yZXMpCiAKZGlmZiAtLWdpdCBhL3dl Yi9wZ2FkbWluL2Jyb3dzZXIvc2VydmVyX2dyb3Vwcy9zZXJ2ZXJzL2RhdGFi YXNlcy9zY2hlbWFzL3RhYmxlcy90ZW1wbGF0ZXMvaW5kZXgvc3FsL2RlZmF1 bHQvY29sbF9zdGF0cy5zcWwgYi93ZWIvcGdhZG1pbi9icm93c2VyL3NlcnZl cl9ncm91cHMvc2VydmVycy9kYXRhYmFzZXMvc2NoZW1hcy90YWJsZXMvdGVt cGxhdGVzL2luZGV4L3NxbC9kZWZhdWx0L2NvbGxfc3RhdHMuc3FsCmluZGV4 IGJjYTJkMDkuLjZjYWRlNmYgMTAwNjQ0Ci0tLSBhL3dlYi9wZ2FkbWluL2Jy b3dzZXIvc2VydmVyX2dyb3Vwcy9zZXJ2ZXJzL2RhdGFiYXNlcy9zY2hlbWFz L3RhYmxlcy90ZW1wbGF0ZXMvaW5kZXgvc3FsL2RlZmF1bHQvY29sbF9zdGF0 cy5zcWwKKysrIGIvd2ViL3BnYWRtaW4vYnJvd3Nlci9zZXJ2ZXJfZ3JvdXBz L3NlcnZlcnMvZGF0YWJhc2VzL3NjaGVtYXMvdGFibGVzL3RlbXBsYXRlcy9p bmRleC9zcWwvZGVmYXVsdC9jb2xsX3N0YXRzLnNxbApAQCAtMyw3ICszLDcg QEAgU0VMRUNUCiAgICAgaWR4X3NjYW4gQVMge3sgY29ubnxxdElkZW50KF8o J0luZGV4IHNjYW5zJykpIH19LAogICAgIGlkeF90dXBfcmVhZCBBUyB7eyBj b25ufHF0SWRlbnQoXygnSW5kZXggdHVwbGVzIHJlYWQnKSkgfX0sCiAgICAg aWR4X3R1cF9mZXRjaCBBUyB7eyBjb25ufHF0SWRlbnQoXygnSW5kZXggdHVw bGVzIGZldGNoZWQnKSkgfX0sCi0gICAgcGdfc2l6ZV9wcmV0dHkocGdfcmVs YXRpb25fc2l6ZShpbmRleHJlbGlkKSkgQVMge3sgY29ubnxxdElkZW50KF8o J1NpemUnKSkgfX0KKyAgICBwZ19yZWxhdGlvbl9zaXplKGluZGV4cmVsaWQp IEFTIHt7IGNvbm58cXRJZGVudChfKCdTaXplJykpIH19CiBGUk9NCiAgICAg cGdfc3RhdF9hbGxfaW5kZXhlcyBzdGF0CiAgICAgSk9JTiBwZ19jbGFzcyBj bHMgT04gY2xzLm9pZD1pbmRleHJlbGlkCmRpZmYgLS1naXQgYS93ZWIvcGdh ZG1pbi9icm93c2VyL3NlcnZlcl9ncm91cHMvc2VydmVycy9kYXRhYmFzZXMv c2NoZW1hcy90YWJsZXMvdGVtcGxhdGVzL3RhYmxlL3NxbC9kZWZhdWx0L2Nv bGxfdGFibGVfc3RhdHMuc3FsIGIvd2ViL3BnYWRtaW4vYnJvd3Nlci9zZXJ2 ZXJfZ3JvdXBzL3NlcnZlcnMvZGF0YWJhc2VzL3NjaGVtYXMvdGFibGVzL3Rl bXBsYXRlcy90YWJsZS9zcWwvZGVmYXVsdC9jb2xsX3RhYmxlX3N0YXRzLnNx bAppbmRleCBlZTNmZmEzLi42M2E2ODI2IDEwMDY0NAotLS0gYS93ZWIvcGdh ZG1pbi9icm93c2VyL3NlcnZlcl9ncm91cHMvc2VydmVycy9kYXRhYmFzZXMv c2NoZW1hcy90YWJsZXMvdGVtcGxhdGVzL3RhYmxlL3NxbC9kZWZhdWx0L2Nv bGxfdGFibGVfc3RhdHMuc3FsCisrKyBiL3dlYi9wZ2FkbWluL2Jyb3dzZXIv c2VydmVyX2dyb3Vwcy9zZXJ2ZXJzL2RhdGFiYXNlcy9zY2hlbWFzL3RhYmxl cy90ZW1wbGF0ZXMvdGFibGUvc3FsL2RlZmF1bHQvY29sbF90YWJsZV9zdGF0 cy5zcWwKQEAgLTE0LDEyICsxNCwxMiBAQCBTRUxFQ1QKICAgICBhdXRvdmFj dXVtX2NvdW50IEFTIHt7IGNvbm58cXRJZGVudChfKCdBdXRvdmFjdXVtIGNv dW50ZXInKSkgfX0sCiAgICAgYW5hbHl6ZV9jb3VudCBBUyB7eyBjb25ufHF0 SWRlbnQoXygnQW5hbHl6ZSBjb3VudGVyJykpIH19LAogICAgIGF1dG9hbmFs eXplX2NvdW50IEFTIHt7IGNvbm58cXRJZGVudChfKCdBdXRvYW5hbHl6ZSBj b3VudGVyJykpIH19LAotICAgIHBnX3NpemVfcHJldHR5KHBnX3JlbGF0aW9u X3NpemUoc3QucmVsaWQpCisgICAgcGdfcmVsYXRpb25fc2l6ZShzdC5yZWxp ZCkKICAgICAgICAgKyBDQVNFIFdIRU4gY2wucmVsdG9hc3RyZWxpZCA9IDAg VEhFTiAwIEVMU0UgcGdfcmVsYXRpb25fc2l6ZShjbC5yZWx0b2FzdHJlbGlk KQogICAgICAgICArIENPQUxFU0NFKChTRUxFQ1QgU1VNKHBnX3JlbGF0aW9u X3NpemUoaW5kZXhyZWxpZCkpCiAgICAgICAgICAgICAgICAgICAgICAgICBG Uk9NIHBnX2luZGV4IFdIRVJFIGluZHJlbGlkPWNsLnJlbHRvYXN0cmVsaWQp OjppbnQ4LCAwKSBFTkQKICAgICAgICAgKyBDT0FMRVNDRSgoU0VMRUNUIFNV TShwZ19yZWxhdGlvbl9zaXplKGluZGV4cmVsaWQpKQotICAgICAgICAgICAg ICAgICAgICAgICAgRlJPTSBwZ19pbmRleCBXSEVSRSBpbmRyZWxpZD1zdC5y ZWxpZCk6OmludDgsIDApKSBBUyB7eyBjb25ufHF0SWRlbnQoXygnU2l6ZScp KSB9fQorICAgICAgICAgICAgICAgICAgICAgICAgRlJPTSBwZ19pbmRleCBX SEVSRSBpbmRyZWxpZD1zdC5yZWxpZCk6OmludDgsIDApIEFTIHt7IGNvbm58 cXRJZGVudChfKCdTaXplJykpIH19CiBGUk9NCiAgICAgcGdfc3RhdF9hbGxf dGFibGVzIHN0CiBKT0lOCmRpZmYgLS1naXQgYS93ZWIvcGdhZG1pbi9icm93 c2VyL3NlcnZlcl9ncm91cHMvc2VydmVycy9kYXRhYmFzZXMvdGVtcGxhdGVz L2RhdGFiYXNlcy9zcWwvOS4yX3BsdXMvc3RhdHMuc3FsIGIvd2ViL3BnYWRt aW4vYnJvd3Nlci9zZXJ2ZXJfZ3JvdXBzL3NlcnZlcnMvZGF0YWJhc2VzL3Rl bXBsYXRlcy9kYXRhYmFzZXMvc3FsLzkuMl9wbHVzL3N0YXRzLnNxbAppbmRl eCBlMGM3ZTZiLi41YTQwODQxIDEwMDY0NAotLS0gYS93ZWIvcGdhZG1pbi9i cm93c2VyL3NlcnZlcl9ncm91cHMvc2VydmVycy9kYXRhYmFzZXMvdGVtcGxh dGVzL2RhdGFiYXNlcy9zcWwvOS4yX3BsdXMvc3RhdHMuc3FsCisrKyBiL3dl Yi9wZ2FkbWluL2Jyb3dzZXIvc2VydmVyX2dyb3Vwcy9zZXJ2ZXJzL2RhdGFi YXNlcy90ZW1wbGF0ZXMvZGF0YWJhc2VzL3NxbC85LjJfcGx1cy9zdGF0cy5z cWwKQEAgLTE3LDExICsxNywxMSBAQCBTRUxFQ1QKICAgICBzbGF2ZS5jb25m bF9idWZmZXJwaW4gQVMge3sgY29ubnxxdElkZW50KF8oJ0J1ZmZlcnBpbiBj b25mbGljdHMnKSkgfX0sCiAgICAgc2xhdmUuY29uZmxfZGVhZGxvY2sgQVMg e3sgY29ubnxxdElkZW50KF8oJ0RlYWRsb2NrIGNvbmZsaWN0cycpKSB9fSwK ICAgICB0ZW1wX2ZpbGVzIEFTIHt7IGNvbm58cXRJZGVudChfKCJUZW1wb3Jh cnkgZmlsZXMiKSkgfX0sCi0gICAgcGdfc2l6ZV9wcmV0dHkodGVtcF9ieXRl cykgQVMge3sgY29ubnxxdElkZW50KF8oIlNpemUgb2YgdGVtcG9yYXJ5IGZp bGVzIikpIH19LAorICAgIHslIGlmIG5vdCBkaWQgJX10ZW1wX2J5dGVzeyUg ZWxzZSAlfXBnX3NpemVfcHJldHR5KHRlbXBfYnl0ZXMpeyUgZW5kaWYgJX0g QVMge3sgY29ubnxxdElkZW50KF8oIlNpemUgb2YgdGVtcG9yYXJ5IGZpbGVz IikpIH19LAogICAgIGRlYWRsb2NrcyBBUyB7eyBjb25ufHF0SWRlbnQoXygi RGVhZGxvY2tzIikpIH19LAogICAgIGJsa19yZWFkX3RpbWUgQVMge3sgY29u bnxxdElkZW50KF8oIkJsb2NrIHJlYWQgdGltZSIpKSB9fSwKICAgICBibGtf d3JpdGVfdGltZSBBUyB7eyBjb25ufHF0SWRlbnQoXygiQmxvY2sgd3JpdGUg dGltZSIpKSB9fSwKLSAgICBwZ19zaXplX3ByZXR0eShwZ19kYXRhYmFzZV9z aXplKGRiLmRhdGlkKSkgQVMge3sgY29ubnxxdElkZW50KF8oJ1NpemUnKSkg fX0KKyAgICB7JSBpZiBub3QgZGlkICV9cGdfZGF0YWJhc2Vfc2l6ZShkYi5k YXRpZCl7JSBlbHNlICV9cGdfc2l6ZV9wcmV0dHkocGdfZGF0YWJhc2Vfc2l6 ZShkYi5kYXRpZCkpeyUgZW5kaWYgJX0gQVMge3sgY29ubnxxdElkZW50KF8o J1NpemUnKSkgfX0KIEZST00KICAgICBwZ19zdGF0X2RhdGFiYXNlIGRiCiAg ICAgTEVGVCBKT0lOIHBnX3N0YXRfZGF0YWJhc2VfY29uZmxpY3RzIHNsYXZl IE9OIGRiLmRhdGlkPXNsYXZlLmRhdGlkCmRpZmYgLS1naXQgYS93ZWIvcGdh ZG1pbi9icm93c2VyL3NlcnZlcl9ncm91cHMvc2VydmVycy9kYXRhYmFzZXMv dGVtcGxhdGVzL2RhdGFiYXNlcy9zcWwvZGVmYXVsdC9zdGF0cy5zcWwgYi93 ZWIvcGdhZG1pbi9icm93c2VyL3NlcnZlcl9ncm91cHMvc2VydmVycy9kYXRh YmFzZXMvdGVtcGxhdGVzL2RhdGFiYXNlcy9zcWwvZGVmYXVsdC9zdGF0cy5z cWwKaW5kZXggODJiNTJkMC4uMjA2NjFlYiAxMDA2NDQKLS0tIGEvd2ViL3Bn YWRtaW4vYnJvd3Nlci9zZXJ2ZXJfZ3JvdXBzL3NlcnZlcnMvZGF0YWJhc2Vz L3RlbXBsYXRlcy9kYXRhYmFzZXMvc3FsL2RlZmF1bHQvc3RhdHMuc3FsCisr KyBiL3dlYi9wZ2FkbWluL2Jyb3dzZXIvc2VydmVyX2dyb3Vwcy9zZXJ2ZXJz L2RhdGFiYXNlcy90ZW1wbGF0ZXMvZGF0YWJhc2VzL3NxbC9kZWZhdWx0L3N0 YXRzLnNxbApAQCAtMTYsNyArMTYsNyBAQCBTRUxFQ1QKICAgICBzbGF2ZS5j b25mbF9zbmFwc2hvdCBBUyB7eyBjb25ufHF0SWRlbnQoXygnU25hcHNob3Qg Y29uZmxpY3RzJykpIH19LAogICAgIHNsYXZlLmNvbmZsX2J1ZmZlcnBpbiBB UyB7eyBjb25ufHF0SWRlbnQoXygnQnVmZmVycGluIGNvbmZsaWN0cycpKSB9 fSwKICAgICBzbGF2ZS5jb25mbF9kZWFkbG9jayBBUyB7eyBjb25ufHF0SWRl bnQoXygnRGVhZGxvY2sgY29uZmxpY3RzJykpIH19LAotICAgIHBnX3NpemVf cHJldHR5KHBnX2RhdGFiYXNlX3NpemUoZGIuZGF0aWQpKSBBUyB7eyBjb25u fHF0SWRlbnQoXygnU2l6ZScpKSB9fQorICAgIHslIGlmIG5vdCBkaWQgJX1w Z19kYXRhYmFzZV9zaXplKGRiLmRhdGlkKXslIGVsc2UgJX1wZ19zaXplX3By ZXR0eShwZ19kYXRhYmFzZV9zaXplKGRiLmRhdGlkKSl7JSBlbmRpZiAlfSBB UyB7eyBjb25ufHF0SWRlbnQoXygnU2l6ZScpKSB9fQogRlJPTQogICAgIHBn X3N0YXRfZGF0YWJhc2UgZGIKICAgICBMRUZUIEpPSU4gcGdfc3RhdF9kYXRh YmFzZV9jb25mbGljdHMgc2xhdmUgT04gZGIuZGF0aWQ9c2xhdmUuZGF0aWQK ZGlmZiAtLWdpdCBhL3dlYi9wZ2FkbWluL2Jyb3dzZXIvc2VydmVyX2dyb3Vw cy9zZXJ2ZXJzL3RhYmxlc3BhY2VzL19faW5pdF9fLnB5IGIvd2ViL3BnYWRt aW4vYnJvd3Nlci9zZXJ2ZXJfZ3JvdXBzL3NlcnZlcnMvdGFibGVzcGFjZXMv X19pbml0X18ucHkKaW5kZXggODZlZmZlZC4uODhmOTJjOCAxMDA2NDQKLS0t IGEvd2ViL3BnYWRtaW4vYnJvd3Nlci9zZXJ2ZXJfZ3JvdXBzL3NlcnZlcnMv dGFibGVzcGFjZXMvX19pbml0X18ucHkKKysrIGIvd2ViL3BnYWRtaW4vYnJv d3Nlci9zZXJ2ZXJfZ3JvdXBzL3NlcnZlcnMvdGFibGVzcGFjZXMvX19pbml0 X18ucHkKQEAgLTU4OSw2ICs1ODksMTMgQEAgY2xhc3MgVGFibGVzcGFjZVZp ZXcoUEdDaGlsZE5vZGVWaWV3KToKICAgICAgICAgaWYgbm90IHN0YXR1czoK ICAgICAgICAgICAgIHJldHVybiBpbnRlcm5hbF9zZXJ2ZXJfZXJyb3IoZXJy b3Jtc2c9cmVzKQogCisgICAgICAgIGlmIG5vdCB0c2lkOgorICAgICAgICAg ICAgIyBXaGV0aGVyIHRoZSBjb2x1bW4gbmVlZHMgcHJldHRpZnkgYXQgdGhl IGNsaWVudCBzaWRlIG9yIG5vdAorICAgICAgICAgICAgaWYgJ2NvbHVtbnMn IGluIHJlczoKKyAgICAgICAgICAgICAgICBmb3IgY29sIGluIHJlc1snY29s dW1ucyddOgorICAgICAgICAgICAgICAgICAgICBpZiBjb2xbJ25hbWUnXSBp biBbJ1NpemUnXToKKyAgICAgICAgICAgICAgICAgICAgICAgIGNvbFsnY2Fu X3ByZXR0aWZ5J10gPSBUcnVlCisKICAgICAgICAgcmV0dXJuIG1ha2VfanNv bl9yZXNwb25zZSgKICAgICAgICAgICAgIGRhdGE9cmVzLAogICAgICAgICAg ICAgc3RhdHVzPTIwMApkaWZmIC0tZ2l0IGEvd2ViL3BnYWRtaW4vYnJvd3Nl ci9zZXJ2ZXJfZ3JvdXBzL3NlcnZlcnMvdGFibGVzcGFjZXMvdGVtcGxhdGVz L3RhYmxlc3BhY2VzL3NxbC9kZWZhdWx0L3N0YXRzLnNxbCBiL3dlYi9wZ2Fk bWluL2Jyb3dzZXIvc2VydmVyX2dyb3Vwcy9zZXJ2ZXJzL3RhYmxlc3BhY2Vz L3RlbXBsYXRlcy90YWJsZXNwYWNlcy9zcWwvZGVmYXVsdC9zdGF0cy5zcWwK aW5kZXggM2Y5MWIwMi4uNDg1YjNmYyAxMDA2NDQKLS0tIGEvd2ViL3BnYWRt aW4vYnJvd3Nlci9zZXJ2ZXJfZ3JvdXBzL3NlcnZlcnMvdGFibGVzcGFjZXMv dGVtcGxhdGVzL3RhYmxlc3BhY2VzL3NxbC9kZWZhdWx0L3N0YXRzLnNxbAor KysgYi93ZWIvcGdhZG1pbi9icm93c2VyL3NlcnZlcl9ncm91cHMvc2VydmVy cy90YWJsZXNwYWNlcy90ZW1wbGF0ZXMvdGFibGVzcGFjZXMvc3FsL2RlZmF1 bHQvc3RhdHMuc3FsCkBAIC0zLDcgKzMsNyBAQAogU0VMRUNUIHBnX3NpemVf cHJldHR5KHBnX3RhYmxlc3BhY2Vfc2l6ZSh7eyB0c2lkfHF0TGl0ZXJhbCB9 fTo6T0lEKSkgQVMge3sgY29ubnxxdElkZW50KF8oJ1NpemUnKSkgfX0KIHsl IGVsc2UgJX0KIFNFTEVDVCB0cy5zcGNuYW1lIEFTIHt7IGNvbm58cXRJZGVu dChfKCdOYW1lJykpIH19LAotICAgIHBnX3NpemVfcHJldHR5KHBnX3RhYmxl c3BhY2Vfc2l6ZSh0cy5vaWQpKSBBUyB7eyBjb25ufHF0SWRlbnQoXygnU2l6 ZScpKSB9fQorICAgIHBnX3RhYmxlc3BhY2Vfc2l6ZSh0cy5vaWQpIEFTIHt7 IGNvbm58cXRJZGVudChfKCdTaXplJykpIH19CiBGUk9NCiAgICAgcGdfY2F0 YWxvZy5wZ190YWJsZXNwYWNlIHRzOwogeyUgZW5kaWYgJX0KZGlmZiAtLWdp dCBhL3dlYi9wZ2FkbWluL21pc2Mvc3RhdGlzdGljcy9zdGF0aWMvanMvc3Rh dGlzdGljcy5qcyBiL3dlYi9wZ2FkbWluL21pc2Mvc3RhdGlzdGljcy9zdGF0 aWMvanMvc3RhdGlzdGljcy5qcwppbmRleCAxMTkxYjE2Li4zMzM3OTYwIDEw MDY0NAotLS0gYS93ZWIvcGdhZG1pbi9taXNjL3N0YXRpc3RpY3Mvc3RhdGlj L2pzL3N0YXRpc3RpY3MuanMKKysrIGIvd2ViL3BnYWRtaW4vbWlzYy9zdGF0 aXN0aWNzL3N0YXRpYy9qcy9zdGF0aXN0aWNzLmpzCkBAIC0xMiw2ICsxMiwy OSBAQCBkZWZpbmUoWwogICAgIHJldHVybiBwZ0Jyb3dzZXIuTm9kZVN0YXRp c3RpY3M7CiAgIH0KIAorICB2YXIgU2l6ZUZvcm1hdHRlciA9IEJhY2tncmlk LlNpemVGb3JtYXR0ZXIgPSBmdW5jdGlvbiAoKSB7fTsKKyAgXy5leHRlbmQo U2l6ZUZvcm1hdHRlci5wcm90b3R5cGUsIHsKKyAgICAgIC8qKgorICAgICAg ICAgVGFrZXMgYSByYXcgdmFsdWUgZnJvbSBhIG1vZGVsIGFuZCByZXR1cm5z IHRoZSBodW1hbiByZWFkYWJsZSBmb3JtYXR0ZWQKKyAgICAgICAgIHN0cmlu ZyBmb3IgZGlzcGxheS4KKworICAgICAgICAgQG1lbWJlciBCYWNrZ3JpZC5T aXplRm9ybWF0dGVyCisgICAgICAgICBAcGFyYW0geyp9IHJhd0RhdGEKKyAg ICAgICAgIEBwYXJhbSB7QmFja2JvbmUuTW9kZWx9IG1vZGVsIFVzZWQgZm9y IG1vcmUgY29tcGxpY2F0ZWQgZm9ybWF0dGluZworICAgICAgICAgQHJldHVy biB7Kn0KKyAgICAgICovCisgICAgICBmcm9tUmF3OiBmdW5jdGlvbiAocmF3 RGF0YSwgbW9kZWwpIHsKKyAgICAgICAgIHZhciBzaXplcyA9IFsnQnl0ZXMn LCAnS0InLCAnTUInLCAnR0InLCAnVEInXTsKKyAgICAgICAgIGlmIChyYXdE YXRhID09IDApIHJldHVybiAwOworICAgICAgICAgdmFyIGkgPSBwYXJzZUlu dChNYXRoLmZsb29yKE1hdGgubG9nKHJhd0RhdGEpIC8gTWF0aC5sb2coMTAy NCkpKTsKKyAgICAgICAgIGlmIChpID09IDApIHJldHVybiByYXdEYXRhICsg JyAnICsgc2l6ZXNbaV07CisgICAgICAgICByZXR1cm4gKHJhd0RhdGEgLyBN YXRoLnBvdygxMDI0LCBpKSkudG9GaXhlZCgxKSArICcgJyArIHNpemVzW2ld OworICAgICAgfSwKKyAgICAgIHRvUmF3OiBmdW5jdGlvbiAoZm9ybWF0dGVk RGF0YSwgbW9kZWwpIHsKKyAgICAgICAgcmV0dXJuIGZvcm1hdHRlZERhdGE7 CisgICAgICB9CisgIH0pOworCiAgIHZhciBQR0Jvb2xlYW5DZWxsID0gQmFj a2dyaWQuRXh0ZW5zaW9uLlN3aXRjaENlbGwuZXh0ZW5kKHsKICAgICAgIGRl ZmF1bHRzOiBfLmV4dGVuZCh7fSwgQmFja2dyaWQuRXh0ZW5zaW9uLlN3aXRj aENlbGwucHJvdG90eXBlLmRlZmF1bHRzKQogICB9KSwKQEAgLTMwMCwxMiAr MzIzLDE3IEBAIGRlZmluZShbCiAKICAgICAgIHRoaXMuY29sdW1ucyA9IFtd OwogICAgICAgZm9yICh2YXIgaWR4IGluIGNvbHVtbnMpIHsKLSAgICAgICAg dmFyIGMgPSBjb2x1bW5zW2lkeF07Ci0gICAgICAgIHRoaXMuY29sdW1ucy5w dXNoKHsKLSAgICAgICAgICBlZGl0YWJsZTogZmFsc2UsCi0gICAgICAgICAg bmFtZTogY1snbmFtZSddLAotICAgICAgICAgIGNlbGw6IHR5cGVDZWxsTWFw cGVyW2NbJ3R5cGVfY29kZSddXSB8fCAnc3RyaW5nJwotICAgICAgICB9KTsK KyAgICAgICAgdmFyIGMgPSBjb2x1bW5zW2lkeF0sCisgICAgICAgICAgICBj b2wgPSB7CisgICAgICAgICAgICBlZGl0YWJsZTogZmFsc2UsCisgICAgICAg ICAgICBuYW1lOiBjWyduYW1lJ10sCisgICAgICAgICAgICBjZWxsOiB0eXBl Q2VsbE1hcHBlcltjWyd0eXBlX2NvZGUnXV0gfHwgJ3N0cmluZycKKyAgICAg ICAgICAgfTsKKyAgICAgICAgICAgaWYgKCdjYW5fcHJldHRpZnknIGluIGMg JiYgY1snY2FuX3ByZXR0aWZ5J10pIHsKKyAgICAgICAgICAgIGNvbFsnZm9y bWF0dGVyJ10gPSBTaXplRm9ybWF0dGVyCisgICAgICAgICAgIH0KKyAgICAg ICAgdGhpcy5jb2x1bW5zLnB1c2goY29sKTsKKwogICAgICAgfQogCiAgICAg ICB0aGlzLmNvbGxlY3Rpb24ucmVzZXQocm93cyk7Cg== --f40304354dd4ac7e76054dfa34e3 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 --f40304354dd4ac7e76054dfa34e3--