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 1kL94B-000647-Nw for pgadmin-hackers@arkaria.postgresql.org; Wed, 23 Sep 2020 18:00:31 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kL949-00042C-0o for pgadmin-hackers@arkaria.postgresql.org; Wed, 23 Sep 2020 18:00:29 +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 1kL948-00041z-Jc for pgadmin-hackers@lists.postgresql.org; Wed, 23 Sep 2020 18:00:28 +0000 Received: from mail-pj1-x102b.google.com ([2607:f8b0:4864:20::102b]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1kL945-0002QQ-1f for pgadmin-hackers@postgresql.org; Wed, 23 Sep 2020 18:00:27 +0000 Received: by mail-pj1-x102b.google.com with SMTP id mm21so114718pjb.4 for ; Wed, 23 Sep 2020 11:00:24 -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=3MDcQJHVWj45Hn6tFeUcPjOZQweWzPpUSsMFhpdDeg0=; b=PAMi28kL/Cpak4n0H8Vj0eGuFzbSrYZ28XpJ/SDWAUOfquA2hiB7bHmuvdF1NnmsAS jKkSCBfWw+cV8Bd+MiBbdjTCgUivsIwvL5OOo9L9IaP39oyNyRfe8rNC5suNCj4nvFbc QFHP2f2EaCClEjC0+TgZ6bTlvUpzOk8YxkMOLMfxVnaw2RxVI/XmkDJP+J0jOBuE5iYD Tw2xheQ4duGDiKhTFwMp1b0lxKr5w8TN0ozDoByufRgHdehFANq5emkHQrpOEWqofqEO X0lDkcudrKmIoawzQ9ys0T4DZjOaiIw4fF27HkeRzpUX9QMEArQIBywXEIxeo4dGx5gy g3nQ== 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=3MDcQJHVWj45Hn6tFeUcPjOZQweWzPpUSsMFhpdDeg0=; b=WezL+CRk/VFZc7nknxPQq1zZdswpnsrU8ZS86OQdlfGVzEAAOflYj0pMRmsFZZ9Qj7 N8oQao99wDuS/6FwQWYeqAMQC+WNLNadpsmA88aHGAZWfsaQJWzdzFPT9oKcfZRx6Gd/ hW2OqtoulZnO1i3k0EL7K9XhtfMWoLznPDRo4cDMsmLe7Mq7wSD/9ZA0SHM2Ud6UOEKY aN95ccik7zLMGNiqcyIEJjm8QAscez740NilGMW+i64Y7XD41r4tdZ9p8JpLKpRWQKEY 2PJfrpGsPHjS0KH+q5jCxn7vRGHCOqt4lx/JnUrwSyLHFpjpRL5BBYkDuEUT1UsC8xC9 jilw== X-Gm-Message-State: AOAM530M/z1W0+b4+cFbJ+8rCkKlsKh4BnhqTsTcSXgD/9wCyaDymWzt /1k8dTppqdBm94bcr/XDU+iibKFl4McuqoxZ8rKjqOeNM7f8XkqfkUiI/t/PiD+CIvc3bWFy668 hk4rkqYm1QZ8GdEcP5pKuUmMDLgY/TQGjA8rsjhXr7iKLp3kI441vxIit/jy+u75W3qUAoVmUAJ 1PZjGQ97bB1B/UXjPfOYxL8crA3YgVCYU/IR86WAkc8dtMs7HEZI0PCV0Sjw== X-Google-Smtp-Source: ABdhPJyhtOUg8kjhLG5tHCnwB7YwRuw3vh4bEP6aMlsNk90RsTaoGNvjPCqeI0fJ8sW7evNE0xcR9a30fZMd6CxEt1E= X-Received: by 2002:a17:90b:fc4:: with SMTP id gd4mr504830pjb.129.1600884023494; Wed, 23 Sep 2020 11:00:23 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Pradip Parkale Date: Wed, 23 Sep 2020 23:30:12 +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="0000000000008cb47605affedb08" 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 --0000000000008cb47605affedb08 Content-Type: multipart/alternative; boundary="0000000000008cb47405affedb06" --0000000000008cb47405affedb06 Content-Type: text/plain; charset="UTF-8" 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 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 --0000000000008cb47405affedb06 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi=C2=A0Akshay,

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


=
On Wed, Se= p 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=C2=A0it.

<= div dir=3D"ltr" class=3D"gmail_attr">On Wed, Sep 23, 2020 at 12:14 PM Aksha= y Joshi <akshay.joshi@enterprisedb.com> wrote:
=
Hi Pradip

RESQL tests are failing on EP= AS 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 functio= n and procedure. Attached is the patch to fix this issue.
--
Thanks & Regards,
Pradip= Parkale
Software Engineer | EnterpriseDB Corporation
<= /div>


--
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
--0000000000008cb47405affedb06-- --0000000000008cb47605affedb08 Content-Type: application/octet-stream; name="RM5843_v2.patch" Content-Disposition: attachment; filename="RM5843_v2.patch" Content-Transfer-Encoding: base64 Content-ID: X-Attachment-Id: f_kffoyt8n0 ZGlmZiAtLWdpdCBhL3dlYi9wZ2FkbWluL2Jyb3dzZXIvc2VydmVyX2dyb3Vwcy9zZXJ2ZXJzL2Rh dGFiYXNlcy9zY2hlbWFzL2Z1bmN0aW9ucy90ZW1wbGF0ZXMvZnVuY3Rpb25zL3BnL3NxbC85LjZf cGx1cy9jcmVhdGUuc3FsIGIvd2ViL3BnYWRtaW4vYnJvd3Nlci9zZXJ2ZXJfZ3JvdXBzL3NlcnZl cnMvZGF0YWJhc2VzL3NjaGVtYXMvZnVuY3Rpb25zL3RlbXBsYXRlcy9mdW5jdGlvbnMvcGcvc3Fs LzkuNl9wbHVzL2NyZWF0ZS5zcWwKaW5kZXggYmRmMzZjYjYxLi40ZmFkZmIwNTQgMTAwNjQ0Ci0t LSBhL3dlYi9wZ2FkbWluL2Jyb3dzZXIvc2VydmVyX2dyb3Vwcy9zZXJ2ZXJzL2RhdGFiYXNlcy9z Y2hlbWFzL2Z1bmN0aW9ucy90ZW1wbGF0ZXMvZnVuY3Rpb25zL3BnL3NxbC85LjZfcGx1cy9jcmVh dGUuc3FsCisrKyBiL3dlYi9wZ2FkbWluL2Jyb3dzZXIvc2VydmVyX2dyb3Vwcy9zZXJ2ZXJzL2Rh dGFiYXNlcy9zY2hlbWFzL2Z1bmN0aW9ucy90ZW1wbGF0ZXMvZnVuY3Rpb25zL3BnL3NxbC85LjZf cGx1cy9jcmVhdGUuc3FsCkBAIC0yNSw4ICsyNSw4IEBAIENSRUFURXslIGlmIHF1ZXJ5X3R5cGUg aXMgZGVmaW5lZCAlfXt7JyBPUiBSRVBMQUNFJ319eyUgZW5kaWYgJX0gRlVOQ1RJT04ge3sgY29u CiB7JSBpZiBkYXRhLnByb2lzc3RyaWN0ICV9U1RSSUNUIHslIGVuZGlmICV9CiB7JSBpZiBkYXRh LnByb3NlY2RlZiAlfVNFQ1VSSVRZIERFRklORVIgeyUgZW5kaWYgJX0KIHslIGlmIGRhdGEucHJv aXN3aW5kb3cgJX1XSU5ET1cgeyUgZW5kaWYgJX0KLXslIGlmIGRhdGEucHJvcGFyYWxsZWwgYW5k IChkYXRhLnByb3BhcmFsbGVsID09ICdyJyBvciBkYXRhLnByb3BhcmFsbGVsID09ICdzJykgJX0K LXslIGlmIGRhdGEucHJvcGFyYWxsZWwgPT0gJ3InICV9UEFSQUxMRUwgUkVTVFJJQ1RFRHslIGVs aWYgZGF0YS5wcm9wYXJhbGxlbCA9PSAncycgJX1QQVJBTExFTCBTQUZFeyUgZW5kaWYgJX17JSBl bmRpZiAtJX0KK3slIGlmIGRhdGEucHJvcGFyYWxsZWwgYW5kIChkYXRhLnByb3BhcmFsbGVsID09 ICdyJyBvciBkYXRhLnByb3BhcmFsbGVsID09ICdzJyBvciBkYXRhLnByb3BhcmFsbGVsID09ICd1 JykgJX0KK3slIGlmIGRhdGEucHJvcGFyYWxsZWwgPT0gJ3InICV9IFBBUkFMTEVMIFJFU1RSSUNU RUR7JSBlbGlmIGRhdGEucHJvcGFyYWxsZWwgPT0gJ3MnICV9IFBBUkFMTEVMIFNBRkUgeyUgZWxp ZiBkYXRhLnByb3BhcmFsbGVsID09ICd1JyAlfSBQQVJBTExFTCBVTlNBRkV7JSBlbmRpZiAlfXsl IGVuZGlmIC0lfQogeyUgaWYgZGF0YS5wcm9yb3dzIGFuZCAoZGF0YS5wcm9yb3dzIHwgaW50KSA+ IDAgJX0KIAogICAgIFJPV1Mge3tkYXRhLnByb3Jvd3N9fXslIGVuZGlmIC0lfXslIGlmIGRhdGEu dmFyaWFibGVzICV9eyUgZm9yIHYgaW4gZGF0YS52YXJpYWJsZXMgJX0KZGlmZiAtLWdpdCBhL3dl Yi9wZ2FkbWluL2Jyb3dzZXIvc2VydmVyX2dyb3Vwcy9zZXJ2ZXJzL2RhdGFiYXNlcy9zY2hlbWFz L2Z1bmN0aW9ucy90ZW1wbGF0ZXMvZnVuY3Rpb25zL3BnL3NxbC85LjZfcGx1cy9wcm9wZXJ0aWVz LnNxbCBiL3dlYi9wZ2FkbWluL2Jyb3dzZXIvc2VydmVyX2dyb3Vwcy9zZXJ2ZXJzL2RhdGFiYXNl cy9zY2hlbWFzL2Z1bmN0aW9ucy90ZW1wbGF0ZXMvZnVuY3Rpb25zL3BnL3NxbC85LjZfcGx1cy9w cm9wZXJ0aWVzLnNxbApuZXcgZmlsZSBtb2RlIDEwMDY0NAppbmRleCAwMDAwMDAwMDAuLjQ4OWI2 ZWFkNgotLS0gL2Rldi9udWxsCisrKyBiL3dlYi9wZ2FkbWluL2Jyb3dzZXIvc2VydmVyX2dyb3Vw cy9zZXJ2ZXJzL2RhdGFiYXNlcy9zY2hlbWFzL2Z1bmN0aW9ucy90ZW1wbGF0ZXMvZnVuY3Rpb25z L3BnL3NxbC85LjZfcGx1cy9wcm9wZXJ0aWVzLnNxbApAQCAtMCwwICsxLDM1IEBACitTRUxFQ1QK KyAgICBwci5vaWQsIHByLnhtaW4sIHByLnByb2lzd2luZG93LCBwci5wcm9zcmMsIHByLnByb3Ny YyBBUyBwcm9zcmNfYywKKyAgICBwci5wcm9uYW1lc3BhY2UsIHByLnByb2xhbmcsIHByLnByb2Nv c3QsIHByLnByb3Jvd3MsCisgICAgcHIucHJvc2VjZGVmLCBwci5wcm9sZWFrcHJvb2YsIHByLnBy b2lzc3RyaWN0LCBwci5wcm9yZXRzZXQsIHByLnByb3ZvbGF0aWxlLCBwci5wcm9wYXJhbGxlbCwK KyAgICBwci5wcm9uYXJncywgcHIucHJvcmV0dHlwZSwgcHIucHJvYWxsYXJndHlwZXMsIHByLnBy b2FyZ21vZGVzLCBwci5wcm9iaW4sIHByLnByb2FjbCwKKyAgICBwci5wcm9uYW1lLCBwci5wcm9u YW1lIEFTIG5hbWUsIHBnX2dldF9mdW5jdGlvbl9yZXN1bHQocHIub2lkKSBBUyBwcm9yZXR0eXBl bmFtZSwKKyAgICB0eXBucy5uc3BuYW1lIEFTIHR5cG5zcCwgbGFubmFtZSwgcHJvYXJnbmFtZXMs IG9pZHZlY3RvcnR5cGVzKHByb2FyZ3R5cGVzKSBBUyBwcm9hcmd0eXBlbmFtZXMsCisgICAgcGdf Z2V0X2V4cHIocHJvYXJnZGVmYXVsdHMsICdwZ19jYXRhbG9nLnBnX2NsYXNzJzo6cmVnY2xhc3Mp IEFTIHByb2FyZ2RlZmF1bHR2YWxzLAorICAgIHByLnByb25hcmdkZWZhdWx0cywgcHJvY29uZmln LCBwZ19nZXRfdXNlcmJ5aWQocHJvb3duZXIpIEFTIGZ1bmNvd25lciwgZGVzY3JpcHRpb24sCisg ICAgKFNFTEVDVAorICAgICAgICBhcnJheV9hZ2cocHJvdmlkZXIgfHwgJz0nIHx8IGxhYmVsKQor ICAgIEZST00KKyAgICAgICAgcGdfc2VjbGFiZWwgc2wxCisgICAgV0hFUkUKKyAgICAgICAgc2wx Lm9iam9pZD1wci5vaWQpIEFTIHNlY2xhYmVscworRlJPTQorICAgIHBnX3Byb2MgcHIKK0pPSU4K KyAgICBwZ190eXBlIHR5cCBPTiB0eXAub2lkPXByb3JldHR5cGUKK0pPSU4KKyAgICBwZ19uYW1l c3BhY2UgdHlwbnMgT04gdHlwbnMub2lkPXR5cC50eXBuYW1lc3BhY2UKK0pPSU4KKyAgICBwZ19s YW5ndWFnZSBsbmcgT04gbG5nLm9pZD1wcm9sYW5nCitMRUZUIE9VVEVSIEpPSU4KKyAgICBwZ19k ZXNjcmlwdGlvbiBkZXMgT04gKGRlcy5vYmpvaWQ9cHIub2lkIEFORCBkZXMuY2xhc3NvaWQ9J3Bn X3Byb2MnOjpyZWdjbGFzcyBhbmQgZGVzLm9ianN1YmlkID0gMCkKK1dIRVJFCisgICAgcHJvaXNh Z2cgPSBGQUxTRQorICAgIEFORCB0eXBuYW1lIE5PVCBJTiAoJ3RyaWdnZXInLCAnZXZlbnRfdHJp Z2dlcicpCit7JSBpZiBmbmlkICV9CisgICAgQU5EIHByLm9pZCA9IHt7Zm5pZH19OjpvaWQKK3sl IGVsc2UgJX0KKyAgICBBTkQgcHJvbmFtZXNwYWNlID0ge3tzY2lkfX06Om9pZAoreyUgZW5kaWYg JX0KK09SREVSIEJZCisgICAgcHJvbmFtZTsK --0000000000008cb47605affedb08--