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 1kNuNU-0004Py-Nr for pgadmin-hackers@arkaria.postgresql.org; Thu, 01 Oct 2020 08:55:52 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kNuNS-0001P1-30 for pgadmin-hackers@arkaria.postgresql.org; Thu, 01 Oct 2020 08:55:50 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kNuNR-0001Ou-T2 for pgadmin-hackers@lists.postgresql.org; Thu, 01 Oct 2020 08:55:49 +0000 Received: from mail-pj1-x1041.google.com ([2607:f8b0:4864:20::1041]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1kNuNO-0007MP-Dj for pgadmin-hackers@postgresql.org; Thu, 01 Oct 2020 08:55:49 +0000 Received: by mail-pj1-x1041.google.com with SMTP id e15so18123pjg.0 for ; Thu, 01 Oct 2020 01:55:45 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=enterprisedb-com.20150623.gappssmtp.com; s=20150623; h=mime-version:references:in-reply-to:from:date:message-id:subject:to :cc; bh=pVa3pC2t83IJciCUj8M6zJdz2y0LaIdM32Vfu9GHXPQ=; b=cgBCVCRLgKRQFpwmIPdIKQtULGKpupA4kTARaOudBIShRubjBmlBaa2dSVZOXWRwwC Dqi+MKrXrVlihJfiAFKhLKDGeyIQpIuXmg4Z2fh2QAhF0GsLACjmpX5R7Jv82OaLGgAU c2/g/bJOagcwnM4ZtGFGvWP5p5ZeRPwNdN8jgS0KodKFHdCmQeoEXwiX91wWbvGZjnfr dhO1+DsmJLV4nW8ClcRd5XY016LDWn7PuCcQA7N6/7qlZufksoV03c/+hmv8VdnlnTfc 45yOQlJ+Nq1dnspRZz7EH8hoXlXOOvV6Cx1RfMXwd4IKD6m9YF5FyaPURO1pezNIv8nm b04w== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:references:in-reply-to:from:date :message-id:subject:to:cc; bh=pVa3pC2t83IJciCUj8M6zJdz2y0LaIdM32Vfu9GHXPQ=; b=faz0ZcihIzIIOFgQc7fyr2qpW3IBOI3GBng9sJnD0e1xzs/bZPo7TvqYs6yZNwrY/B RvtCfXnuDE1g3QPX54RBikHolpsGEyCXCR1setr7VjEKR+cUmK4c+Nlp2oW6wL2vFS6L +loOZUD6im66CjZr6Qfw+kenIcXL273GFzbeq5+3X2r6eqABG5W2liiteLz+IbeJRN/t nD02tnoCVG1CpVrqSwYoFbfq2w4/rcrNNUiEq7JDQVb3LDBg9+oNPKdzSqk9NWkCcScI I8GPuy54iOv4jPgenRYYPsUrPc6s3gQR6HrnoIJWOb+HGEMQ9FHjpTqSthCIb8UrD5el WiHg== X-Gm-Message-State: AOAM533LlgwSZal6YV+3esbAk0s7GJFQWFNV/Tx8ecl2PorYiYt4nweB HR2zZe25whJoB+lvBca/qM2jsX33qDUfLF29GuLosWayAmQN56LKXK68IMc7yjGRrLBxWUg2Xsq z+tNC/nL8AOFtLmWE/tZSgNMiLKxkcwm+Y6vz1O3bcQ6M/tW/53gWHgm0B1DQyBugLz7c0gPTte C2US1MH13NjHBEGOs66HFSZZFZ0vzjNDLRQQR1ycMH0NcsAKK5c3fEGHXojQ== X-Google-Smtp-Source: ABdhPJxN2qbueDFcJBqEpUuAbSX17uJtB3hBq139okUFI6mJjdIMYTbo5OtHuWTMsz4sg5bgQVw0uDAsy+4QsnEK9zc= X-Received: by 2002:a17:90b:fc4:: with SMTP id gd4mr6208773pjb.129.1601542543258; Thu, 01 Oct 2020 01:55:43 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Pradip Parkale Date: Thu, 1 Oct 2020 14:25:31 +0530 Message-ID: Subject: Re: [pgAdmin][RM5843] [SQL] - Some 'options' values for function not shown in sql To: Akshay Joshi Cc: pgadmin-hackers Content-Type: multipart/mixed; boundary="00000000000062a8d905b0982e22" 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: Precedence: bulk --00000000000062a8d905b0982e22 Content-Type: multipart/alternative; boundary="00000000000062a8d605b0982e20" --00000000000062a8d605b0982e20 Content-Type: text/plain; charset="UTF-8" Hi Akshay, Please find the attached patch to allow the user to modify the option settings of the procedure. This issue was only for PPAS 11 and PPAS 12. On Wed, Sep 23, 2020 at 11:30 PM Pradip Parkale < pradip.parkale@enterprisedb.com> wrote: > Hi Akshay, > > Please find the small patch for the ' Parallel Unsafe' option is missing > in SQL. It was missing in first patch for PG96 and PG10. > > > On Wed, Sep 23, 2020 at 1:25 PM Akshay Joshi < > akshay.joshi@enterprisedb.com> wrote: > >> Thanks, patch applied. It's a small fix so I have fixed it. >> >> On Wed, Sep 23, 2020 at 12:14 PM Akshay Joshi < >> akshay.joshi@enterprisedb.com> wrote: >> >>> Hi Pradip >>> >>> RESQL tests are failing on EPAS 9.5, 9.6, and 10. Please fix and resend >>> the patch. >>> >>> On Tue, Sep 22, 2020 at 6:41 PM Pradip Parkale < >>> pradip.parkale@enterprisedb.com> wrote: >>> >>>> Hi Hackers, >>>> >>>> The 'Unsafe' parallel option was not visible in the SQL for function >>>> and procedure. Attached is the patch to fix this issue. >>>> >>>> -- >>>> Thanks & Regards, >>>> Pradip Parkale >>>> Software Engineer | EnterpriseDB Corporation >>>> >>> >>> >>> -- >>> *Thanks & Regards* >>> *Akshay Joshi* >>> *pgAdmin Hacker | Sr. Software Architect* >>> *EDB Postgres * >>> >>> *Mobile: +91 976-788-8246* >>> >> >> >> -- >> *Thanks & Regards* >> *Akshay Joshi* >> *pgAdmin Hacker | Sr. Software Architect* >> *EDB Postgres * >> >> *Mobile: +91 976-788-8246* >> > > > -- > Thanks & Regards, > Pradip Parkale > Software Engineer | EnterpriseDB Corporation > -- Thanks & Regards, Pradip Parkale Software Engineer | EnterpriseDB Corporation --00000000000062a8d605b0982e20 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi Akshay,

Please find the attached pat= ch to allow the user to modify the option settings of the procedure. This i= ssue was only for PPAS 11 and PPAS 12.

On Wed, Sep 23, 2020 at 11:30 P= M Pradip Parkale <pra= dip.parkale@enterprisedb.com> wrote:
Hi=C2=A0Akshay,

Please find the small patch for th= e ' Parallel Unsafe' option is missing in SQL. It was missing in fi= rst=C2=A0patch for PG96 and PG10.


On Wed, Sep 23,= 2020 at 1:25 PM Akshay Joshi <akshay.joshi@enterprisedb.com> wrote:
<= /div>
Thanks, patch applied. It's a sm= all fix so I have fixed=C2=A0it.

On Wed, Sep 23, 2020 at 12:14 PM Akshay Jos= hi <a= kshay.joshi@enterprisedb.com> wrote:
Hi Pradip

RESQL tests are failing on EPAS 9.= 5, 9.6, and 10. Please fix and resend the patch.

On Tue, Sep 22, 2020= at 6:41 PM Pradip Parkale <pradip.parkale@enterprisedb.com> wrote:
=
Hi Hackers,

The = 'Unsafe' parallel option was not visible in the SQL for function an= d procedure. Attached is the patch to fix this issue.

--
Thanks & Regards,
Pradip Par= kale
Software Engineer | EnterpriseDB Corporation


--
Thank= s & Regards
Akshay Joshi
pgAdmin Hacker | Sr. Software Ar= chitect
EDB Postgres=
Mobile: +91 976-788-8246



--
Thank= s & Regards
Akshay Joshi
pgAdmin Hacker | Sr. Software Ar= chitect
EDB Postgres=
Mobile: +91 976-788-8246



--
Thanks & Regards,
=
Pradip Parkale
Software Engineer |= EnterpriseDB Corporation


--
Thanks & Regards,
Pradip Park= ale
Software Engineer | EnterpriseDB Corporation
--00000000000062a8d605b0982e20-- --00000000000062a8d905b0982e22 Content-Type: application/octet-stream; name="RM5843_v3.patch" Content-Disposition: attachment; filename="RM5843_v3.patch" Content-Transfer-Encoding: base64 Content-ID: X-Attachment-Id: f_kfql24nc0 ZGlmZiAtLWdpdCBhL3dlYi9wZ2FkbWluL2Jyb3dzZXIvc2VydmVyX2dyb3Vwcy9zZXJ2ZXJzL2Rh dGFiYXNlcy9zY2hlbWFzL2Z1bmN0aW9ucy90ZW1wbGF0ZXMvcHJvY2VkdXJlcy9wcGFzL3NxbC8x MV9wbHVzL3VwZGF0ZS5zcWwgYi93ZWIvcGdhZG1pbi9icm93c2VyL3NlcnZlcl9ncm91cHMvc2Vy dmVycy9kYXRhYmFzZXMvc2NoZW1hcy9mdW5jdGlvbnMvdGVtcGxhdGVzL3Byb2NlZHVyZXMvcHBh cy9zcWwvMTFfcGx1cy91cGRhdGUuc3FsCmluZGV4IGI4ZGY5YjkzMy4uNmU3MTE3MjRkIDEwMDY0 NAotLS0gYS93ZWIvcGdhZG1pbi9icm93c2VyL3NlcnZlcl9ncm91cHMvc2VydmVycy9kYXRhYmFz ZXMvc2NoZW1hcy9mdW5jdGlvbnMvdGVtcGxhdGVzL3Byb2NlZHVyZXMvcHBhcy9zcWwvMTFfcGx1 cy91cGRhdGUuc3FsCisrKyBiL3dlYi9wZ2FkbWluL2Jyb3dzZXIvc2VydmVyX2dyb3Vwcy9zZXJ2 ZXJzL2RhdGFiYXNlcy9zY2hlbWFzL2Z1bmN0aW9ucy90ZW1wbGF0ZXMvcHJvY2VkdXJlcy9wcGFz L3NxbC8xMV9wbHVzL3VwZGF0ZS5zcWwKQEAgLTIyLDggKzIyLDkgQEAgQ1JFQVRFIE9SIFJFUExB Q0UgUFJPQ0VEVVJFIHt7IGNvbm58cXRJZGVudChvX2RhdGEucHJvbmFtZXNwYWNlLCBuYW1lKSB9 fSh7JSBpZgogICAgIExBTkdVQUdFIHt7IGRhdGEubGFubmFtZXxxdExpdGVyYWwgfX0geyUgZWxz ZSAlfQogICAgIExBTkdVQUdFIHt7IG9fZGF0YS5sYW5uYW1lfHF0TGl0ZXJhbCB9fQogICAgIHsl IGVuZGlmICV9Cit7eyBkYXRhLnByb3ZvbGF0aWxlIH19CiB7JSBpZiAoJ3Byb3NlY2RlZicgaW4g ZGF0YSBhbmQgZGF0YS5wcm9zZWNkZWYpIG9yICgncHJvc2VjZGVmJyBub3QgaW4gZGF0YSBhbmQg b19kYXRhLnByb3NlY2RlZikgJX1TRUNVUklUWSBERUZJTkVSeyUgZW5kaWYgJX0KLXslIGlmIGRh dGEubGFubmFtZSA9PSAnZWRic3BsJyAlfQoreyUgaWYgZGF0YS5sYW5uYW1lID09ICdlZGJzcGwn IG9yIChvX2RhdGEubGFubmFtZSA9PSAnZWRic3BsJyBhbmQgbm90ICdsYW5uYW1lJyBpbiBkYXRh ICkgJX0KIHslIGlmICgncHJvbGVha3Byb29mJyBpbiBkYXRhIGFuZCBkYXRhLnByb2xlYWtwcm9v Zikgb3IgKCdwcm9sZWFrcHJvb2YnIG5vdCBpbiBkYXRhIGFuZCBvX2RhdGEucHJvbGVha3Byb29m KSAlfSBMRUFLUFJPT0Z7JSBlbHNlICV9IE5PVCBMRUFLUFJPT0Z7JSBlbmRpZiAlfQogICAgIHsl IGlmICgncHJvaXNzdHJpY3QnIGluIGRhdGEgYW5kIGRhdGEucHJvaXNzdHJpY3QpIG9yICgncHJv aXNzdHJpY3QnIG5vdCBpbiBkYXRhIGFuZCBvX2RhdGEucHJvaXNzdHJpY3QpICV9IFNUUklDVHsl IGVuZGlmICV9CiAK --00000000000062a8d905b0982e22--