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 1kPMX1-0003iA-WA for pgadmin-hackers@arkaria.postgresql.org; Mon, 05 Oct 2020 09:11:44 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kPMX0-0004sg-6C for pgadmin-hackers@arkaria.postgresql.org; Mon, 05 Oct 2020 09:11:42 +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 1kPMWz-0004sZ-Ss for pgadmin-hackers@lists.postgresql.org; Mon, 05 Oct 2020 09:11:42 +0000 Received: from mail-io1-xd32.google.com ([2607:f8b0:4864:20::d32]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1kPMWx-0001xR-4b for pgadmin-hackers@postgresql.org; Mon, 05 Oct 2020 09:11:40 +0000 Received: by mail-io1-xd32.google.com with SMTP id l8so8319335ioh.11 for ; Mon, 05 Oct 2020 02:11:38 -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=0ayllPkm7Gd3QXdSgE4kCUr9Tah+74qGIyXYnzRodJQ=; b=vBL6cVZIhGKagQd6TYFpx740SWeEb9XCIY91L8VJJShw8n78aoQShk7NDwSJMHZnlS TRK/YXuHhXICL70Aaz9oKjSPvigJxboQD5WNVR29KYhUY39cdZDkAZIIXtB5oncU9ajf u5pgamwnDqE+vZI0RLuBgFZQNU8Kpp7i5OUZvQW1IpboZuQw9XEGvn2d1X0FOQ+fgXqh pPQ93f5iJQN5BPLewgegzCVEICnNlmgLu0Cmcjq1MYII94gG22r5v/blHHVQfd0GHleW X5vjbNDAWBO9hp4DrtbX8zzW4Hp+gLJsOa8+5p9JhuELUyH5Z58QnWmDSw4UBNr4NYmF eKLA== 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=0ayllPkm7Gd3QXdSgE4kCUr9Tah+74qGIyXYnzRodJQ=; b=orz1i4cUBGyTZ1RF1Fn15nrWUgQFCnTr6eDydsdTSHYXC+h5bIw6C40aj7RHdKeVUV yMNTlx2duMkJuQMe9kq5A9ZGeuNOs9gE41dLQQ7tcQ+KZhfVcT7rkyaqFOIE+fgnYyL+ f79TUJSz99WbNfLpOrEei2u9E/ZItCDSo5UpZcb0NC0/Pb5SJwtXkuiO6tQWkAeX21aw 068p4kG80QkuD8tilNBCuxLOHpPjRTapzns9XrsuSws1aEhsuE+bCKoJsO+5TctC7Gdu JPJkndTubp/XuIQ1dY+dSywoiayZ3SrkJFnQ3CYN0td+En3x+y2bRoL0PWk5bV81yDqf lGPA== X-Gm-Message-State: AOAM5329VghUocpkHHwRJjcnaXyCDntEUGqmYJC1U9JuKNgBAs8ABKAP H3tijagCWtdTm2nmtCethMs3gEAkJ/f65kYxDPN79fgRyo6R4EltmyIELut+VmuKD68CactiswM 2hY/LOkEWlWrpQEOGKUJqSNzqjGCbYiISSBdbgnhY6RcgKJjgKdVQFikzOInuJo3v7YywvsHbbG S5sxTv1ltfi2jvbkimh78VtQ8nxoI1S2+Hu+Eijphh3XYY6MUY3pFDr4GhKA== X-Google-Smtp-Source: ABdhPJzqRQ3TlnPDtaeumkF88w+N9eHEvzy04Vo2Rlv2atHMMBFKZmHEulmx5dDDUdhfsagVlK4/0m+4hXOFYXsolOQ= X-Received: by 2002:a02:7350:: with SMTP id a16mr11252134jae.53.1601889097901; Mon, 05 Oct 2020 02:11:37 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Akshay Joshi Date: Mon, 5 Oct 2020 14:41:27 +0530 Message-ID: Subject: Re: [pgAdmin][RM5843] [SQL] - Some 'options' values for function not shown in sql To: Pradip Parkale Cc: pgadmin-hackers Content-Type: multipart/alternative; boundary="000000000000a6834d05b0e8de67" 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 --000000000000a6834d05b0e8de67 Content-Type: text/plain; charset="UTF-8" Thanks, patch applied. On Thu, Oct 1, 2020 at 2:25 PM Pradip Parkale < pradip.parkale@enterprisedb.com> wrote: > 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 > -- *Thanks & Regards* *Akshay Joshi* *pgAdmin Hacker | Sr. Software Architect* *EDB Postgres * *Mobile: +91 976-788-8246* --000000000000a6834d05b0e8de67 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Thanks, patch applied.

On Thu, Oct 1, 2020 at 2:25 PM Pradi= p Parkale <pradip.par= kale@enterprisedb.com> wrote:
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, Se= p 23, 2020 at 11:30 PM Pradip Parkale <pradip.parkale@enterprisedb.com>= wrote:
Hi=C2=A0Akshay,

Please find the small patch for the &= #39; Parallel Unsafe' option is missing in SQL. It was missing in first= =C2=A0patch for PG96 and PG10.


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

On Wed, Sep 2= 3, 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 P= radip 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


--
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 Parkale
Software Engineer |= EnterpriseDB Corporation


--
Thanks & Regards
Akshay Joshi
pgAdmi= n Hacker | Sr. Software Architect
EDB Postgres
Mobile: +91 976-788-8246
=
--000000000000a6834d05b0e8de67--