Received: from malur.postgresql.org ([2a02:16a8:dc51::56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fTibm-0004nh-9f for pgadmin-hackers@arkaria.postgresql.org; Fri, 15 Jun 2018 06:53:18 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1fTibl-0006Hu-0D for pgadmin-hackers@arkaria.postgresql.org; Fri, 15 Jun 2018 06:53:17 +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_SHA384:256) (Exim 4.89) (envelope-from ) id 1fTibk-0006Hk-RF for pgadmin-hackers@lists.postgresql.org; Fri, 15 Jun 2018 06:53:16 +0000 Received: from mail-pg0-x22f.google.com ([2607:f8b0:400e:c05::22f]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1fTibg-0005rL-G0 for pgadmin-hackers@postgresql.org; Fri, 15 Jun 2018 06:53:16 +0000 Received: by mail-pg0-x22f.google.com with SMTP id e11-v6so4023156pgq.0 for ; Thu, 14 Jun 2018 23:53:11 -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=Du9Yo3zNKoz/VaQOmR3MPfSOtLbh3yT0/UG47iQ0hmw=; b=PbQcaQhjAUyGyChoAP6yIYXeQMtWgFb6cplM7TxqXolyaXoqFOLGvH3ur9Sg8JKhns Dd2a40ggI2TcWoA959wrWlGdPd5eangpzUzqfIkg4L/4t8KM+svb17WOlIVsmXbv4kDZ lfrbMdwE02kBRTZqffMHOlzn6YExhx4QqTiaMJtwqh+t6jCYmnNQOsoSCve7b9hQ221J kFR3hZqXC4XflqIdKumQp+n8nv9SP0rGBLiwZW4ZgcD/2Ml2YksahIuz87vwzRSltyQY KdOboKVxbopWyfSNW01VRO9T3z/F0f6CEQv0wCZYHE3fHeAy6w5/gPpGf6KS2Y3dX+Io aJvw== 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=Du9Yo3zNKoz/VaQOmR3MPfSOtLbh3yT0/UG47iQ0hmw=; b=GjwBIN2z7QoOv/AJx5YK00KlTO5D0iQYe9p+ODPvTLAlKiYm4F+uge6nnf7VnbLy+e VCcAJs73n+oErn65HFgUrUEZ9DLvtWVutoOkQj5EIRYbRMuWJc8tqa0Awf8puO3IaRqk hZE3VFLW6wt5DCjXsXSIIObHW6ppHKGfqsxXxokds+Sf1V2GmdPRykXU7vOTaDJJggRc Ffyg/YQFxUa5w6bIO6eASTPR8NWpBod8QkaCCV+ItK8eAtg7aflle2waiSyzBXNnS+ph bgbP+tCSUGW95d0Hr6f9KI1iUrkk9HDRqiLYpPeIbJ3rRpEDB21+Kx3oGMiOYA09IHSF gplA== X-Gm-Message-State: APt69E3e/sXRzDKD7erRB4JVanvd9VC/nZzEM2fEWjbhc8fn565cwJSr CViF06R+xTKgeOLvEtgvK6lZe3pZmH5IclaHJudy7Q== X-Google-Smtp-Source: ADUXVKJUUVM2F02IPIwxAePpNZtEoTTcYkMXeMO/Q9LTsm+NACUGug8NHPVIAsar7xhOC8Xfvczy8HZlOGyeK9nozvA= X-Received: by 2002:a63:aa4c:: with SMTP id x12-v6mr393785pgo.387.1529045589580; Thu, 14 Jun 2018 23:53:09 -0700 (PDT) MIME-Version: 1.0 Received: by 2002:a17:90a:8c86:0:0:0:0 with HTTP; Thu, 14 Jun 2018 23:53:08 -0700 (PDT) From: Akshay Joshi Date: Fri, 15 Jun 2018 12:23:08 +0530 Message-ID: Subject: [pgadmin4][Patch]: Remove extra space from create script for Procedures. To: pgadmin-hackers Content-Type: multipart/mixed; boundary="00000000000036952b056ea8ab05" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --00000000000036952b056ea8ab05 Content-Type: multipart/alternative; boundary="000000000000369522056ea8ab03" --000000000000369522056ea8ab03 Content-Type: text/plain; charset="UTF-8" Hi Hackers, Attached is the patch to remove extra space from create script for Procedures. Please review it. -- *Akshay Joshi* *Sr. Software Architect * *Phone: +91 20-3058-9517Mobile: +91 976-788-8246* --000000000000369522056ea8ab03 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi Hackers,=C2=A0

Attached is the patch= to remove extra space from create script for Procedures. Please review it.= =C2=A0

--
Akshay Joshi
Sr. Software Ar= chitect


Phone: +91 20-3058-9517
Mobile: +91 976-788-8246=
--000000000000369522056ea8ab03-- --00000000000036952b056ea8ab05 Content-Type: application/octet-stream; name="Remove_Extra_Space_Procedure.patch" Content-Disposition: attachment; filename="Remove_Extra_Space_Procedure.patch" Content-Transfer-Encoding: base64 X-Attachment-Id: f_jifm98hh0 ZGlmZiAtLWdpdCBhL3dlYi9wZ2FkbWluL2Jyb3dzZXIvc2VydmVyX2dyb3Vwcy9zZXJ2ZXJzL2Rh dGFiYXNlcy9zY2hlbWFzL2Z1bmN0aW9ucy90ZW1wbGF0ZXMvcHJvY2VkdXJlL3BnL3NxbC9kZWZh dWx0L2NyZWF0ZS5zcWwgYi93ZWIvcGdhZG1pbi9icm93c2VyL3NlcnZlcl9ncm91cHMvc2VydmVy cy9kYXRhYmFzZXMvc2NoZW1hcy9mdW5jdGlvbnMvdGVtcGxhdGVzL3Byb2NlZHVyZS9wZy9zcWwv ZGVmYXVsdC9jcmVhdGUuc3FsCmluZGV4IDNmOTE1MWYuLjNjNzE2NDAgMTAwNjQ0Ci0tLSBhL3dl Yi9wZ2FkbWluL2Jyb3dzZXIvc2VydmVyX2dyb3Vwcy9zZXJ2ZXJzL2RhdGFiYXNlcy9zY2hlbWFz L2Z1bmN0aW9ucy90ZW1wbGF0ZXMvcHJvY2VkdXJlL3BnL3NxbC9kZWZhdWx0L2NyZWF0ZS5zcWwK KysrIGIvd2ViL3BnYWRtaW4vYnJvd3Nlci9zZXJ2ZXJfZ3JvdXBzL3NlcnZlcnMvZGF0YWJhc2Vz L3NjaGVtYXMvZnVuY3Rpb25zL3RlbXBsYXRlcy9wcm9jZWR1cmUvcGcvc3FsL2RlZmF1bHQvY3Jl YXRlLnNxbApAQCAtNCw3ICs0LDcgQEAKIHslIHNldCBpc19jb2x1bW5zID0gW10gJX0KIHslIGlm IGRhdGEgJX0KIHslIGlmIHF1ZXJ5X2ZvciA9PSAnc3FsX3BhbmVsJyBhbmQgZnVuY19kZWYgaXMg ZGVmaW5lZCAlfQotQ1JFQVRFIE9SIFJFUExBQ0UgIFBST0NFRFVSRSB7e2Z1bmNfZGVmfX0KK0NS RUFURSBPUiBSRVBMQUNFIFBST0NFRFVSRSB7e2Z1bmNfZGVmfX0KIHslIGVsc2UgJX0KIENSRUFU RSBPUiBSRVBMQUNFIFBST0NFRFVSRSB7eyBjb25ufHF0SWRlbnQoZGF0YS5wcm9uYW1lc3BhY2Us IGRhdGEubmFtZSkgfX17JSBpZiBkYXRhLmFyZ3VtZW50cyBpcyBkZWZpbmVkICV9CiAoeyUgZm9y IHAgaW4gZGF0YS5hcmd1bWVudHMgJX17JSBpZiBwLmFyZ21vZGUgJX17e3AuYXJnbW9kZX19IHsl IGVuZGlmICV9eyUgaWYgcC5hcmduYW1lICV9e3sgY29ubnxxdElkZW50KHAuYXJnbmFtZSl9fSB7 JSBlbmRpZiAlfXslIGlmIHAuYXJndHlwZSAlfXt7IGNvbm58cXRUeXBlSWRlbnQocC5hcmd0eXBl KSB9fXslIGVuZGlmICV9eyUgaWYgcC5hcmdkZWZ2YWwgJX0gREVGQVVMVCB7e3AuYXJnZGVmdmFs fX17JSBlbmRpZiAlfQpkaWZmIC0tZ2l0IGEvd2ViL3BnYWRtaW4vYnJvd3Nlci9zZXJ2ZXJfZ3Jv dXBzL3NlcnZlcnMvZGF0YWJhc2VzL3NjaGVtYXMvZnVuY3Rpb25zL3RlbXBsYXRlcy9wcm9jZWR1 cmUvcHBhcy9zcWwvOS4yX3BsdXMvY3JlYXRlLnNxbCBiL3dlYi9wZ2FkbWluL2Jyb3dzZXIvc2Vy dmVyX2dyb3Vwcy9zZXJ2ZXJzL2RhdGFiYXNlcy9zY2hlbWFzL2Z1bmN0aW9ucy90ZW1wbGF0ZXMv cHJvY2VkdXJlL3BwYXMvc3FsLzkuMl9wbHVzL2NyZWF0ZS5zcWwKaW5kZXggM2M0NDYwMi4uNzM0 NGVlMSAxMDA2NDQKLS0tIGEvd2ViL3BnYWRtaW4vYnJvd3Nlci9zZXJ2ZXJfZ3JvdXBzL3NlcnZl cnMvZGF0YWJhc2VzL3NjaGVtYXMvZnVuY3Rpb25zL3RlbXBsYXRlcy9wcm9jZWR1cmUvcHBhcy9z cWwvOS4yX3BsdXMvY3JlYXRlLnNxbAorKysgYi93ZWIvcGdhZG1pbi9icm93c2VyL3NlcnZlcl9n cm91cHMvc2VydmVycy9kYXRhYmFzZXMvc2NoZW1hcy9mdW5jdGlvbnMvdGVtcGxhdGVzL3Byb2Nl ZHVyZS9wcGFzL3NxbC85LjJfcGx1cy9jcmVhdGUuc3FsCkBAIC00LDcgKzQsNyBAQAogeyUgc2V0 IGlzX2NvbHVtbnMgPSBbXSAlfQogeyUgaWYgZGF0YSAlfQogeyUgaWYgcXVlcnlfZm9yID09ICdz cWxfcGFuZWwnIGFuZCBmdW5jX2RlZiBpcyBkZWZpbmVkICV9Ci1DUkVBVEUgT1IgUkVQTEFDRSAg UFJPQ0VEVVJFIHt7ZnVuY19kZWZ9fQorQ1JFQVRFIE9SIFJFUExBQ0UgUFJPQ0VEVVJFIHt7ZnVu Y19kZWZ9fQogeyUgZWxzZSAlfQogQ1JFQVRFIE9SIFJFUExBQ0UgUFJPQ0VEVVJFIHt7IGNvbm58 cXRJZGVudChkYXRhLnByb25hbWVzcGFjZSwgZGF0YS5uYW1lKSB9fXslIGlmIGRhdGEuYXJndW1l bnRzIGlzIGRlZmluZWQgJX0KICh7JSBmb3IgcCBpbiBkYXRhLmFyZ3VtZW50cyAlfXslIGlmIHAu YXJnbW9kZSAlfXt7cC5hcmdtb2RlfX0geyUgZW5kaWYgJX17JSBpZiBwLmFyZ25hbWUgJX17eyBj b25ufHF0SWRlbnQocC5hcmduYW1lKX19IHslIGVuZGlmICV9eyUgaWYgcC5hcmd0eXBlICV9e3sg Y29ubnxxdFR5cGVJZGVudChwLmFyZ3R5cGUpIH19eyUgZW5kaWYgJX17JSBpZiBwLmFyZ2RlZnZh bCAlfSBERUZBVUxUIHt7cC5hcmdkZWZ2YWx9fXslIGVuZGlmICV9CmRpZmYgLS1naXQgYS93ZWIv cGdhZG1pbi9icm93c2VyL3NlcnZlcl9ncm91cHMvc2VydmVycy9kYXRhYmFzZXMvc2NoZW1hcy9m dW5jdGlvbnMvdGVtcGxhdGVzL3Byb2NlZHVyZS9wcGFzL3NxbC85LjVfcGx1cy9jcmVhdGUuc3Fs IGIvd2ViL3BnYWRtaW4vYnJvd3Nlci9zZXJ2ZXJfZ3JvdXBzL3NlcnZlcnMvZGF0YWJhc2VzL3Nj aGVtYXMvZnVuY3Rpb25zL3RlbXBsYXRlcy9wcm9jZWR1cmUvcHBhcy9zcWwvOS41X3BsdXMvY3Jl YXRlLnNxbAppbmRleCBkMDNjNWMxLi4wY2JkNTY5IDEwMDY0NAotLS0gYS93ZWIvcGdhZG1pbi9i cm93c2VyL3NlcnZlcl9ncm91cHMvc2VydmVycy9kYXRhYmFzZXMvc2NoZW1hcy9mdW5jdGlvbnMv dGVtcGxhdGVzL3Byb2NlZHVyZS9wcGFzL3NxbC85LjVfcGx1cy9jcmVhdGUuc3FsCisrKyBiL3dl Yi9wZ2FkbWluL2Jyb3dzZXIvc2VydmVyX2dyb3Vwcy9zZXJ2ZXJzL2RhdGFiYXNlcy9zY2hlbWFz L2Z1bmN0aW9ucy90ZW1wbGF0ZXMvcHJvY2VkdXJlL3BwYXMvc3FsLzkuNV9wbHVzL2NyZWF0ZS5z cWwKQEAgLTQsNyArNCw3IEBACiB7JSBzZXQgaXNfY29sdW1ucyA9IFtdICV9CiB7JSBpZiBkYXRh ICV9CiB7JSBpZiBxdWVyeV9mb3IgPT0gJ3NxbF9wYW5lbCcgYW5kIGZ1bmNfZGVmIGlzIGRlZmlu ZWQgJX0KLUNSRUFURSBPUiBSRVBMQUNFICBQUk9DRURVUkUge3tmdW5jX2RlZn19CitDUkVBVEUg T1IgUkVQTEFDRSBQUk9DRURVUkUge3tmdW5jX2RlZn19CiB7JSBlbHNlICV9CiBDUkVBVEUgT1Ig UkVQTEFDRSBQUk9DRURVUkUge3sgY29ubnxxdElkZW50KGRhdGEucHJvbmFtZXNwYWNlLCBkYXRh Lm5hbWUpIH19eyUgaWYgZGF0YS5hcmd1bWVudHMgaXMgZGVmaW5lZCAlfQogKHslIGZvciBwIGlu IGRhdGEuYXJndW1lbnRzICV9eyUgaWYgcC5hcmdtb2RlICV9e3twLmFyZ21vZGV9fSB7JSBlbmRp ZiAlfXslIGlmIHAuYXJnbmFtZSAlfXt7IGNvbm58cXRJZGVudChwLmFyZ25hbWUpfX0geyUgZW5k aWYgJX17JSBpZiBwLmFyZ3R5cGUgJX17eyBjb25ufHF0VHlwZUlkZW50KHAuYXJndHlwZSkgfX17 JSBlbmRpZiAlfXslIGlmIHAuYXJnZGVmdmFsICV9IERFRkFVTFQge3twLmFyZ2RlZnZhbH19eyUg ZW5kaWYgJX0KZGlmZiAtLWdpdCBhL3dlYi9wZ2FkbWluL2Jyb3dzZXIvc2VydmVyX2dyb3Vwcy9z ZXJ2ZXJzL2RhdGFiYXNlcy9zY2hlbWFzL2Z1bmN0aW9ucy90ZW1wbGF0ZXMvcHJvY2VkdXJlL3Bw YXMvc3FsLzkuNl9wbHVzL2NyZWF0ZS5zcWwgYi93ZWIvcGdhZG1pbi9icm93c2VyL3NlcnZlcl9n cm91cHMvc2VydmVycy9kYXRhYmFzZXMvc2NoZW1hcy9mdW5jdGlvbnMvdGVtcGxhdGVzL3Byb2Nl ZHVyZS9wcGFzL3NxbC85LjZfcGx1cy9jcmVhdGUuc3FsCmluZGV4IDQxZDlhNTYuLmU4M2Q3N2Ig MTAwNjQ0Ci0tLSBhL3dlYi9wZ2FkbWluL2Jyb3dzZXIvc2VydmVyX2dyb3Vwcy9zZXJ2ZXJzL2Rh dGFiYXNlcy9zY2hlbWFzL2Z1bmN0aW9ucy90ZW1wbGF0ZXMvcHJvY2VkdXJlL3BwYXMvc3FsLzku Nl9wbHVzL2NyZWF0ZS5zcWwKKysrIGIvd2ViL3BnYWRtaW4vYnJvd3Nlci9zZXJ2ZXJfZ3JvdXBz L3NlcnZlcnMvZGF0YWJhc2VzL3NjaGVtYXMvZnVuY3Rpb25zL3RlbXBsYXRlcy9wcm9jZWR1cmUv cHBhcy9zcWwvOS42X3BsdXMvY3JlYXRlLnNxbApAQCAtNCw3ICs0LDcgQEAKIHslIHNldCBpc19j b2x1bW5zID0gW10gJX0KIHslIGlmIGRhdGEgJX0KIHslIGlmIHF1ZXJ5X2ZvciA9PSAnc3FsX3Bh bmVsJyBhbmQgZnVuY19kZWYgaXMgZGVmaW5lZCAlfQotQ1JFQVRFIE9SIFJFUExBQ0UgIFBST0NF RFVSRSB7e2Z1bmNfZGVmfX0KK0NSRUFURSBPUiBSRVBMQUNFIFBST0NFRFVSRSB7e2Z1bmNfZGVm fX0KIHslIGVsc2UgJX0KIENSRUFURSBPUiBSRVBMQUNFIFBST0NFRFVSRSB7eyBjb25ufHF0SWRl bnQoZGF0YS5wcm9uYW1lc3BhY2UsIGRhdGEubmFtZSkgfX17JSBpZiBkYXRhLmFyZ3VtZW50cyBp cyBkZWZpbmVkICV9CiAoeyUgZm9yIHAgaW4gZGF0YS5hcmd1bWVudHMgJX17JSBpZiBwLmFyZ21v ZGUgJX17e3AuYXJnbW9kZX19IHslIGVuZGlmICV9eyUgaWYgcC5hcmduYW1lICV9e3sgY29ubnxx dElkZW50KHAuYXJnbmFtZSl9fSB7JSBlbmRpZiAlfXslIGlmIHAuYXJndHlwZSAlfXt7IGNvbm58 cXRUeXBlSWRlbnQocC5hcmd0eXBlKSB9fXslIGVuZGlmICV9eyUgaWYgcC5hcmdkZWZ2YWwgJX0g REVGQVVMVCB7e3AuYXJnZGVmdmFsfX17JSBlbmRpZiAlfQpkaWZmIC0tZ2l0IGEvd2ViL3BnYWRt aW4vYnJvd3Nlci9zZXJ2ZXJfZ3JvdXBzL3NlcnZlcnMvZGF0YWJhc2VzL3NjaGVtYXMvZnVuY3Rp b25zL3RlbXBsYXRlcy9wcm9jZWR1cmUvcHBhcy9zcWwvZGVmYXVsdC9jcmVhdGUuc3FsIGIvd2Vi L3BnYWRtaW4vYnJvd3Nlci9zZXJ2ZXJfZ3JvdXBzL3NlcnZlcnMvZGF0YWJhc2VzL3NjaGVtYXMv ZnVuY3Rpb25zL3RlbXBsYXRlcy9wcm9jZWR1cmUvcHBhcy9zcWwvZGVmYXVsdC9jcmVhdGUuc3Fs CmluZGV4IDRiMDllZWIuLjlmM2U5NjAgMTAwNjQ0Ci0tLSBhL3dlYi9wZ2FkbWluL2Jyb3dzZXIv c2VydmVyX2dyb3Vwcy9zZXJ2ZXJzL2RhdGFiYXNlcy9zY2hlbWFzL2Z1bmN0aW9ucy90ZW1wbGF0 ZXMvcHJvY2VkdXJlL3BwYXMvc3FsL2RlZmF1bHQvY3JlYXRlLnNxbAorKysgYi93ZWIvcGdhZG1p bi9icm93c2VyL3NlcnZlcl9ncm91cHMvc2VydmVycy9kYXRhYmFzZXMvc2NoZW1hcy9mdW5jdGlv bnMvdGVtcGxhdGVzL3Byb2NlZHVyZS9wcGFzL3NxbC9kZWZhdWx0L2NyZWF0ZS5zcWwKQEAgLTQs NyArNCw3IEBACiB7JSBzZXQgaXNfY29sdW1ucyA9IFtdICV9CiB7JSBpZiBkYXRhICV9CiB7JSBp ZiBxdWVyeV9mb3IgPT0gJ3NxbF9wYW5lbCcgYW5kIGZ1bmNfZGVmIGlzIGRlZmluZWQgJX0KLUNS RUFURSBPUiBSRVBMQUNFICBQUk9DRURVUkUge3tmdW5jX2RlZn19CitDUkVBVEUgT1IgUkVQTEFD RSBQUk9DRURVUkUge3tmdW5jX2RlZn19CiB7JSBlbHNlICV9CiBDUkVBVEUgT1IgUkVQTEFDRSBQ Uk9DRURVUkUge3sgY29ubnxxdElkZW50KGRhdGEucHJvbmFtZXNwYWNlLCBkYXRhLm5hbWUpIH19 eyUgaWYgZGF0YS5hcmd1bWVudHMgaXMgZGVmaW5lZCAlfQogKHslIGZvciBwIGluIGRhdGEuYXJn dW1lbnRzICV9eyUgaWYgcC5hcmdtb2RlICV9e3twLmFyZ21vZGV9fSB7JSBlbmRpZiAlfXslIGlm IHAuYXJnbmFtZSAlfXt7IGNvbm58cXRJZGVudChwLmFyZ25hbWUpfX0geyUgZW5kaWYgJX17JSBp ZiBwLmFyZ3R5cGUgJX17eyBjb25ufHF0VHlwZUlkZW50KHAuYXJndHlwZSkgfX17JSBlbmRpZiAl fXslIGlmIHAuYXJnZGVmdmFsICV9IERFRkFVTFQge3twLmFyZ2RlZnZhbH19eyUgZW5kaWYgJX0K --00000000000036952b056ea8ab05--