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 1mY4mL-0007wC-4t for pgadmin-hackers@arkaria.postgresql.org; Wed, 06 Oct 2021 11:08:05 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mY4mK-00059E-3Y for pgadmin-hackers@arkaria.postgresql.org; Wed, 06 Oct 2021 11:08:04 +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 1mY4mJ-000596-Hg for pgadmin-hackers@lists.postgresql.org; Wed, 06 Oct 2021 11:08:03 +0000 Received: from mail-vs1-xe30.google.com ([2607:f8b0:4864:20::e30]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1mY4mF-0005LM-AN for pgadmin-hackers@postgresql.org; Wed, 06 Oct 2021 11:08:02 +0000 Received: by mail-vs1-xe30.google.com with SMTP id 66so2422827vsd.11 for ; Wed, 06 Oct 2021 04:07:58 -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 :cc; bh=JULa73Filk8y+XStRo5qb3Oa0hCxjLjTL6ySswmv8FM=; b=GKbersn3+XSVcrmnvEhM+6jOfUCn0jWFQJ3IS5lTqMzlToC+bf1AxhTPO0T+sjMR1H 8UOeDEXAX+Gwsnw860NkldSnGRo8hsj3tFFfHwPBWAc1tNfN/lXrr3Eh2Qdvkr+B8lpV FvKd+gHy8srcvai9HuO/1y/JxPraqL7iUKGrtdlGHygQrvCU++8JFZj7GrvY6GafzXyK VhVZZi+eXXGYzr0Ue7NjZOhv18w3iijx+b0FnsC/y5zUlDmWAPbdlHDsSv6DFLtSPpzA t9xlbSke2Ie1xWBXAUKyQaj8gw4T3pT29Q16rvGqSZsU6HcjSxcof0NEYs90D7+KzGn/ ZLdw== 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:cc; bh=JULa73Filk8y+XStRo5qb3Oa0hCxjLjTL6ySswmv8FM=; b=GrJsZDnFI1NRgaQvUwfjkjNb0zoa5v1Z5MKVmD3gnIVQEu+RDPIy2BPiivEKcYY6tL H94a8klxkfAyvMgCTuAmqbKP2+pzPoNBFZtR7i6M9Kvlh/p0uE8pyRv/yO6osXtbOVJx EVscmz/5CnqOE/nDxlNwQlJT1EC8oaFsqe4cyotxJwwJxRDrgyCqzP2MS1GtaCL0FmRi MusK0tQOZOxZnDIkL6xABeWSqgV8PRXYIFM5bEOtB76I9cp24ksHwApdUZLeI4SdSmHX kCG2v4kZ9lPYQnHCZ5FL0reg6LBI11i82P3ZHnWKeABkfo6OmVK2tZRSFACEnrzFdWtv Bp1w== X-Gm-Message-State: AOAM533Z+/dWza8/XDPS/gX0ajcguAo6FgiXp6MYjaJFCFrA88OBmbS0 PDPOUrTPrn2FJUOWbHQHSsbMYMxz8soGZxCSpTVfNPl/6duCsHadH+PD/Clni1QDK0C7xoRg4Mi sQJ8Lu6FdF/XTTm+ISSF15p7QNlIrmMhMpTmwmH5aV+OPrTzJB6mxKcBGYhjDb3LI6tBpvhQQfo 7UijVkQCyAnXHtNrcecGsFlkT+73CcuMNPCHbSacYEeeIokQA0MaW3cX58xQ== X-Google-Smtp-Source: ABdhPJzprYYz2OnlR4SJstqOW70IKllEnhhMvufg9qHuE2mKLqez6ffzAIhd3SCKwyJtOltAC2OxuefVZIIxYiO8/eo= X-Received: by 2002:a05:6102:1147:: with SMTP id j7mr22827336vsg.45.1633518476733; Wed, 06 Oct 2021 04:07:56 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Aditya Toshniwal Date: Wed, 6 Oct 2021 16:37:20 +0530 Message-ID: Subject: Re: [pgAdmin][patch] Partition node related fixes To: Akshay Joshi Cc: pgadmin-hackers Content-Type: multipart/mixed; boundary="0000000000008a63e505cdad2852" 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 --0000000000008a63e505cdad2852 Content-Type: multipart/alternative; boundary="0000000000008a63e405cdad2850" --0000000000008a63e405cdad2850 Content-Type: text/plain; charset="UTF-8" Hi Hackers, The nodes index, RLS policy, rules, triggers are failing to save for partitions. Please review the attached patch to fix the issue. On Wed, Oct 6, 2021 at 2:54 PM Akshay Joshi wrote: > Thanks, the patch applied. > > On Wed, Oct 6, 2021 at 12:25 PM Aditya Toshniwal < > aditya.toshniwal@enterprisedb.com> wrote: > >> Hi Hackers, >> >> Please review the attached patch which fixes: >> 1. Unable to create trigger for partition table. Fixes #6867. >> 2. Unable to create index, RLS policy, rules, triggers for partition. >> Fixes #6868. >> >> -- >> 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* > -- Thanks, Aditya Toshniwal pgAdmin Hacker | Software Architect | *edbpostgres.com* "Don't Complain about Heat, Plant a TREE" --0000000000008a63e405cdad2850 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi Hackers,

The nodes index, RLS policy, rules, triggers a= re failing to save for partitions. Please review the attached patch to fix = the issue.

On Wed, Oct 6, 2021 at 2:54 PM Akshay Joshi <akshay.joshi@enterprisedb.com>= wrote:
Thanks, the patch applied.

On Wed, Oct 6, 2021 at 12:25 PM Aditya T= oshniwal <aditya.toshniwal@enterprisedb.com> wrote:
Hi Hackers,

Please rev= iew the attached patch which fixes:
1. Unable to create trigger for part= ition table. Fixes #6867.
2. Unable to create index, RLS policy, rules, = triggers for partition. Fixes #6868.

--
<= div dir=3D"ltr">
Thanks,
Aditya T= oshniwal
pgAdmin Hacker=C2=A0| Software Architect<= /font>=C2=A0| edbpostgres.com<= /a>


--


--
Thanks,
Aditya Toshniwal
pgAdmin Hacker=C2=A0| Software A= rchitect=C2=A0| edbpostgres.com
"Don't Complain about Heat, Plant a TREE&qu= ot;
--0000000000008a63e405cdad2850-- --0000000000008a63e505cdad2852 Content-Type: application/octet-stream; name="RM6868.part2.patch" Content-Disposition: attachment; filename="RM6868.part2.patch" Content-Transfer-Encoding: base64 Content-ID: X-Attachment-Id: f_kufep9lo0 ZGlmZiAtLWdpdCBhL3dlYi9wZ2FkbWluL2Jyb3dzZXIvc2VydmVyX2dyb3Vwcy9zZXJ2ZXJzL2Rh dGFiYXNlcy9zY2hlbWFzL3RhYmxlcy9pbmRleGVzL3N0YXRpYy9qcy9pbmRleC5qcyBiL3dlYi9w Z2FkbWluL2Jyb3dzZXIvc2VydmVyX2dyb3Vwcy9zZXJ2ZXJzL2RhdGFiYXNlcy9zY2hlbWFzL3Rh Ymxlcy9pbmRleGVzL3N0YXRpYy9qcy9pbmRleC5qcwppbmRleCAyZDEzNDgzMDUuLjkxNzY2NjE2 MSAxMDA2NDQKLS0tIGEvd2ViL3BnYWRtaW4vYnJvd3Nlci9zZXJ2ZXJfZ3JvdXBzL3NlcnZlcnMv ZGF0YWJhc2VzL3NjaGVtYXMvdGFibGVzL2luZGV4ZXMvc3RhdGljL2pzL2luZGV4LmpzCisrKyBi L3dlYi9wZ2FkbWluL2Jyb3dzZXIvc2VydmVyX2dyb3Vwcy9zZXJ2ZXJzL2RhdGFiYXNlcy9zY2hl bWFzL3RhYmxlcy9pbmRleGVzL3N0YXRpYy9qcy9pbmRleC5qcwpAQCAtMTU4LDcgKzE1OCw3IEBA IGRlZmluZSgncGdhZG1pbi5ub2RlLmluZGV4JywgWwogICAgICAgICAgICAgdGFibGVzcGFjZUxp c3Q6ICgpPT5nZXROb2RlTGlzdEJ5TmFtZSgndGFibGVzcGFjZScsIHRyZWVOb2RlSW5mbywgaXRl bU5vZGVEYXRhLCB7fSwgKG0pPT57CiAgICAgICAgICAgICAgIHJldHVybiAobS5sYWJlbCAhPSAn cGdfZ2xvYmFsJyk7CiAgICAgICAgICAgICB9KSwKLSAgICAgICAgICAgIGFtbmFtZUxpc3QgOiAo KT0+Z2V0Tm9kZUFqYXhPcHRpb25zKCdnZXRfYWNjZXNzX21ldGhvZHMnLCBub2RlT2JqLCB0cmVl Tm9kZUluZm8sIGl0ZW1Ob2RlRGF0YSksCisgICAgICAgICAgICBhbW5hbWVMaXN0IDogKCk9Pmdl dE5vZGVBamF4T3B0aW9ucygnZ2V0X2FjY2Vzc19tZXRob2RzJywgbm9kZU9iaiwgdHJlZU5vZGVJ bmZvLCBpdGVtTm9kZURhdGEsIHtqdW1wQWZ0ZXJOb2RlOiAnc2NoZW1hJ30pLAogICAgICAgICAg ICAgY29sdW1uTGlzdDogKCk9PmdldE5vZGVMaXN0QnlOYW1lKCdjb2x1bW4nLCB0cmVlTm9kZUlu Zm8sIGl0ZW1Ob2RlRGF0YSwge30pLAogICAgICAgICAgIH0sCiAgICAgICAgICAgewpkaWZmIC0t Z2l0IGEvd2ViL3BnYWRtaW4vYnJvd3Nlci9zZXJ2ZXJfZ3JvdXBzL3NlcnZlcnMvZGF0YWJhc2Vz L3NjaGVtYXMvdGFibGVzL2luZGV4ZXMvc3RhdGljL2pzL2luZGV4LnVpLmpzIGIvd2ViL3BnYWRt aW4vYnJvd3Nlci9zZXJ2ZXJfZ3JvdXBzL3NlcnZlcnMvZGF0YWJhc2VzL3NjaGVtYXMvdGFibGVz L2luZGV4ZXMvc3RhdGljL2pzL2luZGV4LnVpLmpzCmluZGV4IDczZjhlZGEyMi4uNWVhYjFiNjZm IDEwMDY0NAotLS0gYS93ZWIvcGdhZG1pbi9icm93c2VyL3NlcnZlcl9ncm91cHMvc2VydmVycy9k YXRhYmFzZXMvc2NoZW1hcy90YWJsZXMvaW5kZXhlcy9zdGF0aWMvanMvaW5kZXgudWkuanMKKysr IGIvd2ViL3BnYWRtaW4vYnJvd3Nlci9zZXJ2ZXJfZ3JvdXBzL3NlcnZlcnMvZGF0YWJhc2VzL3Nj aGVtYXMvdGFibGVzL2luZGV4ZXMvc3RhdGljL2pzL2luZGV4LnVpLmpzCkBAIC0yNjMsNyArMjYz LDYgQEAgZXhwb3J0IGRlZmF1bHQgY2xhc3MgSW5kZXhTY2hlbWEgZXh0ZW5kcyBCYXNlVUlTY2hl bWEgewogICAgICAgICByZWFkb25seTogZnVuY3Rpb24gKHN0YXRlKSB7CiAgICAgICAgICAgcmV0 dXJuICFpbmRleFNjaGVtYU9iai5pc05ldyhzdGF0ZSk7CiAgICAgICAgIH0sCi0gICAgICAgIHVy bF9qdW1wX2FmdGVyX25vZGU6ICdzY2hlbWEnLAogICAgICAgICBncm91cDogZ2V0dGV4dCgnRGVm aW5pdGlvbicpLAogICAgICAgICB0eXBlOiAoKSA9PiB7CiAgICAgICAgICAgcmV0dXJuIHsKZGlm ZiAtLWdpdCBhL3dlYi9wZ2FkbWluL2Jyb3dzZXIvc3RhdGljL2pzL25vZGVfdmlldy5qc3ggYi93 ZWIvcGdhZG1pbi9icm93c2VyL3N0YXRpYy9qcy9ub2RlX3ZpZXcuanN4CmluZGV4IGZiYjkyMjA1 OC4uZTY3YTUwMGQ4IDEwMDY0NAotLS0gYS93ZWIvcGdhZG1pbi9icm93c2VyL3N0YXRpYy9qcy9u b2RlX3ZpZXcuanN4CisrKyBiL3dlYi9wZ2FkbWluL2Jyb3dzZXIvc3RhdGljL2pzL25vZGVfdmll dy5qc3gKQEAgLTI1LDcgKzI1LDcgQEAgZXhwb3J0IGZ1bmN0aW9uIGdldE5vZGVWaWV3KG5vZGVU eXBlLCB0cmVlTm9kZUluZm8sIGFjdGlvblR5cGUsIGl0ZW1Ob2RlRGF0YSwgZm8KICAgbGV0IHNl cnZlckluZm8gPSB0cmVlTm9kZUluZm8gJiYgKCdzZXJ2ZXInIGluIHRyZWVOb2RlSW5mbykgJiYK ICAgICAgIHBnQWRtaW4uQnJvd3Nlci5zZXJ2ZXJJbmZvICYmIHBnQWRtaW4uQnJvd3Nlci5zZXJ2 ZXJJbmZvW3RyZWVOb2RlSW5mby5zZXJ2ZXIuX2lkXTsKICAgbGV0IGluQ2F0YWxvZyA9IHRyZWVO b2RlSW5mbyAmJiAoJ2NhdGFsb2cnIGluIHRyZWVOb2RlSW5mbyk7Ci0gIGxldCB1cmxCYXNlID0g Z2VuZXJhdGVOb2RlVXJsLmNhbGwobm9kZU9iaiwgdHJlZU5vZGVJbmZvLCBhY3Rpb25UeXBlLCBp dGVtTm9kZURhdGEsIGZhbHNlLCBudWxsKTsKKyAgbGV0IHVybEJhc2UgPSBnZW5lcmF0ZU5vZGVV cmwuY2FsbChub2RlT2JqLCB0cmVlTm9kZUluZm8sIGFjdGlvblR5cGUsIGl0ZW1Ob2RlRGF0YSwg ZmFsc2UsIG5vZGVPYmoudXJsX2p1bXBfYWZ0ZXJfbm9kZSk7CiAgIGNvbnN0IGFwaSA9IGdldEFw aUluc3RhbmNlKCk7CiAgIGNvbnN0IHVybCA9IChpc05ldyk9PnsKICAgICByZXR1cm4gdXJsQmFz ZSArIChpc05ldyA/ICcnIDogaXRlbU5vZGVEYXRhLl9pZCk7Cg== --0000000000008a63e505cdad2852--