Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1esr3T-0002z1-RZ for pgadmin-hackers@arkaria.postgresql.org; Mon, 05 Mar 2018 14:25:32 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1esr3S-0001Hp-Kh for pgadmin-hackers@arkaria.postgresql.org; Mon, 05 Mar 2018 14:25:30 +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.89) (envelope-from ) id 1esr3R-00018X-L8 for pgadmin-hackers@lists.postgresql.org; Mon, 05 Mar 2018 14:25:29 +0000 Received: from mail-io0-x230.google.com ([2607:f8b0:4001:c06::230]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1esr3M-0002p0-QC for pgadmin-hackers@postgresql.org; Mon, 05 Mar 2018 14:25:28 +0000 Received: by mail-io0-x230.google.com with SMTP id f1so18170021iob.0 for ; Mon, 05 Mar 2018 06:25:23 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=pivotal-io.20150623.gappssmtp.com; s=20150623; h=mime-version:from:date:message-id:subject:to; bh=QCCrsBSjtSqglUnMZcUditBwMncvtM3D+ISV+nwatu4=; b=T6jwiqdiKTdoLJDUr74/ej9elGfeHNDqS5fQega4OZy9uBkdhOJNoBE5iR4nFTTwAY WCAw8z8BpUJvbkByNrLalpzMTKoOxWNymLzrpFQzeNiZxKaSaTiHOMQo4RT9RpcaxrYT S3YE4qluoAYx+gFD8wjU5g0pDH0bsc+Zm8BTvIzFqzaYwmbmyVGePoUDsByPL2O9YqQg OT6dG2FQ+f2R9I7W4P5Whe4XvEVxwMetNn0fXW1riXtnqjW/4wwaRYx+gzhrmeUOTbld WhCGhpGLA8LvQBSNkkQfn9PKkIGg/qDHcltSyYMsjZeeoaLGwSlTRXHUeRdKn8C/Fg4Z fLpQ== 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=QCCrsBSjtSqglUnMZcUditBwMncvtM3D+ISV+nwatu4=; b=pUEHbxQWAZdDhsPqJ42VSnQjEFVB5ZxKZfoPzTEGNdPHihu/xUGORNzL/Y5lJxTp2t Ah3k5PClbTHq45U7wRMQKEPn4HRCpQIoailhkwtYJHNlL+75h54NrIK/OGgytCflpjYi OPkQKMRLx53GZQXHGRpSOPHIHGqINU2HxE6s6DMa4/3FBptX8+5s6U+Ww8gZ9+XRhizh QXPfCnOxtO5sTmAG1/e3kiIrOHpUEC5aWKVhVZH+sdtr6+DC88XEJdP3TFa9knccYuyR f4c8MYjB94C2x3O5a5mYBg3o0KH5SxthP3wRLzUHfuD9ZoZ2StqNb3akJKrkVLJn4TIH K8Xg== X-Gm-Message-State: APf1xPAHlPushoxhEbsxGMg2z7vQeVuEXZc0aWxE6bWpRBqx83CGXPiD wjEIoqpUBzS0TpNp48HCQ89WxgYwoZ752Jr1OIyeiQ== X-Google-Smtp-Source: AG47ELvPJ1sIKPuSSxu+C4tq4QM8A9Wrj0i0O2EmHF9RLQNBjL12NClUWA9Bj8Xe6pIKinUSf76lCXBUcwpa9ZgESlI= X-Received: by 10.107.38.80 with SMTP id m77mr17613039iom.69.1520259921114; Mon, 05 Mar 2018 06:25:21 -0800 (PST) MIME-Version: 1.0 From: Joao De Almeida Pereira Date: Mon, 05 Mar 2018 14:25:10 +0000 Message-ID: Subject: [pgadmin4][patch] GreenPlum function statistics through an exception To: pgadmin-hackers Content-Type: multipart/mixed; boundary="001a1140c28490c1990566ab186c" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --001a1140c28490c1990566ab186c Content-Type: multipart/alternative; boundary="001a1140c28490c1960566ab186a" --001a1140c28490c1960566ab186a Content-Type: text/plain; charset="UTF-8" Hi Hackers, You can find attached the resolution for issue 3176. When trying to retrieve the statistics from a function in a GreenPlum database an error is displayed, To fix this for version 5.X we decided to remove the ability to get statistics. Thanks Joao --001a1140c28490c1960566ab186a Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi Hackers,
You can find attached the resolution for i= ssue 3176.
When trying to retrieve the statistics from a function= in a GreenPlum database an error is displayed, To fix this for version 5.X= we decided to remove the ability to get statistics.

Thanks
Joao=C2=A0
--001a1140c28490c1960566ab186a-- --001a1140c28490c1990566ab186c Content-Type: text/x-patch; charset="US-ASCII"; name="display-statistics-error-on-functions.diff" Content-Disposition: attachment; filename="display-statistics-error-on-functions.diff" Content-Transfer-Encoding: base64 Content-ID: <161f68d313394b6d5e21> X-Attachment-Id: 161f68d313394b6d5e21 ZGlmZiAtLWdpdCBhL3dlYi9wZ2FkbWluL2Jyb3dzZXIvc2VydmVyX2dyb3Vwcy9zZXJ2ZXJzL2Rh dGFiYXNlcy9zY2hlbWFzL2Z1bmN0aW9ucy9zdGF0aWMvanMvZnVuY3Rpb24uanMgYi93ZWIvcGdh ZG1pbi9icm93c2VyL3NlcnZlcl9ncm91cHMvc2VydmVycy9kYXRhYmFzZXMvc2NoZW1hcy9mdW5j dGlvbnMvc3RhdGljL2pzL2Z1bmN0aW9uLmpzCmluZGV4IDc2MjJjZDBiLi42ZTQwNTE2NSAxMDA2 NDQKLS0tIGEvd2ViL3BnYWRtaW4vYnJvd3Nlci9zZXJ2ZXJfZ3JvdXBzL3NlcnZlcnMvZGF0YWJh c2VzL3NjaGVtYXMvZnVuY3Rpb25zL3N0YXRpYy9qcy9mdW5jdGlvbi5qcworKysgYi93ZWIvcGdh ZG1pbi9icm93c2VyL3NlcnZlcl9ncm91cHMvc2VydmVycy9kYXRhYmFzZXMvc2NoZW1hcy9mdW5j dGlvbnMvc3RhdGljL2pzL2Z1bmN0aW9uLmpzCkBAIC05Miw3ICs5Miw5IEBAIGRlZmluZSgncGdh ZG1pbi5ub2RlLmZ1bmN0aW9uJywgWwogICAgICAgY29sbGVjdGlvbl90eXBlOiAnY29sbC1mdW5j dGlvbicsCiAgICAgICBoYXNTUUw6IHRydWUsCiAgICAgICBoYXNEZXBlbmRzOiB0cnVlLAotICAg ICAgaGFzU3RhdGlzdGljczogdHJ1ZSwKKyAgICAgIGhhc1N0YXRpc3RpY3M6ICh0cmVlSW5mb3Jt YXRpb24pID0+IHsKKyAgICAgICAgcmV0dXJuIHRyZWVJbmZvcm1hdGlvbi5zZXJ2ZXIuc2VydmVy X3R5cGUgIT09ICdncGRiJzsKKyAgICAgIH0sCiAgICAgICBoYXNTY3JpcHRUeXBlczogWydjcmVh dGUnLCAnc2VsZWN0J10sCiAgICAgICBwYXJlbnRfdHlwZTogWydzY2hlbWEnLCAnY2F0YWxvZydd LAogICAgICAgSW5pdDogZnVuY3Rpb24oKSB7CmRpZmYgLS1naXQgYS93ZWIvcGdhZG1pbi9taXNj L3N0YXRpc3RpY3Mvc3RhdGljL2pzL3N0YXRpc3RpY3MuanMgYi93ZWIvcGdhZG1pbi9taXNjL3N0 YXRpc3RpY3Mvc3RhdGljL2pzL3N0YXRpc3RpY3MuanMKaW5kZXggMzlmZjdiYjMuLjNmZjg4YTBh IDEwMDY0NAotLS0gYS93ZWIvcGdhZG1pbi9taXNjL3N0YXRpc3RpY3Mvc3RhdGljL2pzL3N0YXRp c3RpY3MuanMKKysrIGIvd2ViL3BnYWRtaW4vbWlzYy9zdGF0aXN0aWNzL3N0YXRpYy9qcy9zdGF0 aXN0aWNzLmpzCkBAIC0xLDggKzEsMTAgQEAKIGRlZmluZSgnbWlzYy5zdGF0aXN0aWNzJywgWwog ICAnc291cmNlcy9nZXR0ZXh0JywgJ3VuZGVyc2NvcmUnLCAndW5kZXJzY29yZS5zdHJpbmcnLCAn anF1ZXJ5JywgJ2JhY2tib25lJywKICAgJ3BnYWRtaW4uYnJvd3NlcicsICdwZ2FkbWluLmJhY2tn cmlkJywgJ2FsZXJ0aWZ5JywgJ3NvdXJjZXMvc2l6ZV9wcmV0dGlmeScsCisgICdzb3VyY2VzL21p c2Mvc3RhdGlzdGljcy9zdGF0aXN0aWNzJywKIF0sIGZ1bmN0aW9uKAotICBnZXR0ZXh0LCBfLCBT LCAkLCBCYWNrYm9uZSwgcGdCcm93c2VyLCBCYWNrZ3JpZCwgQWxlcnRpZnksIHNpemVQcmV0dGlm eQorICBnZXR0ZXh0LCBfLCBTLCAkLCBCYWNrYm9uZSwgcGdCcm93c2VyLCBCYWNrZ3JpZCwgQWxl cnRpZnksIHNpemVQcmV0dGlmeSwKKyAgc3RhdGlzdGljc0hlbHBlcgogKSB7CiAKICAgaWYgKHBn QnJvd3Nlci5Ob2RlU3RhdGlzdGljcykKQEAgLTIwOCw3ICsyMTAsNyBAQCBkZWZpbmUoJ21pc2Mu c3RhdGlzdGljcycsIFsKICAgICAgICAgLy8gQ2FjaGUgdGhlIGN1cnJlbnQgSURzIGZvciBuZXh0 IHRpbWUKICAgICAgICAgJChwYW5lbFswXSkuZGF0YSgnbm9kZS1wcm9wJywgY2FjaGVfZmxhZyk7 CiAKLSAgICAgICAgaWYgKG5vZGUuaGFzU3RhdGlzdGljcykgeworICAgICAgICBpZiAoc3RhdGlz dGljc0hlbHBlci5ub2RlSGFzU3RhdGlzdGljcyhub2RlLCBpdGVtKSkgewogICAgICAgICAgIG1z ZyA9ICcnOwogICAgICAgICAgIHZhciB0aW1lcjsKICAgICAgICAgICAvLyBTZXQgdGhlIHVybCwg ZmV0Y2ggdGhlIGRhdGEgYW5kIHVwZGF0ZSB0aGUgY29sbGVjdGlvbgpkaWZmIC0tZ2l0IGEvd2Vi L3BnYWRtaW4vc3RhdGljL2pzL21pc2Mvc3RhdGlzdGljcy9zdGF0aXN0aWNzLmpzIGIvd2ViL3Bn YWRtaW4vc3RhdGljL2pzL21pc2Mvc3RhdGlzdGljcy9zdGF0aXN0aWNzLmpzCm5ldyBmaWxlIG1v ZGUgMTAwNjQ0CmluZGV4IDAwMDAwMDAwLi4yYWFiYzc1YgotLS0gL2Rldi9udWxsCisrKyBiL3dl Yi9wZ2FkbWluL3N0YXRpYy9qcy9taXNjL3N0YXRpc3RpY3Mvc3RhdGlzdGljcy5qcwpAQCAtMCww ICsxLDE1IEBACisvLy8vLy8vLy8vLy8vLy8vLy8vLy8vLy8vLy8vLy8vLy8vLy8vLy8vLy8vLy8v Ly8vLy8vLy8vLy8vLy8vLy8vLy8vLy8vLy8vLworLy8KKy8vIHBnQWRtaW4gNCAtIFBvc3RncmVT UUwgVG9vbHMKKy8vCisvLyBDb3B5cmlnaHQgKEMpIDIwMTMgLSAyMDE4LCBUaGUgcGdBZG1pbiBE ZXZlbG9wbWVudCBUZWFtCisvLyBUaGlzIHNvZnR3YXJlIGlzIHJlbGVhc2VkIHVuZGVyIHRoZSBQ b3N0Z3JlU1FMIExpY2VuY2UKKy8vCisvLy8vLy8vLy8vLy8vLy8vLy8vLy8vLy8vLy8vLy8vLy8v Ly8vLy8vLy8vLy8vLy8vLy8vLy8vLy8vLy8vLy8vLy8vLy8vLy8vLworZXhwb3J0IGZ1bmN0aW9u IG5vZGVIYXNTdGF0aXN0aWNzKG5vZGUsIGl0ZW0pIHsKKyAgaWYodHlwZW9mKG5vZGUuaGFzU3Rh dGlzdGljcykgPT09ICdmdW5jdGlvbicpIHsKKyAgICBjb25zdCB0cmVlSGllcmFyY2h5ID0gbm9k ZS5nZXRUcmVlTm9kZUhpZXJhcmNoeShpdGVtKTsKKyAgICByZXR1cm4gbm9kZS5oYXNTdGF0aXN0 aWNzKHRyZWVIaWVyYXJjaHkpOworICB9CisgIHJldHVybiBub2RlLmhhc1N0YXRpc3RpY3M7Cit9 CmRpZmYgLS1naXQgYS93ZWIvcmVncmVzc2lvbi9qYXZhc2NyaXB0L21pc2Mvc3RhdGlzdGljcy9z dGF0aXN0aWNzX3NwZWMuanMgYi93ZWIvcmVncmVzc2lvbi9qYXZhc2NyaXB0L21pc2Mvc3RhdGlz dGljcy9zdGF0aXN0aWNzX3NwZWMuanMKbmV3IGZpbGUgbW9kZSAxMDA2NDQKaW5kZXggMDAwMDAw MDAuLjg3NTQwZDEwCi0tLSAvZGV2L251bGwKKysrIGIvd2ViL3JlZ3Jlc3Npb24vamF2YXNjcmlw dC9taXNjL3N0YXRpc3RpY3Mvc3RhdGlzdGljc19zcGVjLmpzCkBAIC0wLDAgKzEsMzUgQEAKKy8v Ly8vLy8vLy8vLy8vLy8vLy8vLy8vLy8vLy8vLy8vLy8vLy8vLy8vLy8vLy8vLy8vLy8vLy8vLy8v Ly8vLy8vLy8vLy8vLy8vCisvLworLy8gcGdBZG1pbiA0IC0gUG9zdGdyZVNRTCBUb29scworLy8K Ky8vIENvcHlyaWdodCAoQykgMjAxMyAtIDIwMTgsIFRoZSBwZ0FkbWluIERldmVsb3BtZW50IFRl YW0KKy8vIFRoaXMgc29mdHdhcmUgaXMgcmVsZWFzZWQgdW5kZXIgdGhlIFBvc3RncmVTUUwgTGlj ZW5jZQorLy8KKy8vLy8vLy8vLy8vLy8vLy8vLy8vLy8vLy8vLy8vLy8vLy8vLy8vLy8vLy8vLy8v Ly8vLy8vLy8vLy8vLy8vLy8vLy8vLy8vLy8vCitpbXBvcnQge25vZGVIYXNTdGF0aXN0aWNzfSBm cm9tICIuLi8uLi8uLi8uLi9wZ2FkbWluL3N0YXRpYy9qcy9taXNjL3N0YXRpc3RpY3Mvc3RhdGlz dGljcyI7CisKK2Rlc2NyaWJlKCcjbm9kZUhhc1N0YXRpc3RpY3MnLCAoKSA9PiB7CisgIGRlc2Ny aWJlKCd3aGVuIG5vZGUgaGFzU3RhdGlzdGljcyBpcyBub3QgYSBmdW5jdGlvbicsICgpID0+IHsK KyAgICBpdCgncmV0dXJuIHRoZSB2YWx1ZSBvZiBoYXNTdGF0aXN0aWNzJywgKCkgPT4geworICAg ICAgY29uc3Qgbm9kZSA9IHsKKyAgICAgICAgaGFzU3RhdGlzdGljczogdHJ1ZSwKKyAgICAgIH07 CisgICAgICBleHBlY3Qobm9kZUhhc1N0YXRpc3RpY3Mobm9kZSwge30pKS50b0JlKHRydWUpOwor ICAgIH0pOworICB9KTsKKworICBkZXNjcmliZSgnd2hlbiBub2RlIGhhc1N0YXRpc3RpY3MgaXMg YSBmdW5jdGlvbicsICgpID0+IHsKKyAgICBkZXNjcmliZSgnd2hlbiB0aGUgZnVuY3Rpb24gcmV0 dXJucyB0cnVlJywgKCkgPT4geworICAgICAgaXQoJ3JldHVybnMgdHJ1ZScsICgpID0+IHsKKyAg ICAgICAgY29uc3Qgbm9kZSA9IHsKKyAgICAgICAgICBoYXNTdGF0aXN0aWNzOiAoKSA9PiB0cnVl LAorICAgICAgICAgIGdldFRyZWVOb2RlSGllcmFyY2h5OiBqYXNtaW5lLmNyZWF0ZVNweSgpLAor ICAgICAgICB9OworICAgICAgICBjb25zdCBpdGVtID0ge307CisKKyAgICAgICAgZXhwZWN0KG5v ZGVIYXNTdGF0aXN0aWNzKG5vZGUsIGl0ZW0pKS50b0JlKHRydWUpOworICAgICAgICBleHBlY3Qo bm9kZS5nZXRUcmVlTm9kZUhpZXJhcmNoeSkudG9IYXZlQmVlbkNhbGxlZFdpdGgoaXRlbSk7Cisg ICAgICB9KTsKKyAgICB9KTsKKyAgfSk7Cit9KTsK --001a1140c28490c1990566ab186c--