Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mYMLN-0002ns-Ex for pgadmin-hackers@arkaria.postgresql.org; Thu, 07 Oct 2021 05:53:25 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mYMLM-0000ld-DP for pgadmin-hackers@arkaria.postgresql.org; Thu, 07 Oct 2021 05:53:24 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mYMLL-0000hu-Ny for pgadmin-hackers@lists.postgresql.org; Thu, 07 Oct 2021 05:53:24 +0000 Received: from mail-yb1-xb2d.google.com ([2607:f8b0:4864:20::b2d]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1mYMLH-0005R3-P8 for pgadmin-hackers@postgresql.org; Thu, 07 Oct 2021 05:53:22 +0000 Received: by mail-yb1-xb2d.google.com with SMTP id d131so10806300ybd.5 for ; Wed, 06 Oct 2021 22:53:19 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=enterprisedb.com; s=google; h=mime-version:from:date:message-id:subject:to; bh=6JJgYdb1V6WKdLgz0sbjZxegCfgJafKIqwa5tBGwKCo=; b=mTAPyxvvgg4EAFsCnYvU0+9skGL9vCu6izEziozvyVDYMEkIWA1M1DfSUOQaIl3juy wMo7dD3zXRNti59XgrLaUUkDaT3v+Jejdjw5QL/vAsq+zDZoOyWY0JShxSZ9sbb0ufJu EvMhbzga0DlAXUVpVJ+Awpn4W2/Gez08edjIoOFWlXocxOS+0YiamlMsXqG7/PQY9Y1H FhqCqTpgGeUQMKRKDhuVNfpvi5YjEb8nDO/yecIqQqAOrkF+LVsXqqJPPUot7VKx001m e04qUwKBa7CY6wP4F5/bkR0cEUip2NvWpLORVkRUuuLoXSryfKJwyRBseCXDuCf1co+3 sOqw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:mime-version:from:date:message-id:subject:to; bh=6JJgYdb1V6WKdLgz0sbjZxegCfgJafKIqwa5tBGwKCo=; b=B5OfEvChoXc6JTIfoc7xDMzM2ldfTVxn9f2EH8o0f7cKa4T/BvtNApz9zsreQO1WG5 tBp/hsUjfwLFZ2xRvPzBFGQSaNoK5TYRnxowg5kJhWUdB3v6nu1kEfN5lDQuYtiXIWTp ylODzghE4SE1FpJI2sQvUtKhpZCrEQJaAhqOoVNZVf/K2+cE8pCO6WrkJ7f08illLfAK y96GwtJ5nSLhzBrr4fJoQab70a21KeA6pWcji49LXFGPGf1lgJLHsoRpzHp0jh4ENMaf z+0S7kjeY5wgM/f+0oHtzsExBTeNz3utRaU65BR3AokC7+Ur8Ap7bx6zy0UPum26OcAg 2S5Q== X-Gm-Message-State: AOAM532ewobWHYe50O4GM+reZpk5EkoXQNFYSpBFMbKBuzVQZWYxi7+K QKNYrT7iBCF7hQmb1LoyfwGKwLqVYfxDfZPaz8dKLZshKKRge9ZHUskU5pIbUxiyX2u5ZILSDYG ZZu6NoMncB5Hshx6h7pNuE7Ayj0PtlFOn52evxFNAhd1AXb7FSTkgNuNtSrVt5IgKqAzO7Cf+3i bKGBRCT4UiRsQxG3ovJuBF/ha2akgbxGiiKH3ZgQJ82I//GS3kDZjgxMYS/f22tjL/pw== X-Google-Smtp-Source: ABdhPJw+wNZQiHviNj1ynXi7l04akeG7ZSx8CVxSGy/kJLcK7MnLwGw4yrEUDR5NR+wm7uZ44iZOUsEiZ11W+Z3oZCw= X-Received: by 2002:a25:d258:: with SMTP id j85mr2735027ybg.398.1633585998448; Wed, 06 Oct 2021 22:53:18 -0700 (PDT) MIME-Version: 1.0 From: Nikhil Mohite Date: Thu, 7 Oct 2021 11:23:07 +0530 Message-ID: Subject: [pgAdmin][RM-6797]: SQL code displayed in second line for function, procedure and trigger function To: pgadmin-hackers Content-Type: multipart/mixed; boundary="00000000000025fe4905cdbce1ac" X-CLOUD-SEC-AV-Info: enterprisedb,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: Archived-At: Precedence: bulk --00000000000025fe4905cdbce1ac Content-Type: multipart/alternative; boundary="00000000000025fe4605cdbce1aa" --00000000000025fe4605cdbce1aa Content-Type: text/plain; charset="UTF-8" Hi Hackers, Please find the attached patch for RM-6797: SQL code displayed in second line for function, procedure and trigger function -- *Thanks & Regards,* *Nikhil Mohite* *Software Engineer.* *EDB Postgres* *Mob.No: +91-7798364578.* --00000000000025fe4605cdbce1aa Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi Hackers,

Please find the attached pa= tch for=C2=A0RM-6797= :=C2=A0SQL code displayed in second line for function, procedure and tr= igger function


--
Thanks & Regards,Nikhil Mohite
= Software Engineer.
EDB Postgres
Mob.No: +91-7798364578.
--00000000000025fe4605cdbce1aa-- --00000000000025fe4905cdbce1ac Content-Type: application/octet-stream; name="RM-6797.patch" Content-Disposition: attachment; filename="RM-6797.patch" Content-Transfer-Encoding: base64 Content-ID: X-Attachment-Id: f_kugil10c0 ZGlmZiAtLWdpdCBhL3dlYi9wZ2FkbWluL2Jyb3dzZXIvc2VydmVyX2dyb3Vwcy9zZXJ2ZXJzL2Rh dGFiYXNlcy9zY2hlbWFzL2Z1bmN0aW9ucy9fX2luaXRfXy5weSBiL3dlYi9wZ2FkbWluL2Jyb3dz ZXIvc2VydmVyX2dyb3Vwcy9zZXJ2ZXJzL2RhdGFiYXNlcy9zY2hlbWFzL2Z1bmN0aW9ucy9fX2lu aXRfXy5weQppbmRleCAzMzFmY2EyOS4uY2YzNGFiNzMgMTAwNjQ0Ci0tLSBhL3dlYi9wZ2FkbWlu L2Jyb3dzZXIvc2VydmVyX2dyb3Vwcy9zZXJ2ZXJzL2RhdGFiYXNlcy9zY2hlbWFzL2Z1bmN0aW9u cy9fX2luaXRfXy5weQorKysgYi93ZWIvcGdhZG1pbi9icm93c2VyL3NlcnZlcl9ncm91cHMvc2Vy dmVycy9kYXRhYmFzZXMvc2NoZW1hcy9mdW5jdGlvbnMvX19pbml0X18ucHkKQEAgLTg0Myw3ICs4 NDMsOCBAQCBjbGFzcyBGdW5jdGlvblZpZXcoUEdDaGlsZE5vZGVWaWV3LCBEYXRhVHlwZVJlYWRl ciwgU2NoZW1hRGlmZk9iamVjdENvbXBhcmUpOgogCiAgICAgICAgICMgR2V0IFNRTCB0byBjcmVh dGUgRnVuY3Rpb24KICAgICAgICAgc3RhdHVzLCBzcWwgPSBzZWxmLl9nZXRfc3FsKGdpZD1naWQs IHNpZD1zaWQsIGRpZD1kaWQsIHNjaWQ9c2NpZCwKLSAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgIGRhdGE9c2VsZi5yZXF1ZXN0KQorICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgZGF0YT1zZWxmLnJlcXVlc3QsCisgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICBhbGxvd19jb2RlX2Zvcm1hdHRpbmc9RmFsc2UpCiAgICAgICAgIGlmIG5vdCBzdGF0 dXM6CiAgICAgICAgICAgICByZXR1cm4gaW50ZXJuYWxfc2VydmVyX2Vycm9yKGVycm9ybXNnPXNx bCkKIApAQCAtOTUxLDcgKzk1Miw4IEBAIGNsYXNzIEZ1bmN0aW9uVmlldyhQR0NoaWxkTm9kZVZp ZXcsIERhdGFUeXBlUmVhZGVyLCBTY2hlbWFEaWZmT2JqZWN0Q29tcGFyZSk6CiAgICAgICAgICIi IgogCiAgICAgICAgIHN0YXR1cywgc3FsID0gc2VsZi5fZ2V0X3NxbChnaWQ9Z2lkLCBzaWQ9c2lk LCBkaWQ9ZGlkLCBzY2lkPXNjaWQsCi0gICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICBkYXRhPXNlbGYucmVxdWVzdCwgZm5pZD1mbmlkKQorICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgZGF0YT1zZWxmLnJlcXVlc3QsIGZuaWQ9Zm5pZCwKKyAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgIGFsbG93X2NvZGVfZm9ybWF0dGluZz1GYWxzZSkKICAgICAg ICAgaWYgbm90IHN0YXR1czoKICAgICAgICAgICAgIHJldHVybiBpbnRlcm5hbF9zZXJ2ZXJfZXJy b3IoZXJyb3Jtc2c9c3FsKQogCkBAIC0xMzcyLDcgKzEzNzQsNyBAQCBjbGFzcyBGdW5jdGlvblZp ZXcoUEdDaGlsZE5vZGVWaWV3LCBEYXRhVHlwZVJlYWRlciwgU2NoZW1hRGlmZk9iamVjdENvbXBh cmUpOgogICAgICAgICAgICAgICAgIGRhdGFbJ21lcmdlZF92YXJpYWJsZXMnXS5hcHBlbmQodikK IAogICAgIGRlZiBfZ2V0X3NxbF9mb3JfZWRpdF9tb2RlKHNlbGYsIGRhdGEsIHBhcmFsbGVsX2Rp Y3QsIGFsbF9pZHNfZGljdCwKLSAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICB2b2xfZGlj dCk6CisgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgdm9sX2RpY3QsIGFsbG93X2NvZGVf Zm9ybWF0dGluZz1UcnVlKToKICAgICAgICAgIiIiCiAgICAgICAgIFRoaXMgZnVuY3Rpb24gaXMg dXNlZCB0byBnZXQgdGhlIHNxbCBmb3IgZWRpdCBtb2RlLgogICAgICAgICA6cGFyYW0gZGF0YToK QEAgLTE0NTMsNyArMTQ1NSw4IEBAIGNsYXNzIEZ1bmN0aW9uVmlldyhQR0NoaWxkTm9kZVZpZXcs IERhdGFUeXBlUmVhZGVyLCBTY2hlbWFEaWZmT2JqZWN0Q29tcGFyZSk6CiAgICAgICAgIGVsc2U6 CiAgICAgICAgICAgICBGdW5jdGlvblZpZXcuX21lcmdlX3ZhcmlhYmxlcyhkYXRhKQogCi0gICAg ICAgIHNlbGYucmVmb3JtYXRfcHJvc3JjX2NvZGUoZGF0YSkKKyAgICAgICAgaWYgYWxsb3dfY29k ZV9mb3JtYXR0aW5nOgorICAgICAgICAgICAgc2VsZi5yZWZvcm1hdF9wcm9zcmNfY29kZShkYXRh KQogCiAgICAgICAgIHNxbCA9IHJlbmRlcl90ZW1wbGF0ZSgKICAgICAgICAgICAgICIvIi5qb2lu KFtzZWxmLnNxbF90ZW1wbGF0ZV9wYXRoLCBzZWxmLl9VUERBVEVfU1FMXSksCkBAIC0xNDc2LDYg KzE0NzksNyBAQCBjbGFzcyBGdW5jdGlvblZpZXcoUEdDaGlsZE5vZGVWaWV3LCBEYXRhVHlwZVJl YWRlciwgU2NoZW1hRGlmZk9iamVjdENvbXBhcmUpOgogICAgICAgICBmbmlkID0ga3dhcmdzLmdl dCgnZm5pZCcsIE5vbmUpCiAgICAgICAgIGlzX3NxbCA9IGt3YXJncy5nZXQoJ2lzX3NxbCcsIEZh bHNlKQogICAgICAgICBpc19zY2hlbWFfZGlmZiA9IGt3YXJncy5nZXQoJ2lzX3NjaGVtYV9kaWZm JywgRmFsc2UpCisgICAgICAgIGFsbG93X2NvZGVfZm9ybWF0dGluZyA9IGt3YXJncy5nZXQoJ2Fs bG93X2NvZGVfZm9ybWF0dGluZycsIFRydWUpCiAKICAgICAgICAgdm9sX2RpY3QgPSB7J3YnOiAn Vk9MQVRJTEUnLCAncyc6ICdTVEFCTEUnLCAnaSc6ICdJTU1VVEFCTEUnfQogICAgICAgICBwYXJh bGxlbF9kaWN0ID0geyd1JzogJ1VOU0FGRScsICdzJzogJ1NBRkUnLCAncic6ICdSRVNUUklDVEVE J30KQEAgLTE1MDAsNyArMTUwNCw4IEBAIGNsYXNzIEZ1bmN0aW9uVmlldyhQR0NoaWxkTm9kZVZp ZXcsIERhdGFUeXBlUmVhZGVyLCBTY2hlbWFEaWZmT2JqZWN0Q29tcGFyZSk6CiAgICAgICAgICAg ICAgICAgJ2lzX3NjaGVtYV9kaWZmJzogaXNfc2NoZW1hX2RpZmYsCiAgICAgICAgICAgICB9CiAg ICAgICAgICAgICBzdGF0dXMsIGVycm1zZywgc3FsID0gc2VsZi5fZ2V0X3NxbF9mb3JfZWRpdF9t b2RlKAotICAgICAgICAgICAgICAgIGRhdGEsIHBhcmFsbGVsX2RpY3QsIGFsbF9pZHNfZGljdCwg dm9sX2RpY3QpCisgICAgICAgICAgICAgICAgZGF0YSwgcGFyYWxsZWxfZGljdCwgYWxsX2lkc19k aWN0LCB2b2xfZGljdCwKKyAgICAgICAgICAgICAgICBhbGxvd19jb2RlX2Zvcm1hdHRpbmc9YWxs b3dfY29kZV9mb3JtYXR0aW5nKQogCiAgICAgICAgICAgICBpZiBub3Qgc3RhdHVzOgogICAgICAg ICAgICAgICAgIHJldHVybiBGYWxzZSwgZXJybXNnCkBAIC0xNTI0LDcgKzE1MjksOCBAQCBjbGFz cyBGdW5jdGlvblZpZXcoUEdDaGlsZE5vZGVWaWV3LCBEYXRhVHlwZVJlYWRlciwgU2NoZW1hRGlm Zk9iamVjdENvbXBhcmUpOgogCiAgICAgICAgICAgICBkYXRhWydmdW5jX2FyZ3Nfd2l0aG91dCdd ID0gJywgJy5qb2luKGFyZ3Nfd2l0aG91dF9uYW1lKQogCi0gICAgICAgICAgICBzZWxmLnJlZm9y bWF0X3Byb3NyY19jb2RlKGRhdGEpCisgICAgICAgICAgICBpZiBhbGxvd19jb2RlX2Zvcm1hdHRp bmc6CisgICAgICAgICAgICAgICAgc2VsZi5yZWZvcm1hdF9wcm9zcmNfY29kZShkYXRhKQogCiAg ICAgICAgICAgICAjIENyZWF0ZSBtb2RlCiAgICAgICAgICAgICBzcWwgPSByZW5kZXJfdGVtcGxh dGUoIi8iLmpvaW4oW3NlbGYuc3FsX3RlbXBsYXRlX3BhdGgsCg== --00000000000025fe4905cdbce1ac--