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 1nZ83v-0000yJ-FX for pgadmin-hackers@arkaria.postgresql.org; Tue, 29 Mar 2022 09:22:51 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nZ83t-000134-0X for pgadmin-hackers@arkaria.postgresql.org; Tue, 29 Mar 2022 09:22:49 +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 1nZ83s-00012v-D5 for pgadmin-hackers@lists.postgresql.org; Tue, 29 Mar 2022 09:22:48 +0000 Received: from mail-vs1-xe2b.google.com ([2607:f8b0:4864:20::e2b]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1nZ83m-0004eu-J1 for pgadmin-hackers@postgresql.org; Tue, 29 Mar 2022 09:22:47 +0000 Received: by mail-vs1-xe2b.google.com with SMTP id i10so4830013vsr.6 for ; Tue, 29 Mar 2022 02:22:41 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=enterprisedb.com; s=google; h=mime-version:references:in-reply-to:from:date:message-id:subject:to; bh=0MzFX4IjT6Ixfv2+Sz8cjwVbjQ5KHeX4i+MsIqU2w24=; b=a4YdL8s5U5NUuzPer11SKtCJY2n9cfgD+GcNaxv0Sn/SJOw8LoaSd3pwITVguCaPdO P8zNAxlfAMuwvABSf1uBSz8PpCfabOOe+9rgJck9/4bSulVwo0xD0tpTZx0KcDVZNUTo 8phNn4qothsi/EPNSSD8VvVBZNVclGDQkNzVsdDrQs8uvVoQHPeYc2sYdjBe1Gdyrxpt B+/6ITjjoiAzB4ycmEG3w11NE8XpS1Cth6g0XFZ1V6QmsRaY1LA0zBkcvaMzfteFl04R Xjiz6jPFbl5AEwNKfemcRxwTU+A9tuAsXgoxSQhk7vyGiaBr2S8eBC9mtgKjni28rRTX ofyg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:mime-version:references:in-reply-to:from:date :message-id:subject:to; bh=0MzFX4IjT6Ixfv2+Sz8cjwVbjQ5KHeX4i+MsIqU2w24=; b=dJnot/eJANYCZmOy1VRSIbt3khMWB3Ywx+uv3PQ3oXaEWikAMCdwJOe+tDRxCu5V5V ZaofJEVSjD1CUaa97PafR0Iv4SzRrGRlFK39JNMiJqgdzEq42/ZjKN1pgyxdDedJ087P sYqzqsYG20TSmRAvz39tTiaQEozvYO0+DW4fR/Fnz0Si+rvjlcvioDIB9yhDOPkzKikU TYLk/jbrtTQ+jofhHOgIxVBKc1r21rqnVE7/FtuvaLaf+RaTyvA6ke8ao8n6vsXGvkax REPRt7IBDJlMUhE2C4oO9jb+ncAf8ZeWLAPCft4LslkVobcoUdeanrM2o7VWsg0Ys9vE WklA== X-Gm-Message-State: AOAM530pC4Ul6aNSgJUdP1SA20h38ZuR1+zC9Q/o4kTnmFYZ95g9jzaq hEVaLwle7i453AA2+rdcebJRqUdu045YMSUeF9TTuj37XYfXUenJJieh3Ue4nvaRAG8bEU+fkdb dK4F2X9e2IQwJaO69Hi6MD7yCp4PnItKjV0JL1owgeiUC+x/7AMBW61lPsD7fZb7a5qrKqsZOKq pjxn/rHW+8ZJGFTvOV0zZIcFO7x1oBtdqA+BwqDu7SPMW82KLOOOeFP11XQsPCTNc= X-Google-Smtp-Source: ABdhPJyFlU5QBPsDNNBs9p5NpA2u9L9rqr0O2or5t2impmtcIH4DTL4BSD+fH+T8T16KuohxY8bTdz5aQMupTP9Bv6I= X-Received: by 2002:a05:6102:20a:b0:325:2ca5:150 with SMTP id z10-20020a056102020a00b003252ca50150mr15170961vsp.82.1648545759627; Tue, 29 Mar 2022 02:22:39 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Yogesh Mahajan Date: Tue, 29 Mar 2022 14:52:03 +0530 Message-ID: Subject: Re: [Patch] Bug #4256 - ALTER DEFAULT PRIVILEGES FOR ROLE some_role REVOKE EXECUTE ON FUNCTIONS FROM PUBLIC: To: pgadmin-hackers Content-Type: multipart/mixed; boundary="00000000000067193c05db57f8fc" 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 --00000000000067193c05db57f8fc Content-Type: multipart/alternative; boundary="00000000000067193a05db57f8fa" --00000000000067193a05db57f8fa Content-Type: text/plain; charset="UTF-8" Hello, Please find the attached patch which fixes resql test failures due to the above patch. Thanks, Yogesh Mahajan EnterpriseDB On Mon, Mar 28, 2022 at 5:37 PM Akshay Joshi wrote: > Thanks, the patch applied > > On Mon, Mar 28, 2022 at 4:43 PM Yogesh Mahajan < > yogesh.mahajan@enterprisedb.com> wrote: > >> Hello Team, >> >> Please find the updated patch which fixes sql revoke statements shown for >> databases. >> >> >> Thanks, >> Yogesh Mahajan >> EnterpriseDB >> >> >> On Tue, Mar 1, 2022 at 12:50 PM Aditya Toshniwal < >> aditya.toshniwal@enterprisedb.com> wrote: >> >>> Hi Yogesh, >>> >>> The original bug is not fixed with the patch. You might have fixed the >>> related ones. >>> >>> On Mon, Feb 28, 2022 at 6:24 PM Akshay Joshi < >>> akshay.joshi@enterprisedb.com> wrote: >>> >>>> Hi Aditya >>>> >>>> Can you please review it? >>>> >>>> On Mon, Feb 28, 2022 at 6:03 PM Yogesh Mahajan < >>>> yogesh.mahajan@enterprisedb.com> wrote: >>>> >>>>> Hi Team, >>>>> >>>>> Please find a patch which fixes sql for alter default privileges. >>>>> >>>>> Thanks, >>>>> Yogesh Mahajan >>>>> EnterpriseDB >>>>> >>>> >>>> >>>> -- >>>> *Thanks & Regards* >>>> *Akshay Joshi* >>>> *pgAdmin Hacker | Principal Software Architect* >>>> *EDB Postgres * >>>> >>>> *Mobile: +91 976-788-8246* >>>> >>> >>> >>> -- >>> Thanks, >>> Aditya Toshniwal >>> pgAdmin Hacker | Software Architect | *edbpostgres.com* >>> >>> "Don't Complain about Heat, Plant a TREE" >>> >> > > -- > *Thanks & Regards* > *Akshay Joshi* > *pgAdmin Hacker | Principal Software Architect* > *EDB Postgres * > > *Mobile: +91 976-788-8246* > --00000000000067193a05db57f8fa Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hello,

Pl= ease find the attached patch which fixes=C2=A0resql test failures due to th= e above patch.

Thanks,
Yogesh Mahajan
Ent= erpriseDB


On Mon, Mar 28, 2022 at 5:3= 7 PM Akshay Joshi <aksh= ay.joshi@enterprisedb.com> wrote:
Thanks, the patch applied

On Mon, Mar 28, 2022 at 4:43 P= M Yogesh Mahajan <yogesh.mahajan@enterprisedb.com> wrote:
Hello Team,

Please find the updated patch which=C2=A0f= ixes sql revoke statements shown for databases.

<= div class=3D"gmail_default" style=3D"font-family:verdana,sans-serif;font-si= ze:small">
Thanks,
Yo= gesh Mahajan
Enterprise= DB


On Tue, Mar 1, 2022 at 12:50 PM Ad= itya Toshniwal <aditya.toshniwal@enterprisedb.com> wrote:
Hi Yogesh,

The original bug is not fixed wi= th the patch. You might have fixed the related ones.

On Mon, Feb 28, 2= 022 at 6:24 PM Akshay Joshi <akshay.joshi@enterprisedb.com> wrote:
Hi Aditya=C2=A0

Can you please review it?

On Mon, Feb 28, 2022 at 6:03 PM Yoge= sh Mahajan <yogesh.mahajan@enterprisedb.com> wrote:
Hi Team,

Please find a patch which fixes sql for alter default privileges.

Thanks,
Yogesh Mahajan
Enterpr= iseDB


--
Thank= s & Regards
Akshay Joshi
pgAdmin Hacker | Principal Softw= are Architect
EDB Po= stgres
Mobile: +91 976-788-8246



--
Thanks,
Aditya Toshniwal=
pgAdmin Hacker=C2=A0| Software Architect=C2=A0| = edbpostgres.com
=
&q= uot;Don't Complain about Heat, Plant a TREE"


--
Thank= s & Regards
Akshay Joshi
pgAdmin Hacker | Principal Softw= are Architect
EDB Po= stgres
Mobile: +91 976-788-8246

--00000000000067193a05db57f8fa-- --00000000000067193c05db57f8fc Content-Type: application/octet-stream; name="RM_4256_v3.patch" Content-Disposition: attachment; filename="RM_4256_v3.patch" Content-Transfer-Encoding: base64 Content-ID: X-Attachment-Id: f_l1bxjuo20 ZGlmZiAtLWdpdCBhL3dlYi9wZ2FkbWluL2Jyb3dzZXIvc2VydmVyX2dyb3Vwcy9zZXJ2ZXJzL2Rh dGFiYXNlcy90ZW1wbGF0ZXMvZGF0YWJhc2VzL3NxbC85LjNfcGx1cy9kZWZhY2wuc3FsIGIvd2Vi L3BnYWRtaW4vYnJvd3Nlci9zZXJ2ZXJfZ3JvdXBzL3NlcnZlcnMvZGF0YWJhc2VzL3RlbXBsYXRl cy9kYXRhYmFzZXMvc3FsLzkuM19wbHVzL2RlZmFjbC5zcWwKaW5kZXggZTlmOWVhYzg5Li4yNTI3 YTVkMzYgMTAwNjQ0Ci0tLSBhL3dlYi9wZ2FkbWluL2Jyb3dzZXIvc2VydmVyX2dyb3Vwcy9zZXJ2 ZXJzL2RhdGFiYXNlcy90ZW1wbGF0ZXMvZGF0YWJhc2VzL3NxbC85LjNfcGx1cy9kZWZhY2wuc3Fs CisrKyBiL3dlYi9wZ2FkbWluL2Jyb3dzZXIvc2VydmVyX2dyb3Vwcy9zZXJ2ZXJzL2RhdGFiYXNl cy90ZW1wbGF0ZXMvZGF0YWJhc2VzL3NxbC85LjNfcGx1cy9kZWZhY2wuc3FsCkBAIC0zNiw3ICsz Niw3IEBAIEdST1VQIEJZIGcucm9sbmFtZSwgZ3Qucm9sbmFtZSwgYS5kZWZ0eXBlCiBPUkRFUiBC WSBhLmRlZnR5cGUKIAkpCiB7JSBlbHNlICV9Ci0KK1NFTEVDVCAqIGZyb20gKAogKFNFTEVDVAog ICAgIENBU0UgKGUuZGVmdHlwZSkKICAgICBXSEVOICdyJyBUSEVOICdkZWZ0YmxhY2wnCkBAIC0x NTcsNSArMTU3LDUgQEAgRlJPTSgKIExFRlQgSk9JTiBwZ19jYXRhbG9nLnBnX3JvbGVzIGcgT04g KGUuZ3JhbnRvciA9IGcub2lkKQogICAgTEVGVCBKT0lOIHBnX2NhdGFsb2cucGdfcm9sZXMgZ3Qg T04gKGUuZ3JhbnRlZSA9IGd0Lm9pZCkKIEdST1VQIEJZIGcucm9sbmFtZSwgZ3Qucm9sbmFtZSwg ZS5kZWZ0eXBlCi1PUkRFUiBCWSBlLmRlZnR5cGUpCitPUkRFUiBCWSBlLmRlZnR5cGUpKSBmIG9y ZGVyIGJ5IGYuYWNsdHlwZSBERVNDCiB7JSBlbmRpZiAlfQpkaWZmIC0tZ2l0IGEvd2ViL3BnYWRt aW4vYnJvd3Nlci9zZXJ2ZXJfZ3JvdXBzL3NlcnZlcnMvZGF0YWJhc2VzL3Rlc3RzL3BnL2RlZmF1 bHQvYWx0ZXJfZGVmYXVsdF9kYl9wcml2aWxlZ2VzX3NlcXVlbmNlcy5zcWwgYi93ZWIvcGdhZG1p bi9icm93c2VyL3NlcnZlcl9ncm91cHMvc2VydmVycy9kYXRhYmFzZXMvdGVzdHMvcGcvZGVmYXVs dC9hbHRlcl9kZWZhdWx0X2RiX3ByaXZpbGVnZXNfc2VxdWVuY2VzLnNxbAppbmRleCA0OTQ0MzI2 MTAuLjNmYWMyOTNjZiAxMDA2NDQKLS0tIGEvd2ViL3BnYWRtaW4vYnJvd3Nlci9zZXJ2ZXJfZ3Jv dXBzL3NlcnZlcnMvZGF0YWJhc2VzL3Rlc3RzL3BnL2RlZmF1bHQvYWx0ZXJfZGVmYXVsdF9kYl9w cml2aWxlZ2VzX3NlcXVlbmNlcy5zcWwKKysrIGIvd2ViL3BnYWRtaW4vYnJvd3Nlci9zZXJ2ZXJf Z3JvdXBzL3NlcnZlcnMvZGF0YWJhc2VzL3Rlc3RzL3BnL2RlZmF1bHQvYWx0ZXJfZGVmYXVsdF9k Yl9wcml2aWxlZ2VzX3NlcXVlbmNlcy5zcWwKQEAgLTEzLDkgKzEzLDkgQEAgQ1JFQVRFIERBVEFC QVNFIDxURVNUX0RCX05BTUU+CiAKIEFMVEVSIERFRkFVTFQgUFJJVklMRUdFUyBGT1IgUk9MRSBw b3N0Z3JlcyBSRVZPS0UgQUxMIE9OIFRBQkxFUyBGUk9NIHBvc3RncmVzOwogCitBTFRFUiBERUZB VUxUIFBSSVZJTEVHRVMgRk9SIFJPTEUgcG9zdGdyZXMgUkVWT0tFIEFMTCBPTiBTRVFVRU5DRVMg RlJPTSBwb3N0Z3JlczsKKwogQUxURVIgREVGQVVMVCBQUklWSUxFR0VTIEZPUiBST0xFIHBvc3Rn cmVzCiBHUkFOVCBTRUxFQ1QsIFVTQUdFIE9OIFNFUVVFTkNFUyBUTyBQVUJMSUM7CiAKLUFMVEVS IERFRkFVTFQgUFJJVklMRUdFUyBGT1IgUk9MRSBwb3N0Z3JlcyBSRVZPS0UgQUxMIE9OIFNFUVVF TkNFUyBGUk9NIHBvc3RncmVzOwotCiBBTFRFUiBERUZBVUxUIFBSSVZJTEVHRVMgRk9SIFJPTEUg cG9zdGdyZXMgUkVWT0tFIEVYRUNVVEUgT04gRlVOQ1RJT05TIEZST00gUFVCTElDOwpkaWZmIC0t Z2l0IGEvd2ViL3BnYWRtaW4vYnJvd3Nlci9zZXJ2ZXJfZ3JvdXBzL3NlcnZlcnMvZGF0YWJhc2Vz L3Rlc3RzL3BnL2RlZmF1bHQvYWx0ZXJfZGVmYXVsdF9kYl9wcml2aWxlZ2VzX3R5cGVzLnNxbCBi L3dlYi9wZ2FkbWluL2Jyb3dzZXIvc2VydmVyX2dyb3Vwcy9zZXJ2ZXJzL2RhdGFiYXNlcy90ZXN0 cy9wZy9kZWZhdWx0L2FsdGVyX2RlZmF1bHRfZGJfcHJpdmlsZWdlc190eXBlcy5zcWwKaW5kZXgg OTA1NDE2MjVkLi5mM2RiZDA1MjMgMTAwNjQ0Ci0tLSBhL3dlYi9wZ2FkbWluL2Jyb3dzZXIvc2Vy dmVyX2dyb3Vwcy9zZXJ2ZXJzL2RhdGFiYXNlcy90ZXN0cy9wZy9kZWZhdWx0L2FsdGVyX2RlZmF1 bHRfZGJfcHJpdmlsZWdlc190eXBlcy5zcWwKKysrIGIvd2ViL3BnYWRtaW4vYnJvd3Nlci9zZXJ2 ZXJfZ3JvdXBzL3NlcnZlcnMvZGF0YWJhc2VzL3Rlc3RzL3BnL2RlZmF1bHQvYWx0ZXJfZGVmYXVs dF9kYl9wcml2aWxlZ2VzX3R5cGVzLnNxbApAQCAtMTMsMTEgKzEzLDExIEBAIENSRUFURSBEQVRB QkFTRSA8VEVTVF9EQl9OQU1FPgogCiBBTFRFUiBERUZBVUxUIFBSSVZJTEVHRVMgRk9SIFJPTEUg cG9zdGdyZXMgUkVWT0tFIEFMTCBPTiBUQUJMRVMgRlJPTSBwb3N0Z3JlczsKIAorQUxURVIgREVG QVVMVCBQUklWSUxFR0VTIEZPUiBST0xFIHBvc3RncmVzIFJFVk9LRSBBTEwgT04gU0VRVUVOQ0VT IEZST00gcG9zdGdyZXM7CisKIEFMVEVSIERFRkFVTFQgUFJJVklMRUdFUyBGT1IgUk9MRSBwb3N0 Z3JlcwogR1JBTlQgU0VMRUNULCBVU0FHRSBPTiBTRVFVRU5DRVMgVE8gUFVCTElDOwogCi1BTFRF UiBERUZBVUxUIFBSSVZJTEVHRVMgRk9SIFJPTEUgcG9zdGdyZXMgUkVWT0tFIEFMTCBPTiBTRVFV RU5DRVMgRlJPTSBwb3N0Z3JlczsKLQogQUxURVIgREVGQVVMVCBQUklWSUxFR0VTIEZPUiBST0xF IHBvc3RncmVzIFJFVk9LRSBFWEVDVVRFIE9OIEZVTkNUSU9OUyBGUk9NIFBVQkxJQzsKIAogQUxU RVIgREVGQVVMVCBQUklWSUxFR0VTIEZPUiBST0xFIHBvc3RncmVzIFJFVk9LRSBVU0FHRSBPTiBU WVBFUyBGUk9NIFBVQkxJQzsKZGlmZiAtLWdpdCBhL3dlYi9wZ2FkbWluL2Jyb3dzZXIvc2VydmVy X2dyb3Vwcy9zZXJ2ZXJzL2RhdGFiYXNlcy90ZXN0cy9wcGFzL2RlZmF1bHQvYWx0ZXJfZGVmYXVs dF9kYl9wcml2aWxlZ2VzX3RhYmxlcy5zcWwgYi93ZWIvcGdhZG1pbi9icm93c2VyL3NlcnZlcl9n cm91cHMvc2VydmVycy9kYXRhYmFzZXMvdGVzdHMvcHBhcy9kZWZhdWx0L2FsdGVyX2RlZmF1bHRf ZGJfcHJpdmlsZWdlc190YWJsZXMuc3FsCmluZGV4IDg2ZTFiN2U4Yi4uZWMxMjE3MWYzIDEwMDY0 NAotLS0gYS93ZWIvcGdhZG1pbi9icm93c2VyL3NlcnZlcl9ncm91cHMvc2VydmVycy9kYXRhYmFz ZXMvdGVzdHMvcHBhcy9kZWZhdWx0L2FsdGVyX2RlZmF1bHRfZGJfcHJpdmlsZWdlc190YWJsZXMu c3FsCisrKyBiL3dlYi9wZ2FkbWluL2Jyb3dzZXIvc2VydmVyX2dyb3Vwcy9zZXJ2ZXJzL2RhdGFi YXNlcy90ZXN0cy9wcGFzL2RlZmF1bHQvYWx0ZXJfZGVmYXVsdF9kYl9wcml2aWxlZ2VzX3RhYmxl cy5zcWwKQEAgLTExLDkgKzExLDkgQEAgQ1JFQVRFIERBVEFCQVNFIDxURVNUX0RCX05BTUU+CiAg ICAgVEFCTEVTUEFDRSA9IHBnX2RlZmF1bHQKICAgICBDT05ORUNUSU9OIExJTUlUID0gLTE7CiAK K0FMVEVSIERFRkFVTFQgUFJJVklMRUdFUyBGT1IgUk9MRSBlbnRlcnByaXNlZGIgUkVWT0tFIEFM TCBPTiBUQUJMRVMgRlJPTSBlbnRlcnByaXNlZGI7CisKIEFMVEVSIERFRkFVTFQgUFJJVklMRUdF UyBGT1IgUk9MRSBlbnRlcnByaXNlZGIKIEdSQU5UIFNFTEVDVCBPTiBUQUJMRVMgVE8gUFVCTElD OwogCi1BTFRFUiBERUZBVUxUIFBSSVZJTEVHRVMgRk9SIFJPTEUgZW50ZXJwcmlzZWRiIFJFVk9L RSBBTEwgT04gVEFCTEVTIEZST00gZW50ZXJwcmlzZWRiOwotCiBBTFRFUiBERUZBVUxUIFBSSVZJ TEVHRVMgRk9SIFJPTEUgZW50ZXJwcmlzZWRiIFJFVk9LRSBFWEVDVVRFIE9OIEZVTkNUSU9OUyBG Uk9NIFBVQkxJQzsK --00000000000067193c05db57f8fc--