Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1bVkB8-0007LJ-4L for pgadmin-hackers@arkaria.postgresql.org; Fri, 05 Aug 2016 18:49:06 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1bVkB7-0000yd-NN for pgadmin-hackers@arkaria.postgresql.org; Fri, 05 Aug 2016 18:49:05 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1bVkAu-0000kg-K2 for pgadmin-hackers@postgresql.org; Fri, 05 Aug 2016 18:48:52 +0000 Received: from mail-wm0-x229.google.com ([2a00:1450:400c:c09::229]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1bVkAn-0008IA-2t for pgadmin-hackers@postgresql.org; Fri, 05 Aug 2016 18:48:51 +0000 Received: by mail-wm0-x229.google.com with SMTP id o80so48920021wme.1 for ; Fri, 05 Aug 2016 11:48:44 -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=lO1rDedLMUrsJRGmxYaF9pfBYfF1mX7PdI8CBk9iUWc=; b=0hOxm5LIr7DmlUB5N3BCcexZyE8DmsfEt12K6FEQEq2spyjVO7OPywGgteXZt1OKuz GfmIv5ylGfanVe5zCPbdrhltEP4FseiA5b2N9mD9A86SnfGL4fy0Shd/M4XndCNq973p 1D6hMK9Phlpb81bJJb+FZ+EPwL5R4xwyGZCjnYx0T17L4T47B+P1zTAMlrnL6nnDAHHk FrNB81CalQXS2ckss/EYGr8gfkWvOiBl7V4fv9BsO99jP+CWEZ8c4F5nxDv+Fyi5xLuZ 1G3yLpyjD9DbsC/uvwqO8xkdDte8Al8j5FIMq5Aza8F3nuvbJureZfq1nYrQnXnCvKS+ d7Ig== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:mime-version:from:date:message-id:subject:to; bh=lO1rDedLMUrsJRGmxYaF9pfBYfF1mX7PdI8CBk9iUWc=; b=F7n1OQMJ+P9OtUfuZeW1PJUEP9utX9OZwOR2n/j198orL4KEAaQdSO2MrovvR3ubW4 8tbmWmFZ5VAsI09m8vxsMdXuw4vlebp7uKBMV9xmgAoqF1M0y1JujyYko/+Rldq1jxP7 2+drKBbPTssBr/xvfua4McsMqT31tkBCikFXsYRQZbEi8eGbD53fT8XdtdyAWm40ZQrc buHLCqciQT6EjgXAWO4G5RvE5rPO434kE1Yc2/PIc7A3uVeTgjz6c2iJe16KHpbo4ShC HWwFTa7XrM6EmuPlOuY+O/c78rtrcIzW3YF63C+Ql+7/gyR06hnWhjOncuH76WsSl9R9 Qr0A== X-Gm-Message-State: AEkoouup4kFsp2vKRSzKUrMMXLVauiidhA7d+32vkkCo3Pf9WS2FKRE4XfsFLazgWasTLxmkz4GlCn/xS17u6/wh X-Received: by 10.194.187.134 with SMTP id fs6mr44293639wjc.3.1470422922331; Fri, 05 Aug 2016 11:48:42 -0700 (PDT) MIME-Version: 1.0 Received: by 10.28.167.81 with HTTP; Fri, 5 Aug 2016 11:48:11 -0700 (PDT) From: Surinder Kumar Date: Sat, 6 Aug 2016 00:18:11 +0530 Message-ID: Subject: [pgAdmin4][Patch]: RM1524 - Reverse engineered SQL for Trigger Functions missing "AS" To: pgadmin-hackers Content-Type: multipart/mixed; boundary=047d7bb049a6f525e005395783a0 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 --047d7bb049a6f525e005395783a0 Content-Type: multipart/alternative; boundary=047d7bb049a6f525da053957839e --047d7bb049a6f525da053957839e Content-Type: text/plain; charset=UTF-8 Hi *Issue:* Keyword "AS" should be written outside the endif clause, it was written inside. Please find attached patch and review. Thanks, Surinder Kumar --047d7bb049a6f525da053957839e Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Hi<= /div>

Issue:
Keyword "AS" sho= uld be written outside the endif clause, it was written inside.

Please find attached patch and revie= w.

Thanks,
Surinder Kumar
--047d7bb049a6f525da053957839e-- --047d7bb049a6f525e005395783a0 Content-Type: application/octet-stream; name="RM1524.patch" Content-Disposition: attachment; filename="RM1524.patch" Content-Transfer-Encoding: base64 X-Attachment-Id: f_iri3syer0 ZGlmZiAtLWdpdCBhL3dlYi9wZ2FkbWluL2Jyb3dzZXIvc2VydmVyX2dyb3Vw cy9zZXJ2ZXJzL2RhdGFiYXNlcy9zY2hlbWFzL2Z1bmN0aW9ucy90ZW1wbGF0 ZXMvdHJpZ2dlcl9mdW5jdGlvbi9wZy9zcWwvOS4xX3BsdXMvY3JlYXRlLnNx bCBiL3dlYi9wZ2FkbWluL2Jyb3dzZXIvc2VydmVyX2dyb3Vwcy9zZXJ2ZXJz L2RhdGFiYXNlcy9zY2hlbWFzL2Z1bmN0aW9ucy90ZW1wbGF0ZXMvdHJpZ2dl cl9mdW5jdGlvbi9wZy9zcWwvOS4xX3BsdXMvY3JlYXRlLnNxbAppbmRleCAw YTc3NmYzLi45OGMzMzZhIDEwMDY0NAotLS0gYS93ZWIvcGdhZG1pbi9icm93 c2VyL3NlcnZlcl9ncm91cHMvc2VydmVycy9kYXRhYmFzZXMvc2NoZW1hcy9m dW5jdGlvbnMvdGVtcGxhdGVzL3RyaWdnZXJfZnVuY3Rpb24vcGcvc3FsLzku MV9wbHVzL2NyZWF0ZS5zcWwKKysrIGIvd2ViL3BnYWRtaW4vYnJvd3Nlci9z ZXJ2ZXJfZ3JvdXBzL3NlcnZlcnMvZGF0YWJhc2VzL3NjaGVtYXMvZnVuY3Rp b25zL3RlbXBsYXRlcy90cmlnZ2VyX2Z1bmN0aW9uL3BnL3NxbC85LjFfcGx1 cy9jcmVhdGUuc3FsCkBAIC0xOCw3ICsxOCw3IEBAIENSRUFURSBGVU5DVElP TiB7eyBjb25ufHF0SWRlbnQoZGF0YS5wcm9uYW1lc3BhY2UsIGRhdGEubmFt ZSkgfX0oKQogICAgIFNFVCB7eyBjb25ufHF0SWRlbnQodi5uYW1lKSB9fT17 eyB2LnZhbHVlfHF0TGl0ZXJhbCB9fXslIGVuZGZvciAlfQogeyUgZW5kaWYg JX0KCi1BUyB7JSBlbmRpZiAlfXslIGlmIGRhdGEubGFubmFtZSA9PSAnYycg JX0KK3slIGVuZGlmICV9QVMgeyUgaWYgZGF0YS5sYW5uYW1lID09ICdjJyAl fQoge3sgZGF0YS5wcm9iaW58cXRMaXRlcmFsIH19LCB7eyBkYXRhLnByb3Ny Y19jfHF0TGl0ZXJhbCB9fQogeyUgZWxzZSAlfQogJEJPRFkkCmRpZmYgLS1n aXQgYS93ZWIvcGdhZG1pbi9icm93c2VyL3NlcnZlcl9ncm91cHMvc2VydmVy cy9kYXRhYmFzZXMvc2NoZW1hcy9mdW5jdGlvbnMvdGVtcGxhdGVzL3RyaWdn ZXJfZnVuY3Rpb24vcGcvc3FsLzkuMl9wbHVzL2NyZWF0ZS5zcWwgYi93ZWIv cGdhZG1pbi9icm93c2VyL3NlcnZlcl9ncm91cHMvc2VydmVycy9kYXRhYmFz ZXMvc2NoZW1hcy9mdW5jdGlvbnMvdGVtcGxhdGVzL3RyaWdnZXJfZnVuY3Rp b24vcGcvc3FsLzkuMl9wbHVzL2NyZWF0ZS5zcWwKaW5kZXggNDEyYjAyZS4u NDY5ZDI4MCAxMDA2NDQKLS0tIGEvd2ViL3BnYWRtaW4vYnJvd3Nlci9zZXJ2 ZXJfZ3JvdXBzL3NlcnZlcnMvZGF0YWJhc2VzL3NjaGVtYXMvZnVuY3Rpb25z L3RlbXBsYXRlcy90cmlnZ2VyX2Z1bmN0aW9uL3BnL3NxbC85LjJfcGx1cy9j cmVhdGUuc3FsCisrKyBiL3dlYi9wZ2FkbWluL2Jyb3dzZXIvc2VydmVyX2dy b3Vwcy9zZXJ2ZXJzL2RhdGFiYXNlcy9zY2hlbWFzL2Z1bmN0aW9ucy90ZW1w bGF0ZXMvdHJpZ2dlcl9mdW5jdGlvbi9wZy9zcWwvOS4yX3BsdXMvY3JlYXRl LnNxbApAQCAtMjIsNyArMjIsNyBAQCBDUkVBVEUgRlVOQ1RJT04ge3sgY29u bnxxdElkZW50KGRhdGEucHJvbmFtZXNwYWNlLCBkYXRhLm5hbWUpIH19KCkK ICAgICBTRVQge3sgY29ubnxxdElkZW50KHYubmFtZSkgfX09e3sgdi52YWx1 ZXxxdExpdGVyYWwgfX17JSBlbmRmb3IgJX0KIHslIGVuZGlmICV9CgotQVMg eyUgZW5kaWYgJX17JSBpZiBkYXRhLmxhbm5hbWUgPT0gJ2MnICV9Cit7JSBl bmRpZiAlfUFTIHslIGlmIGRhdGEubGFubmFtZSA9PSAnYycgJX0KIHt7IGRh dGEucHJvYmlufHF0TGl0ZXJhbCB9fSwge3sgZGF0YS5wcm9zcmNfY3xxdExp dGVyYWwgfX0KIHslIGVsc2UgJX0KICRCT0RZJApkaWZmIC0tZ2l0IGEvd2Vi L3BnYWRtaW4vYnJvd3Nlci9zZXJ2ZXJfZ3JvdXBzL3NlcnZlcnMvZGF0YWJh c2VzL3NjaGVtYXMvZnVuY3Rpb25zL3RlbXBsYXRlcy90cmlnZ2VyX2Z1bmN0 aW9uL3BnL3NxbC85LjVfcGx1cy9jcmVhdGUuc3FsIGIvd2ViL3BnYWRtaW4v YnJvd3Nlci9zZXJ2ZXJfZ3JvdXBzL3NlcnZlcnMvZGF0YWJhc2VzL3NjaGVt YXMvZnVuY3Rpb25zL3RlbXBsYXRlcy90cmlnZ2VyX2Z1bmN0aW9uL3BnL3Nx bC85LjVfcGx1cy9jcmVhdGUuc3FsCmluZGV4IGFhYTMxZTAuLjZiZGEzZTMg MTAwNjQ0Ci0tLSBhL3dlYi9wZ2FkbWluL2Jyb3dzZXIvc2VydmVyX2dyb3Vw cy9zZXJ2ZXJzL2RhdGFiYXNlcy9zY2hlbWFzL2Z1bmN0aW9ucy90ZW1wbGF0 ZXMvdHJpZ2dlcl9mdW5jdGlvbi9wZy9zcWwvOS41X3BsdXMvY3JlYXRlLnNx bAorKysgYi93ZWIvcGdhZG1pbi9icm93c2VyL3NlcnZlcl9ncm91cHMvc2Vy dmVycy9kYXRhYmFzZXMvc2NoZW1hcy9mdW5jdGlvbnMvdGVtcGxhdGVzL3Ry aWdnZXJfZnVuY3Rpb24vcGcvc3FsLzkuNV9wbHVzL2NyZWF0ZS5zcWwKQEAg LTIxLDcgKzIxLDcgQEAgQ1JFQVRFIEZVTkNUSU9OIHt7IGNvbm58cXRJZGVu dChkYXRhLnByb25hbWVzcGFjZSwgZGF0YS5uYW1lKSB9fSh7JSBpZiBkYXRh LnByb2EKICAgICBTRVQge3sgY29ubnxxdElkZW50KHYubmFtZSkgfX09e3sg di52YWx1ZXxxdExpdGVyYWwgfX17JSBlbmRmb3IgJX0KIHslIGVuZGlmICV9 CgotQVMgeyUgZW5kaWYgJX17JSBpZiBkYXRhLmxhbm5hbWUgPT0gJ2MnICV9 Cit7JSBlbmRpZiAlfUFTIHslIGlmIGRhdGEubGFubmFtZSA9PSAnYycgJX0K IHt7IGRhdGEucHJvYmlufHF0TGl0ZXJhbCB9fSwge3sgZGF0YS5wcm9zcmNf Y3xxdExpdGVyYWwgfX0KIHslIGVsc2UgJX0KICRCT0RZJApkaWZmIC0tZ2l0 IGEvd2ViL3BnYWRtaW4vYnJvd3Nlci9zZXJ2ZXJfZ3JvdXBzL3NlcnZlcnMv ZGF0YWJhc2VzL3NjaGVtYXMvZnVuY3Rpb25zL3RlbXBsYXRlcy90cmlnZ2Vy X2Z1bmN0aW9uL3BwYXMvc3FsLzkuMV9wbHVzL2NyZWF0ZS5zcWwgYi93ZWIv cGdhZG1pbi9icm93c2VyL3NlcnZlcl9ncm91cHMvc2VydmVycy9kYXRhYmFz ZXMvc2NoZW1hcy9mdW5jdGlvbnMvdGVtcGxhdGVzL3RyaWdnZXJfZnVuY3Rp b24vcHBhcy9zcWwvOS4xX3BsdXMvY3JlYXRlLnNxbAppbmRleCAwYTc3NmYz Li45OGMzMzZhIDEwMDY0NAotLS0gYS93ZWIvcGdhZG1pbi9icm93c2VyL3Nl cnZlcl9ncm91cHMvc2VydmVycy9kYXRhYmFzZXMvc2NoZW1hcy9mdW5jdGlv bnMvdGVtcGxhdGVzL3RyaWdnZXJfZnVuY3Rpb24vcHBhcy9zcWwvOS4xX3Bs dXMvY3JlYXRlLnNxbAorKysgYi93ZWIvcGdhZG1pbi9icm93c2VyL3NlcnZl cl9ncm91cHMvc2VydmVycy9kYXRhYmFzZXMvc2NoZW1hcy9mdW5jdGlvbnMv dGVtcGxhdGVzL3RyaWdnZXJfZnVuY3Rpb24vcHBhcy9zcWwvOS4xX3BsdXMv Y3JlYXRlLnNxbApAQCAtMTgsNyArMTgsNyBAQCBDUkVBVEUgRlVOQ1RJT04g e3sgY29ubnxxdElkZW50KGRhdGEucHJvbmFtZXNwYWNlLCBkYXRhLm5hbWUp IH19KCkKICAgICBTRVQge3sgY29ubnxxdElkZW50KHYubmFtZSkgfX09e3sg di52YWx1ZXxxdExpdGVyYWwgfX17JSBlbmRmb3IgJX0KIHslIGVuZGlmICV9 CgotQVMgeyUgZW5kaWYgJX17JSBpZiBkYXRhLmxhbm5hbWUgPT0gJ2MnICV9 Cit7JSBlbmRpZiAlfUFTIHslIGlmIGRhdGEubGFubmFtZSA9PSAnYycgJX0K IHt7IGRhdGEucHJvYmlufHF0TGl0ZXJhbCB9fSwge3sgZGF0YS5wcm9zcmNf Y3xxdExpdGVyYWwgfX0KIHslIGVsc2UgJX0KICRCT0RZJApkaWZmIC0tZ2l0 IGEvd2ViL3BnYWRtaW4vYnJvd3Nlci9zZXJ2ZXJfZ3JvdXBzL3NlcnZlcnMv ZGF0YWJhc2VzL3NjaGVtYXMvZnVuY3Rpb25zL3RlbXBsYXRlcy90cmlnZ2Vy X2Z1bmN0aW9uL3BwYXMvc3FsLzkuMl9wbHVzL2NyZWF0ZS5zcWwgYi93ZWIv cGdhZG1pbi9icm93c2VyL3NlcnZlcl9ncm91cHMvc2VydmVycy9kYXRhYmFz ZXMvc2NoZW1hcy9mdW5jdGlvbnMvdGVtcGxhdGVzL3RyaWdnZXJfZnVuY3Rp b24vcHBhcy9zcWwvOS4yX3BsdXMvY3JlYXRlLnNxbAppbmRleCBlZjY0ZDIw Li4xYzRlNjc3IDEwMDY0NAotLS0gYS93ZWIvcGdhZG1pbi9icm93c2VyL3Nl cnZlcl9ncm91cHMvc2VydmVycy9kYXRhYmFzZXMvc2NoZW1hcy9mdW5jdGlv bnMvdGVtcGxhdGVzL3RyaWdnZXJfZnVuY3Rpb24vcHBhcy9zcWwvOS4yX3Bs dXMvY3JlYXRlLnNxbAorKysgYi93ZWIvcGdhZG1pbi9icm93c2VyL3NlcnZl cl9ncm91cHMvc2VydmVycy9kYXRhYmFzZXMvc2NoZW1hcy9mdW5jdGlvbnMv dGVtcGxhdGVzL3RyaWdnZXJfZnVuY3Rpb24vcHBhcy9zcWwvOS4yX3BsdXMv Y3JlYXRlLnNxbApAQCAtMjEsNyArMjEsNyBAQCBDUkVBVEUgRlVOQ1RJT04g e3sgY29ubnxxdElkZW50KGRhdGEucHJvbmFtZXNwYWNlLCBkYXRhLm5hbWUp IH19KCkKICAgICBTRVQge3sgY29ubnxxdElkZW50KHYubmFtZSkgfX09e3sg di52YWx1ZXxxdExpdGVyYWwgfX17JSBlbmRmb3IgJX0KIHslIGVuZGlmICV9 CgotQVMgeyUgZW5kaWYgJX17JSBpZiBkYXRhLmxhbm5hbWUgPT0gJ2MnICV9 Cit7JSBlbmRpZiAlfUFTIHslIGlmIGRhdGEubGFubmFtZSA9PSAnYycgJX0K IHt7IGRhdGEucHJvYmlufHF0TGl0ZXJhbCB9fSwge3sgZGF0YS5wcm9zcmNf Y3xxdExpdGVyYWwgfX0KIHslIGVsc2UgJX0KICRCT0RZJApkaWZmIC0tZ2l0 IGEvd2ViL3BnYWRtaW4vYnJvd3Nlci9zZXJ2ZXJfZ3JvdXBzL3NlcnZlcnMv ZGF0YWJhc2VzL3NjaGVtYXMvZnVuY3Rpb25zL3RlbXBsYXRlcy90cmlnZ2Vy X2Z1bmN0aW9uL3BwYXMvc3FsLzkuNV9wbHVzL2NyZWF0ZS5zcWwgYi93ZWIv cGdhZG1pbi9icm93c2VyL3NlcnZlcl9ncm91cHMvc2VydmVycy9kYXRhYmFz ZXMvc2NoZW1hcy9mdW5jdGlvbnMvdGVtcGxhdGVzL3RyaWdnZXJfZnVuY3Rp b24vcHBhcy9zcWwvOS41X3BsdXMvY3JlYXRlLnNxbAppbmRleCA5MWYxZGU2 Li44NjY4OTkwIDEwMDY0NAotLS0gYS93ZWIvcGdhZG1pbi9icm93c2VyL3Nl cnZlcl9ncm91cHMvc2VydmVycy9kYXRhYmFzZXMvc2NoZW1hcy9mdW5jdGlv bnMvdGVtcGxhdGVzL3RyaWdnZXJfZnVuY3Rpb24vcHBhcy9zcWwvOS41X3Bs dXMvY3JlYXRlLnNxbAorKysgYi93ZWIvcGdhZG1pbi9icm93c2VyL3NlcnZl cl9ncm91cHMvc2VydmVycy9kYXRhYmFzZXMvc2NoZW1hcy9mdW5jdGlvbnMv dGVtcGxhdGVzL3RyaWdnZXJfZnVuY3Rpb24vcHBhcy9zcWwvOS41X3BsdXMv Y3JlYXRlLnNxbApAQCAtMjEsNyArMjEsNyBAQCBDUkVBVEUgRlVOQ1RJT04g e3sgY29ubnxxdElkZW50KGRhdGEucHJvbmFtZXNwYWNlLCBkYXRhLm5hbWUp IH19KCkKICAgICBTRVQge3sgY29ubnxxdElkZW50KHYubmFtZSkgfX09e3sg di52YWx1ZXxxdExpdGVyYWwgfX17JSBlbmRmb3IgJX0KIHslIGVuZGlmICV9 CgotQVMgeyUgZW5kaWYgJX17JSBpZiBkYXRhLmxhbm5hbWUgPT0gJ2MnICV9 Cit7JSBlbmRpZiAlfUFTIHslIGlmIGRhdGEubGFubmFtZSA9PSAnYycgJX0K IHt7IGRhdGEucHJvYmlufHF0TGl0ZXJhbCB9fSwge3sgZGF0YS5wcm9zcmNf Y3xxdExpdGVyYWwgfX0KIHslIGVsc2UgJX0KICRCT0RZJAo= --047d7bb049a6f525e005395783a0 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 --047d7bb049a6f525e005395783a0--