[pgAdmin4][Patch] - 5023 - Refactoring SQL of View and Materialized View.
Khushboo Vashi <[email protected]> Fri, 20 Dec 2019 15:39:49 +0530
| Newsgroups | gmane.comp.db.postgresql.pgadmin.devel |
|---|---|
| Message-ID | <CAFOhELfopVY8CxUjtT3jsqQbwj+e0htH+4YSWmWQnjec-wL6cw@mail.gmail.com> |
--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" <div dir="ltr">Hi,<div><br></div><div>Please find the attached small patch of refactoring SQL of views module. RM -5023</div><div><br></div><div>Thanks,</div><div>Khushboo</div></div> --0000000000004bc298059a1fe1da-- --0000000000004bc29a059a1fe1dc Content-Type: application/octet-stream; name="views.patch" Content-Disposition: attachment; filename="views.patch" Content-Transfer-Encoding: base64 Content-ID: <f_k4dzrixn0> 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--