Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1iiFET-0008Qf-Tv for pgadmin-hackers@arkaria.postgresql.org; Fri, 20 Dec 2019 10:10:06 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1iiFES-0003BD-NG for pgadmin-hackers@arkaria.postgresql.org; Fri, 20 Dec 2019 10:10:04 +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_SHA1:256) (Exim 4.89) (envelope-from ) id 1iiFES-0003B6-Cj for pgadmin-hackers@lists.postgresql.org; Fri, 20 Dec 2019 10:10:04 +0000 Received: from mail-lj1-x22e.google.com ([2a00:1450:4864:20::22e]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1iiFEN-0007TX-MR for pgadmin-hackers@postgresql.org; Fri, 20 Dec 2019 10:10:01 +0000 Received: by mail-lj1-x22e.google.com with SMTP id j26so9403165ljc.12 for ; Fri, 20 Dec 2019 02:09:59 -0800 (PST) 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=Nb6acFyUym4ENuMNU2d2N5uZkXrDN4S1/R+uscp8cGM=; b=ySG2m0+0bDk6R2fJqLzNDkAoO+f167aE+ykVMlRrMhDcxRUlvXfboJiS9zR5BSd/ub mAZ+a8rLEK+Q8Htt04q02x0I0mfOjSVtorNm43CfFh/F1s56OwVQTkTHYUYZ1LB3qBUO OtSCSFlyCOqQr2PE4YRSUF0O7PVwcNuFFYmBWOprKbyh1tQRDiNvLlfI76eUlfuGGmk0 lKp2pQrLRZPea6+AMM9G85/JvvyZK7Ujii9aFqqnLTR8QyrLaEsfDNukA9jVeHjSWZS8 lGs5CE1VFQiGT2F2EX2bLkIRO0v6/W0fUsc6TQt8MlflRz0OZOvVHR/xqTBo9VBZXeNn pXCg== 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=Nb6acFyUym4ENuMNU2d2N5uZkXrDN4S1/R+uscp8cGM=; b=nU3PAZXuQYNDkh0xNQLOK4oQfQ6S7vQK6n4mVkQFbPkwell83O3txDdRFVzVQLQhFr nDVVQokRNriyx28ssj1Oe74kMgciAGFcJ4NJiOiSAZjcvTug+2M+7ohXSSvN9adxmGBs EUSR5nZGk0dhCyeg8sbHErACPS4LWPfupV+brjxHPsrgfIaP06lk3NjI3zlu8GwVO89i UsNBH+64iRenu1kkmVkAHICZGra1M/IysxAl2xseLIveTIZeevkgWjMwvMgp0DgQqt3Z DJ2pP2U/OcqMW0VnfOKZHstenIh7FCK4sbRC/p+bNcspl9gX6SAIzEjXxsFIHP3gD+04 QMOA== X-Gm-Message-State: APjAAAW51aa//Pqvc0ep8RSAH4FUV4EsCOhQgEYPFXXfCe77JFY+u8uX oHeaWg0unYCiCBTL3Y1bwBOoLPE5E/eJjOfufgWUxIObfMcSlxaUqCYVCz2Rt618JXHh8BqAcGV NdFimtVPQibfNMKJN19uYlU9e2U4whga65Yu/Wm4H3ouugVQzJyHHk0Gkc+BItickX229/jylQK GG5XbysAZ9J7PKVxk8pn+f+1S7PEs4MtH0QFCfpXXE1StYICDsKJeYQg== X-Google-Smtp-Source: APXvYqw5M2OpFakH8PBCNBLXm5mxugm5S9R2pLgOILZgUFmdQq7sn2tJuojeXoflO4GSx9MBFlMQxw41oPiW6+MfiGo= X-Received: by 2002:a2e:81c7:: with SMTP id s7mr9185521ljg.3.1576836597971; Fri, 20 Dec 2019 02:09:57 -0800 (PST) MIME-Version: 1.0 From: Khushboo Vashi Date: Fri, 20 Dec 2019 15:39:49 +0530 Message-ID: Subject: [pgAdmin4][Patch] - 5023 - Refactoring SQL of View and Materialized View. To: pgadmin-hackers Content-Type: multipart/mixed; boundary="0000000000004bc29a059a1fe1dc" X-CLOUD-SEC-AV-Info: edb,google_mail,monitor X-CLOUD-SEC-AV-Sent: true X-Gm-Spam: 0 X-Gm-Phishy: 0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --0000000000004bc29a059a1fe1dc Content-Type: multipart/alternative; boundary="0000000000004bc298059a1fe1da" --0000000000004bc298059a1fe1da Content-Type: text/plain; charset="UTF-8" Hi, Please find the attached small patch of refactoring SQL of views module. RM -5023 Thanks, Khushboo --0000000000004bc298059a1fe1da Content-Type: text/html; charset="UTF-8"
Hi,

Please find the attached small patch of refactoring SQL of views module. RM -5023

Thanks,
Khushboo
--0000000000004bc298059a1fe1da-- --0000000000004bc29a059a1fe1dc Content-Type: application/octet-stream; name="views.patch" Content-Disposition: attachment; filename="views.patch" Content-Transfer-Encoding: base64 Content-ID: X-Attachment-Id: f_k4dzrixn0 ZGlmZiAtLWdpdCBhL3dlYi9wZ2FkbWluL2Jyb3dzZXIvc2VydmVyX2dyb3Vwcy9zZXJ2ZXJzL2Rh dGFiYXNlcy9zY2hlbWFzL3ZpZXdzL3RlbXBsYXRlcy92aWV3cy9wZy85LjNfcGx1cy9zcWwvcHJv cGVydGllcy5zcWwgYi93ZWIvcGdhZG1pbi9icm93c2VyL3NlcnZlcl9ncm91cHMvc2VydmVycy9k YXRhYmFzZXMvc2NoZW1hcy92aWV3cy90ZW1wbGF0ZXMvdmlld3MvcGcvOS4zX3BsdXMvc3FsL3By b3BlcnRpZXMuc3FsCmluZGV4IDA0NWNjOWEzYy4uMTMyZTFmYzVmIDEwMDY0NAotLS0gYS93ZWIv cGdhZG1pbi9icm93c2VyL3NlcnZlcl9ncm91cHMvc2VydmVycy9kYXRhYmFzZXMvc2NoZW1hcy92 aWV3cy90ZW1wbGF0ZXMvdmlld3MvcGcvOS4zX3BsdXMvc3FsL3Byb3BlcnRpZXMuc3FsCisrKyBi L3dlYi9wZ2FkbWluL2Jyb3dzZXIvc2VydmVyX2dyb3Vwcy9zZXJ2ZXJzL2RhdGFiYXNlcy9zY2hl bWFzL3ZpZXdzL3RlbXBsYXRlcy92aWV3cy9wZy85LjNfcGx1cy9zcWwvcHJvcGVydGllcy5zcWwK QEAgLTI5LDcgKzI5LDYgQEAgRlJPTSBwZ19jbGFzcyBjCiBMRUZUIE9VVEVSIEpPSU4gcGdfbmFt ZXNwYWNlIG5zcCBvbiBuc3Aub2lkID0gYy5yZWxuYW1lc3BhY2UKIExFRlQgT1VURVIgSk9JTiBw Z190YWJsZXNwYWNlIHNwYyBvbiBzcGMub2lkPWMucmVsdGFibGVzcGFjZQogTEVGVCBPVVRFUiBK T0lOIHBnX2Rlc2NyaXB0aW9uIGRlcyBPTiAoZGVzLm9iam9pZD1jLm9pZCBhbmQgZGVzLm9ianN1 YmlkPTAgQU5EIGRlcy5jbGFzc29pZD0ncGdfY2xhc3MnOjpyZWdjbGFzcykKLUxFRlQgT1VURVIg Sk9JTiBwZ19jbGFzcyB0c3QgT04gdHN0Lm9pZCA9IGMucmVsdG9hc3RyZWxpZAogICAgIFdIRVJF ICgoYy5yZWxoYXNydWxlcyBBTkQgKEVYSVNUUyAoCiAgICAgICAgIFNFTEVDVAogICAgICAgICAg ICAgci5ydWxlbmFtZQpkaWZmIC0tZ2l0IGEvd2ViL3BnYWRtaW4vYnJvd3Nlci9zZXJ2ZXJfZ3Jv dXBzL3NlcnZlcnMvZGF0YWJhc2VzL3NjaGVtYXMvdmlld3MvdGVtcGxhdGVzL3ZpZXdzL3BnLzku NF9wbHVzL3NxbC9wcm9wZXJ0aWVzLnNxbCBiL3dlYi9wZ2FkbWluL2Jyb3dzZXIvc2VydmVyX2dy b3Vwcy9zZXJ2ZXJzL2RhdGFiYXNlcy9zY2hlbWFzL3ZpZXdzL3RlbXBsYXRlcy92aWV3cy9wZy85 LjRfcGx1cy9zcWwvcHJvcGVydGllcy5zcWwKaW5kZXggNmRlYTg2OWY3Li5kNWQwMTllODUgMTAw NjQ0Ci0tLSBhL3dlYi9wZ2FkbWluL2Jyb3dzZXIvc2VydmVyX2dyb3Vwcy9zZXJ2ZXJzL2RhdGFi YXNlcy9zY2hlbWFzL3ZpZXdzL3RlbXBsYXRlcy92aWV3cy9wZy85LjRfcGx1cy9zcWwvcHJvcGVy dGllcy5zcWwKKysrIGIvd2ViL3BnYWRtaW4vYnJvd3Nlci9zZXJ2ZXJfZ3JvdXBzL3NlcnZlcnMv ZGF0YWJhc2VzL3NjaGVtYXMvdmlld3MvdGVtcGxhdGVzL3ZpZXdzL3BnLzkuNF9wbHVzL3NxbC9w cm9wZXJ0aWVzLnNxbApAQCAtMzIsNyArMzIsNiBAQCBGUk9NIHBnX2NsYXNzIGMKIExFRlQgT1VU RVIgSk9JTiBwZ19uYW1lc3BhY2UgbnNwIG9uIG5zcC5vaWQgPSBjLnJlbG5hbWVzcGFjZQogTEVG VCBPVVRFUiBKT0lOIHBnX3RhYmxlc3BhY2Ugc3BjIG9uIHNwYy5vaWQ9Yy5yZWx0YWJsZXNwYWNl CiBMRUZUIE9VVEVSIEpPSU4gcGdfZGVzY3JpcHRpb24gZGVzIE9OIChkZXMub2Jqb2lkPWMub2lk IGFuZCBkZXMub2Jqc3ViaWQ9MCBBTkQgZGVzLmNsYXNzb2lkPSdwZ19jbGFzcyc6OnJlZ2NsYXNz KQotTEVGVCBPVVRFUiBKT0lOIHBnX2NsYXNzIHRzdCBPTiB0c3Qub2lkID0gYy5yZWx0b2FzdHJl bGlkCiAgICAgV0hFUkUgKChjLnJlbGhhc3J1bGVzIEFORCAoRVhJU1RTICgKICAgICAgICAgU0VM RUNUCiAgICAgICAgICAgICByLnJ1bGVuYW1lCmRpZmYgLS1naXQgYS93ZWIvcGdhZG1pbi9icm93 c2VyL3NlcnZlcl9ncm91cHMvc2VydmVycy9kYXRhYmFzZXMvc2NoZW1hcy92aWV3cy90ZW1wbGF0 ZXMvdmlld3MvcHBhcy85LjFfcGx1cy9zcWwvcHJvcGVydGllcy5zcWwgYi93ZWIvcGdhZG1pbi9i cm93c2VyL3NlcnZlcl9ncm91cHMvc2VydmVycy9kYXRhYmFzZXMvc2NoZW1hcy92aWV3cy90ZW1w bGF0ZXMvdmlld3MvcHBhcy85LjFfcGx1cy9zcWwvcHJvcGVydGllcy5zcWwKaW5kZXggZGE5MDUz YzE2Li43OWU0YzYyN2QgMTAwNjQ0Ci0tLSBhL3dlYi9wZ2FkbWluL2Jyb3dzZXIvc2VydmVyX2dy b3Vwcy9zZXJ2ZXJzL2RhdGFiYXNlcy9zY2hlbWFzL3ZpZXdzL3RlbXBsYXRlcy92aWV3cy9wcGFz LzkuMV9wbHVzL3NxbC9wcm9wZXJ0aWVzLnNxbAorKysgYi93ZWIvcGdhZG1pbi9icm93c2VyL3Nl cnZlcl9ncm91cHMvc2VydmVycy9kYXRhYmFzZXMvc2NoZW1hcy92aWV3cy90ZW1wbGF0ZXMvdmll d3MvcHBhcy85LjFfcGx1cy9zcWwvcHJvcGVydGllcy5zcWwKQEAgLTMxLDcgKzMxLDYgQEAgRlJP TSBwZ19jbGFzcyBjCiBMRUZUIE9VVEVSIEpPSU4gcGdfbmFtZXNwYWNlIG5zcCBvbiBuc3Aub2lk ID0gYy5yZWxuYW1lc3BhY2UKIExFRlQgT1VURVIgSk9JTiBwZ190YWJsZXNwYWNlIHNwYyBvbiBz cGMub2lkPWMucmVsdGFibGVzcGFjZQogTEVGVCBPVVRFUiBKT0lOIHBnX2Rlc2NyaXB0aW9uIGRl cyBPTiAoZGVzLm9iam9pZD1jLm9pZCBhbmQgZGVzLm9ianN1YmlkPTAgQU5EIGRlcy5jbGFzc29p ZD0ncGdfY2xhc3MnOjpyZWdjbGFzcykKLUxFRlQgT1VURVIgSk9JTiBwZ19jbGFzcyB0c3QgT04g dHN0Lm9pZCA9IGMucmVsdG9hc3RyZWxpZAogICAgIFdIRVJFICgoYy5yZWxoYXNydWxlcyBBTkQg KEVYSVNUUyAoCiAgICAgICAgIFNFTEVDVAogICAgICAgICAgICAgci5ydWxlbmFtZQpkaWZmIC0t Z2l0IGEvd2ViL3BnYWRtaW4vYnJvd3Nlci9zZXJ2ZXJfZ3JvdXBzL3NlcnZlcnMvZGF0YWJhc2Vz L3NjaGVtYXMvdmlld3MvdGVtcGxhdGVzL3ZpZXdzL3BwYXMvOS4zX3BsdXMvc3FsL3Byb3BlcnRp ZXMuc3FsIGIvd2ViL3BnYWRtaW4vYnJvd3Nlci9zZXJ2ZXJfZ3JvdXBzL3NlcnZlcnMvZGF0YWJh c2VzL3NjaGVtYXMvdmlld3MvdGVtcGxhdGVzL3ZpZXdzL3BwYXMvOS4zX3BsdXMvc3FsL3Byb3Bl cnRpZXMuc3FsCmluZGV4IDA0NWNjOWEzYy4uMTMyZTFmYzVmIDEwMDY0NAotLS0gYS93ZWIvcGdh ZG1pbi9icm93c2VyL3NlcnZlcl9ncm91cHMvc2VydmVycy9kYXRhYmFzZXMvc2NoZW1hcy92aWV3 cy90ZW1wbGF0ZXMvdmlld3MvcHBhcy85LjNfcGx1cy9zcWwvcHJvcGVydGllcy5zcWwKKysrIGIv d2ViL3BnYWRtaW4vYnJvd3Nlci9zZXJ2ZXJfZ3JvdXBzL3NlcnZlcnMvZGF0YWJhc2VzL3NjaGVt YXMvdmlld3MvdGVtcGxhdGVzL3ZpZXdzL3BwYXMvOS4zX3BsdXMvc3FsL3Byb3BlcnRpZXMuc3Fs CkBAIC0yOSw3ICsyOSw2IEBAIEZST00gcGdfY2xhc3MgYwogTEVGVCBPVVRFUiBKT0lOIHBnX25h bWVzcGFjZSBuc3Agb24gbnNwLm9pZCA9IGMucmVsbmFtZXNwYWNlCiBMRUZUIE9VVEVSIEpPSU4g cGdfdGFibGVzcGFjZSBzcGMgb24gc3BjLm9pZD1jLnJlbHRhYmxlc3BhY2UKIExFRlQgT1VURVIg Sk9JTiBwZ19kZXNjcmlwdGlvbiBkZXMgT04gKGRlcy5vYmpvaWQ9Yy5vaWQgYW5kIGRlcy5vYmpz dWJpZD0wIEFORCBkZXMuY2xhc3NvaWQ9J3BnX2NsYXNzJzo6cmVnY2xhc3MpCi1MRUZUIE9VVEVS IEpPSU4gcGdfY2xhc3MgdHN0IE9OIHRzdC5vaWQgPSBjLnJlbHRvYXN0cmVsaWQKICAgICBXSEVS RSAoKGMucmVsaGFzcnVsZXMgQU5EIChFWElTVFMgKAogICAgICAgICBTRUxFQ1QKICAgICAgICAg ICAgIHIucnVsZW5hbWUKZGlmZiAtLWdpdCBhL3dlYi9wZ2FkbWluL2Jyb3dzZXIvc2VydmVyX2dy b3Vwcy9zZXJ2ZXJzL2RhdGFiYXNlcy9zY2hlbWFzL3ZpZXdzL3RlbXBsYXRlcy92aWV3cy9wcGFz LzkuNF9wbHVzL3NxbC9wcm9wZXJ0aWVzLnNxbCBiL3dlYi9wZ2FkbWluL2Jyb3dzZXIvc2VydmVy X2dyb3Vwcy9zZXJ2ZXJzL2RhdGFiYXNlcy9zY2hlbWFzL3ZpZXdzL3RlbXBsYXRlcy92aWV3cy9w cGFzLzkuNF9wbHVzL3NxbC9wcm9wZXJ0aWVzLnNxbAppbmRleCA2ZGVhODY5ZjcuLmQ1ZDAxOWU4 NSAxMDA2NDQKLS0tIGEvd2ViL3BnYWRtaW4vYnJvd3Nlci9zZXJ2ZXJfZ3JvdXBzL3NlcnZlcnMv ZGF0YWJhc2VzL3NjaGVtYXMvdmlld3MvdGVtcGxhdGVzL3ZpZXdzL3BwYXMvOS40X3BsdXMvc3Fs L3Byb3BlcnRpZXMuc3FsCisrKyBiL3dlYi9wZ2FkbWluL2Jyb3dzZXIvc2VydmVyX2dyb3Vwcy9z ZXJ2ZXJzL2RhdGFiYXNlcy9zY2hlbWFzL3ZpZXdzL3RlbXBsYXRlcy92aWV3cy9wcGFzLzkuNF9w bHVzL3NxbC9wcm9wZXJ0aWVzLnNxbApAQCAtMzIsNyArMzIsNiBAQCBGUk9NIHBnX2NsYXNzIGMK IExFRlQgT1VURVIgSk9JTiBwZ19uYW1lc3BhY2UgbnNwIG9uIG5zcC5vaWQgPSBjLnJlbG5hbWVz cGFjZQogTEVGVCBPVVRFUiBKT0lOIHBnX3RhYmxlc3BhY2Ugc3BjIG9uIHNwYy5vaWQ9Yy5yZWx0 YWJsZXNwYWNlCiBMRUZUIE9VVEVSIEpPSU4gcGdfZGVzY3JpcHRpb24gZGVzIE9OIChkZXMub2Jq b2lkPWMub2lkIGFuZCBkZXMub2Jqc3ViaWQ9MCBBTkQgZGVzLmNsYXNzb2lkPSdwZ19jbGFzcyc6 OnJlZ2NsYXNzKQotTEVGVCBPVVRFUiBKT0lOIHBnX2NsYXNzIHRzdCBPTiB0c3Qub2lkID0gYy5y ZWx0b2FzdHJlbGlkCiAgICAgV0hFUkUgKChjLnJlbGhhc3J1bGVzIEFORCAoRVhJU1RTICgKICAg ICAgICAgU0VMRUNUCiAgICAgICAgICAgICByLnJ1bGVuYW1lCg== --0000000000004bc29a059a1fe1dc--