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 1gj1ml-0004W8-0t for pgadmin-hackers@arkaria.postgresql.org; Mon, 14 Jan 2019 12:56:11 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gj1mi-000319-O4 for pgadmin-hackers@arkaria.postgresql.org; Mon, 14 Jan 2019 12:56:08 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gj1mi-000311-5O for pgadmin-hackers@lists.postgresql.org; Mon, 14 Jan 2019 12:56:08 +0000 Received: from mail-lj1-x230.google.com ([2a00:1450:4864:20::230]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gj1me-0000IH-Nm for pgadmin-hackers@postgresql.org; Mon, 14 Jan 2019 12:56:06 +0000 Received: by mail-lj1-x230.google.com with SMTP id v1-v6so18932902ljd.0 for ; Mon, 14 Jan 2019 04:56:04 -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=RItrF1sO5n+wxvK2InWV1U4Tb0LWJRSM0WVunkl7bsg=; b=AO0dSiOqwfA9266+8DgwundrTTrlZa1Ypwzf84EIGWZkrIuHACW3T9mbgpKsO4NTz8 sTcGSUK53RS6BRzn8pYHnNTu7MTCxIT+7dTZHR6QsA53E4eNE1EpcC3JIvuxt9zb1X1y fN2XYk73iIPW122tVx8cR/rGjtcQqqT09zkUskPhHGUvWuwF0lGgzrFawly1SSPK4Q0Y NeXiHvQCr27uSj1iC8VwixqMGKfmqgy6j84FzY/MWXKcU+3/Uh9FMJKV8srxTvxAxUuy uoR12u5pv4+mnRtGyvKSnmmYlCMFIRbva5AywVLm76JtV2TrDcs73boAoLZOjqKlxIC2 ML7g== 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=RItrF1sO5n+wxvK2InWV1U4Tb0LWJRSM0WVunkl7bsg=; b=UW/kbmttaDxbINPlmdUj1V+cIkPumrxUAKcw3i9qg/W+7ekn6Br13lqa1dvKcq43DB Vp0bRW5UBMNkFhvXCfaxWTy20arZCELRsSJ1bTa/OUtb62X+I7Z/VoZKskHAEbWqRJ3/ LxRcll8xr5TnXlxZw49eDPou2PF02lUsHv64JZ3KQPlfulT7frWBDCUl1+OIPdImr6rD uKHXE2Zzx2HDBLmMNwM90RSjLH0t6oHbQvcfua0eWUK30ToXYmcBJEsG7e4n9qpujlhP FpCA6LGQb7IRoYpbDe/G/CClbHAfmFbcRGS0s62nvJgvPwVkNrJ36lwNGRTGxxOi47ov NQmA== X-Gm-Message-State: AJcUukdirOsSrDPVouAFjnWsq94t/FxmZ5RMjqlK6aW0Gp/omzwv4izx YZAvW0OJdk+fRPhwutT+NELgGKu7rjSllut4iwmzOgHP X-Google-Smtp-Source: ALg8bN5rrzMY6M86gwBU+dSVlmUhOOiL5aDaUgidIvw+olRsddw7+96joQ2Lo/sxisDryHKwj1wYpGMBZjxwGpBidO8= X-Received: by 2002:a2e:2e1a:: with SMTP id u26-v6mr15846104lju.8.1547470562096; Mon, 14 Jan 2019 04:56:02 -0800 (PST) MIME-Version: 1.0 From: Aditya Toshniwal Date: Mon, 14 Jan 2019 18:25:45 +0530 Message-ID: Subject: [pgAdmin4][RM3837] Trigger when option syntax error To: pgadmin-hackers Content-Type: multipart/mixed; boundary="000000000000293668057f6a914d" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --000000000000293668057f6a914d Content-Type: multipart/alternative; boundary="000000000000293664057f6a914b" --000000000000293664057f6a914b Content-Type: text/plain; charset="UTF-8" Hi Hackers, Attached is the patch to fix the syntax error if when clause is given. Kindly review. -- Thanks and Regards, Aditya Toshniwal Software Engineer | EnterpriseDB Software Solutions | Pune "Don't Complain about Heat, Plant a tree" --000000000000293664057f6a914b Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi Hackers,

Attached is the patch to fix the syntax error = if when clause is given.
Kindly review.

--
Thanks and Regards,
Aditya Toshniwal
Software Engineer |=C2=A0EnterpriseDB= Software Solutions |=C2=A0Pune<= /div>
"Don't Complain about Hea= t, Plant a tree"
--000000000000293664057f6a914b-- --000000000000293668057f6a914d Content-Type: application/octet-stream; name="RM3837.patch" Content-Disposition: attachment; filename="RM3837.patch" Content-Transfer-Encoding: base64 Content-ID: X-Attachment-Id: f_jqwbzr3j0 ZGlmZiAtLWdpdCBhL3dlYi9wZ2FkbWluL2Jyb3dzZXIvc2VydmVyX2dyb3Vwcy9zZXJ2ZXJzL2Rh dGFiYXNlcy9zY2hlbWFzL3RhYmxlcy90ZW1wbGF0ZXMvdHJpZ2dlci9zcWwvMTBfcGx1cy9wcm9w ZXJ0aWVzLnNxbCBiL3dlYi9wZ2FkbWluL2Jyb3dzZXIvc2VydmVyX2dyb3Vwcy9zZXJ2ZXJzL2Rh dGFiYXNlcy9zY2hlbWFzL3RhYmxlcy90ZW1wbGF0ZXMvdHJpZ2dlci9zcWwvMTBfcGx1cy9wcm9w ZXJ0aWVzLnNxbAppbmRleCAyOGQxMGFkMS4uMTJjOGMzZDMgMTAwNjQ0Ci0tLSBhL3dlYi9wZ2Fk bWluL2Jyb3dzZXIvc2VydmVyX2dyb3Vwcy9zZXJ2ZXJzL2RhdGFiYXNlcy9zY2hlbWFzL3RhYmxl cy90ZW1wbGF0ZXMvdHJpZ2dlci9zcWwvMTBfcGx1cy9wcm9wZXJ0aWVzLnNxbAorKysgYi93ZWIv cGdhZG1pbi9icm93c2VyL3NlcnZlcl9ncm91cHMvc2VydmVycy9kYXRhYmFzZXMvc2NoZW1hcy90 YWJsZXMvdGVtcGxhdGVzL3RyaWdnZXIvc3FsLzEwX3BsdXMvcHJvcGVydGllcy5zcWwKQEAgLTEs NyArMSw2IEBACiBTRUxFQ1QgdC5vaWQsdC50Z25hbWUgQVMgbmFtZSwgdC54bWluLCB0LiosIHJl bG5hbWUsIENBU0UgV0hFTiByZWxraW5kID0gJ3InIFRIRU4gVFJVRSBFTFNFIEZBTFNFIEVORCBB UyBwYXJlbnRpc3RhYmxlLAogICAgIG5zcG5hbWUsIGRlcy5kZXNjcmlwdGlvbiwgbC5sYW5uYW1l LCBwLnByb3NyYywgcC5wcm9uYW1lIEFTIHRmdW5jdGlvbiwKLSAgICBDT0FMRVNDRShzdWJzdHJp bmcocGdfZ2V0X3RyaWdnZXJkZWYodC5vaWQpLCAnV0hFTiAoLiopIEVYRUNVVEUgUFJPQ0VEVVJF JyksCi0gICAgc3Vic3RyaW5nKHBnX2dldF90cmlnZ2VyZGVmKHQub2lkKSwgJ1dIRU4gKC4qKSAg XFwkdHJpZ2dlcicpKSBBUyB3aGVuY2xhdXNlLAorICAgIHBnX2NhdGFsb2cucGdfZ2V0X2V4cHIo dC50Z3F1YWwsIHQudGdyZWxpZCkgQVMgd2hlbmNsYXVzZQogICAgIC0tIFdlIG5lZWQgdG8gY29u dmVydCB0Z2FyZ3MgY29sdW1uIGJ5dGVhIGRhdGF0eXBlIHRvIGFycmF5IGRhdGF0eXBlCiAgICAg KHN0cmluZ190b19hcnJheShlbmNvZGUodGdhcmdzLCAnZXNjYXBlJyksIEUnXFwwMDAnKTo6dGV4 dFtdKVsxOnRnbmFyZ3NdIEFTIGN1c3RvbV90Z2FyZ3MsCiB7JSBpZiBkYXRsYXN0c3lzb2lkICV9 CmRpZmYgLS1naXQgYS93ZWIvcGdhZG1pbi9icm93c2VyL3NlcnZlcl9ncm91cHMvc2VydmVycy9k YXRhYmFzZXMvc2NoZW1hcy90YWJsZXMvdGVtcGxhdGVzL3RyaWdnZXIvc3FsLzkuMV9wbHVzL3By b3BlcnRpZXMuc3FsIGIvd2ViL3BnYWRtaW4vYnJvd3Nlci9zZXJ2ZXJfZ3JvdXBzL3NlcnZlcnMv ZGF0YWJhc2VzL3NjaGVtYXMvdGFibGVzL3RlbXBsYXRlcy90cmlnZ2VyL3NxbC85LjFfcGx1cy9w cm9wZXJ0aWVzLnNxbAppbmRleCAyZDM0YWNjZi4uYzFiZTljMzggMTAwNjQ0Ci0tLSBhL3dlYi9w Z2FkbWluL2Jyb3dzZXIvc2VydmVyX2dyb3Vwcy9zZXJ2ZXJzL2RhdGFiYXNlcy9zY2hlbWFzL3Rh Ymxlcy90ZW1wbGF0ZXMvdHJpZ2dlci9zcWwvOS4xX3BsdXMvcHJvcGVydGllcy5zcWwKKysrIGIv d2ViL3BnYWRtaW4vYnJvd3Nlci9zZXJ2ZXJfZ3JvdXBzL3NlcnZlcnMvZGF0YWJhc2VzL3NjaGVt YXMvdGFibGVzL3RlbXBsYXRlcy90cmlnZ2VyL3NxbC85LjFfcGx1cy9wcm9wZXJ0aWVzLnNxbApA QCAtMSw3ICsxLDYgQEAKIFNFTEVDVCB0Lm9pZCx0LnRnbmFtZSBBUyBuYW1lLCB0LnhtaW4sIHQu KiwgcmVsbmFtZSwgQ0FTRSBXSEVOIHJlbGtpbmQgPSAncicgVEhFTiBUUlVFIEVMU0UgRkFMU0Ug RU5EIEFTIHBhcmVudGlzdGFibGUsCiAgICAgbnNwbmFtZSwgZGVzLmRlc2NyaXB0aW9uLCBsLmxh bm5hbWUsIHAucHJvc3JjLCBwLnByb25hbWUgQVMgdGZ1bmN0aW9uLAotICAgIENPQUxFU0NFKHN1 YnN0cmluZyhwZ19nZXRfdHJpZ2dlcmRlZih0Lm9pZCksICdXSEVOICguKikgRVhFQ1VURSBQUk9D RURVUkUnKSwKLSAgICBzdWJzdHJpbmcocGdfZ2V0X3RyaWdnZXJkZWYodC5vaWQpLCAnV0hFTiAo LiopICBcXCR0cmlnZ2VyJykpIEFTIHdoZW5jbGF1c2UsCisgICAgcGdfY2F0YWxvZy5wZ19nZXRf ZXhwcih0LnRncXVhbCwgdC50Z3JlbGlkKSBBUyB3aGVuY2xhdXNlLAogICAgIC0tIFdlIG5lZWQg dG8gY29udmVydCB0Z2FyZ3MgY29sdW1uIGJ5dGVhIGRhdGF0eXBlIHRvIGFycmF5IGRhdGF0eXBl CiAgICAgKHN0cmluZ190b19hcnJheShlbmNvZGUodGdhcmdzLCAnZXNjYXBlJyksIEUnXFwwMDAn KTo6dGV4dFtdKVsxOnRnbmFyZ3NdIEFTIGN1c3RvbV90Z2FyZ3MsCiB7JSBpZiBkYXRsYXN0c3lz b2lkICV9CmRpZmYgLS1naXQgYS93ZWIvcGdhZG1pbi9icm93c2VyL3NlcnZlcl9ncm91cHMvc2Vy dmVycy9kYXRhYmFzZXMvc2NoZW1hcy90YWJsZXMvdHJpZ2dlcnMvX19pbml0X18ucHkgYi93ZWIv cGdhZG1pbi9icm93c2VyL3NlcnZlcl9ncm91cHMvc2VydmVycy9kYXRhYmFzZXMvc2NoZW1hcy90 YWJsZXMvdHJpZ2dlcnMvX19pbml0X18ucHkKaW5kZXggN2QyYjBmMTEuLjQ2Y2VhNzcyIDEwMDY0 NAotLS0gYS93ZWIvcGdhZG1pbi9icm93c2VyL3NlcnZlcl9ncm91cHMvc2VydmVycy9kYXRhYmFz ZXMvc2NoZW1hcy90YWJsZXMvdHJpZ2dlcnMvX19pbml0X18ucHkKKysrIGIvd2ViL3BnYWRtaW4v YnJvd3Nlci9zZXJ2ZXJfZ3JvdXBzL3NlcnZlcnMvZGF0YWJhc2VzL3NjaGVtYXMvdGFibGVzL3Ry aWdnZXJzL19faW5pdF9fLnB5CkBAIC04MzQsNiArODM0LDkgQEAgY2xhc3MgVHJpZ2dlclZpZXco UEdDaGlsZE5vZGVWaWV3KToKICAgICAgICAgIyBBZGRpbmcgcGFyZW50IGludG8gZGF0YSBkaWN0 LCB3aWxsIGJlIHVzaW5nIGl0IHdoaWxlIGNyZWF0aW5nIHNxbAogICAgICAgICBkYXRhWydzY2hl bWEnXSA9IHNlbGYuc2NoZW1hCiAgICAgICAgIGRhdGFbJ3RhYmxlJ10gPSBzZWxmLnRhYmxlCisg ICAgICAgICMgUmV2ZXJzZSBlbmdpbmVlciBTUUwgZGF0YSBoYXMgYnJhY2tldHMgYWxyZWFkeSwg aGVuY2UgYXBwbHlpbmcgaGVyZQorICAgICAgICAjIHRvIHJldXNlIHRoZSB0ZW1wbGF0ZSBzcWwK KyAgICAgICAgZGF0YVsnd2hlbmNsYXVzZSddID0gJygnICsgZGF0YVsnd2hlbmNsYXVzZSddICsg JyknCiAKICAgICAgICAgdHJ5OgogICAgICAgICAgICAgc3FsLCBuYW1lID0gc2VsZi5nZXRfc3Fs KHNjaWQsIHRpZCwgdHJpZCwgZGF0YSkKZGlmZiAtLWdpdCBhL3dlYi9wZ2FkbWluL2Jyb3dzZXIv c2VydmVyX2dyb3Vwcy9zZXJ2ZXJzL2RhdGFiYXNlcy9zY2hlbWFzL3RhYmxlcy90cmlnZ2Vycy9z dGF0aWMvanMvdHJpZ2dlci5qcyBiL3dlYi9wZ2FkbWluL2Jyb3dzZXIvc2VydmVyX2dyb3Vwcy9z ZXJ2ZXJzL2RhdGFiYXNlcy9zY2hlbWFzL3RhYmxlcy90cmlnZ2Vycy9zdGF0aWMvanMvdHJpZ2dl ci5qcwppbmRleCA3ZTUzMjU0Zi4uMmZhNjY0MDggMTAwNjQ0Ci0tLSBhL3dlYi9wZ2FkbWluL2Jy b3dzZXIvc2VydmVyX2dyb3Vwcy9zZXJ2ZXJzL2RhdGFiYXNlcy9zY2hlbWFzL3RhYmxlcy90cmln Z2Vycy9zdGF0aWMvanMvdHJpZ2dlci5qcworKysgYi93ZWIvcGdhZG1pbi9icm93c2VyL3NlcnZl cl9ncm91cHMvc2VydmVycy9kYXRhYmFzZXMvc2NoZW1hcy90YWJsZXMvdHJpZ2dlcnMvc3RhdGlj L2pzL3RyaWdnZXIuanMKQEAgLTE3LDExICsxNywxMCBAQCBkZWZpbmUoJ3BnYWRtaW4ubm9kZS50 cmlnZ2VyJywgWwogICBnZXR0ZXh0LCB1cmxfZm9yLCAkLCBfLCBTLCBwZ0FkbWluLCBwZ0Jyb3dz ZXIsIEJhY2tmb3JtLCBhbGVydGlmeSwKICAgU2NoZW1hQ2hpbGRUcmVlTm9kZQogKSB7Ci0KICAg QmFja2Zvcm0uQ3VzdG9tU3dpdGNoQ29udHJvbCA9IEJhY2tmb3JtLlN3aXRjaENvbnRyb2wuZXh0 ZW5kKHsKICAgICB0ZW1wbGF0ZTogXy50ZW1wbGF0ZShbCi0gICAgICAnPGxhYmVsIGNsYXNzPSI8 JT1CYWNrZm9ybS5jb250cm9sTGFiZWxDbGFzc05hbWUlPiBjdXN0b21fc3dpdGNoX2xhYmVsX2Ns YXNzIj48JT1sYWJlbCU+PC9sYWJlbD4nLAotICAgICAgJzxkaXYgY2xhc3M9IjwlPUJhY2tmb3Jt LmNvbnRyb2xzQ2xhc3NOYW1lJT4gY3VzdG9tX3N3aXRjaF9jb250cm9sX2NsYXNzIj4nLAorICAg ICAgJzxsYWJlbCBjbGFzcz0iY29udHJvbC1sYWJlbCBwZy1lbC1zbS02IHBnLWVsLTEyIGN1c3Rv bV9zd2l0Y2hfbGFiZWxfY2xhc3MiPjwlPWxhYmVsJT48L2xhYmVsPicsCisgICAgICAnPGRpdiBj bGFzcz0icGdhZG1pbi1jb250cm9scyBwZy1lbC1zbS02IHBnLWVsLTEyIGN1c3RvbV9zd2l0Y2hf Y29udHJvbF9jbGFzcyI+JywKICAgICAgICcgIDxkaXYgY2xhc3M9ImNoZWNrYm94Ij4nLAogICAg ICAgJyAgICA8bGFiZWw+JywKICAgICAgICcgICAgICA8aW5wdXQgdHlwZT0iY2hlY2tib3giIGNs YXNzPSI8JT1leHRyYUNsYXNzZXMuam9pbihcJyBcJyklPiInLApAQCAtMzQsNyArMzMsNyBAQCBk ZWZpbmUoJ3BnYWRtaW4ubm9kZS50cmlnZ2VyJywgWwogICAgICAgJyAgPHNwYW4gY2xhc3M9Ijwl PUJhY2tmb3JtLmhlbHBNZXNzYWdlQ2xhc3NOYW1lJT4iPjwlPWhlbHBNZXNzYWdlJT48L3NwYW4+ JywKICAgICAgICc8JSB9ICU+JywKICAgICBdLmpvaW4oJ1xuJykpLAotICAgIGNsYXNzTmFtZTog J3BnYWRtaW4tY29udHJvbC1ncm91cCBmb3JtLWdyb3VwIGNvbC02JywKKyAgICBjbGFzc05hbWU6 ICdwZ2FkbWluLWNvbnRyb2wtZ3JvdXAgZm9ybS1ncm91cCBjb2wtNiByb3cnLAogICB9KTsKIAog ICBpZiAoIXBnQnJvd3Nlci5Ob2Rlc1snY29sbC10cmlnZ2VyJ10pIHsKQEAgLTU3LDcgKzU2LDcg QEAgZGVmaW5lKCdwZ2FkbWluLm5vZGUudHJpZ2dlcicsIFsKICAgICAgIGxhYmVsOiBnZXR0ZXh0 KCdUcmlnZ2VyJyksCiAgICAgICBoYXNTUUw6ICB0cnVlLAogICAgICAgaGFzRGVwZW5kczogdHJ1 ZSwKLSAgICAgIHdpZHRoOiAnNjUwcHgnLAorICAgICAgd2lkdGg6IHBnQnJvd3Nlci5zdGRXLnNt ICsgJ3B4JywKICAgICAgIHNxbEFsdGVySGVscDogJ3NxbC1hbHRlcnRyaWdnZXIuaHRtbCcsCiAg ICAgICBzcWxDcmVhdGVIZWxwOiAnc3FsLWNyZWF0ZXRyaWdnZXIuaHRtbCcsCiAgICAgICBkaWFs b2dIZWxwOiB1cmxfZm9yKCdoZWxwLnN0YXRpYycsIHsnZmlsZW5hbWUnOiAndHJpZ2dlcl9kaWFs b2cuaHRtbCd9KSwKQEAgLTM5MSw3ICszOTAsNyBAQCBkZWZpbmUoJ3BnYWRtaW4ubm9kZS50cmln Z2VyJywgWwogICAgICAgICAgIH0sCiAgICAgICAgIH0sewogICAgICAgICAgIHR5cGU6ICduZXN0 ZWQnLCBjb250cm9sOiAnZmllbGRzZXQnLCBtb2RlOiBbJ2NyZWF0ZScsJ2VkaXQnLCAncHJvcGVy dGllcyddLAotICAgICAgICAgIGxhYmVsOiBnZXR0ZXh0KCdFdmVudHMnKSwgZ3JvdXA6IGdldHRl eHQoJ0V2ZW50cycpLAorICAgICAgICAgIGxhYmVsOiBnZXR0ZXh0KCdFdmVudHMnKSwgZ3JvdXA6 IGdldHRleHQoJ0V2ZW50cycpLCBjb250ZW50Q2xhc3M6ICdyb3cnLAogICAgICAgICAgIHNjaGVt YTpbewogICAgICAgICAgICAgaWQ6ICdldm50X2luc2VydCcsIGxhYmVsOiBnZXR0ZXh0KCdJTlNF UlQnKSwKICAgICAgICAgICAgIHR5cGU6ICdzd2l0Y2gnLCBtb2RlOiBbJ2NyZWF0ZScsJ2VkaXQn LCAncHJvcGVydGllcyddLAo= --000000000000293668057f6a914d--