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 1mY5dw-0001gr-2w for pgadmin-hackers@arkaria.postgresql.org; Wed, 06 Oct 2021 12:03:28 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mY5dP-00018T-9T for pgadmin-hackers@arkaria.postgresql.org; Wed, 06 Oct 2021 12:02:55 +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 1mY5dO-00018D-7l for pgadmin-hackers@lists.postgresql.org; Wed, 06 Oct 2021 12:02:55 +0000 Received: from mail-vs1-xe2f.google.com ([2607:f8b0:4864:20::e2f]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1mY5dJ-0005lx-7n for pgadmin-hackers@postgresql.org; Wed, 06 Oct 2021 12:02:53 +0000 Received: by mail-vs1-xe2f.google.com with SMTP id p18so2505106vsu.7 for ; Wed, 06 Oct 2021 05:02:48 -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=qdE2Xc7DVt0/Jr3dau1leJ4Mi0yHb9Km+AiZdwtzKaI=; b=E6t7O2Fz1CLYbgo+a31oWhFUCytMu/sCGnea90e+IF4U6XaRbUrOoMLfpurvnjdfDh aAxG1GP3i3hoqVSp3Eugf3tzwaOgiJGM6Zxd5f1TTLBN3akrpW+qRlf+58iplDUtVChi GG9ekc7veEwA/jEEwGZHmXzu0PwwpKVi7YMEEw5JA/ZAecNVp4ABMBI4YS9LpAnSElQ8 JsEM7yh6HAxUzrmtYsUJR4RsvosxCdN79GmOd+Px12cEwTv13B0I9segrC67B0RangCi g2Clf6fLg7sDZWD2tSbW7qjQhMhSP+pIqsijGuKaeHeQ3gBf6lCeNGPlLQMhpsRpqQIn tO9A== 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=qdE2Xc7DVt0/Jr3dau1leJ4Mi0yHb9Km+AiZdwtzKaI=; b=wozN5OS75PtMdmPTNWLC+y2HAn7Id4pEgqaPQyoLzmGdKUoWZZtl5CaCHtk0BNHoCX kRkV37YZMsQJ7MSbiXleNdVbG/R5aZiisPw9pF4ZHNdwjwo0NRIDrl0MjLE3+jW/ihue 1+qyx38u22/96FqdY0h9xJY67X5G6SJ3sbEDXJmSKCmmuXhw5Fb1CUdYV6kF8+Cflkw8 BVolhNmgyQLxQ4sG66vlZX8/rDLMqLxvGKPv6anWlX7Z7QgGdfU4a/BxhS63qMuJ9U+J uA+Uxm9nR/676RtkLZmS0erUolPp0d699mi6AAiSjq5jP3JljDVVIh1V2X32h+DjHX0y im/w== X-Gm-Message-State: AOAM532nosl+zWYKpXNJ7ehykNAqpnyLajnLTRGykHOpy6nzW9UkuywZ Y84D3StXDKPS4I0pYhwYRqJxx35bADkauh4nALpNBlxpC+VSMf8VAOHxOXHo3XBgHn2EPzxLa4c /qOD0tNfyMgYJR5KfroWFlA/tq0nHTBeHTKlTGyMEvjPYpfA1QMvIBG2k58h760zrL0d8zhk01U JtRY5phcjEkzj/XTIX5x7pY6f+Cf61aIKWwzu1qSlHwjJFfkNvKD+RyS/WdQ== X-Google-Smtp-Source: ABdhPJxaRjOySWlF6jkGRLolMeqlCsVcYcyMDl0EpfPrRbp2atldXjGx6hVWwX45HLffTYlMP7ujbIHQU/tf185GCa0= X-Received: by 2002:a67:f1d8:: with SMTP id v24mr16618029vsm.7.1633521766792; Wed, 06 Oct 2021 05:02:46 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Aditya Toshniwal Date: Wed, 6 Oct 2021 17:32:10 +0530 Message-ID: Subject: Re: [pgAdmin][patch] Partition node related fixes To: Akshay Joshi Cc: pgadmin-hackers Content-Type: multipart/mixed; boundary="000000000000a4ae1305cdadec54" 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 --000000000000a4ae1305cdadec54 Content-Type: multipart/alternative; boundary="000000000000a4ae1105cdadec52" --000000000000a4ae1105cdadec52 Content-Type: text/plain; charset="UTF-8" Hi Hackers, Following the chain, attached patch fixes indexes not loading in Primary constraint and Unique const dialog for partition. On Wed, Oct 6, 2021 at 5:00 PM Akshay Joshi wrote: > Thanks, the patch applied. > > On Wed, Oct 6, 2021 at 4:37 PM Aditya Toshniwal < > aditya.toshniwal@enterprisedb.com> wrote: > >> 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 < >> akshay.joshi@enterprisedb.com> 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" >> > > > -- > *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" --000000000000a4ae1105cdadec52 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi Hackers,

Following the chain, attached patch fixes = indexes not loading in Primary constraint and Unique const dialog for parti= tion.

On Wed, Oct 6, 2021 at 5:00 PM Akshay Joshi <akshay.joshi@enterprisedb.com> wrot= e:
Thanks, the patch applied.

On Wed, Oct 6, 2021 at 4:37 PM Aditya Tos= hniwal <aditya.toshniwal@enterprisedb.com> wrote:
Hi Hackers,

<= div class=3D"gmail_default" style=3D"font-family:verdana,sans-serif">The no= des 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 <akshay.joshi@enterprisedb.com> wrote:
=
Thanks, = the patch applied.

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

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

--
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



--
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



--
Thanks,
Aditya Toshniwal
pgAdmin Hacker=C2=A0| Software A= rchitect=C2=A0| edbpostgres.com
"Don't Complain about Heat, Plant a TREE&qu= ot;
--000000000000a4ae1105cdadec52-- --000000000000a4ae1305cdadec54 Content-Type: application/octet-stream; name="RM6868.part3.patch" Content-Disposition: attachment; filename="RM6868.part3.patch" Content-Transfer-Encoding: base64 Content-ID: X-Attachment-Id: f_kufgnrr80 ZGlmZiAtLWdpdCBhL3dlYi9wZ2FkbWluL2Jyb3dzZXIvc2VydmVyX2dyb3Vwcy9zZXJ2ZXJzL2Rh dGFiYXNlcy9zY2hlbWFzL3RhYmxlcy9jb25zdHJhaW50cy9pbmRleF9jb25zdHJhaW50L3N0YXRp Yy9qcy9wcmltYXJ5X2tleS5qcyBiL3dlYi9wZ2FkbWluL2Jyb3dzZXIvc2VydmVyX2dyb3Vwcy9z ZXJ2ZXJzL2RhdGFiYXNlcy9zY2hlbWFzL3RhYmxlcy9jb25zdHJhaW50cy9pbmRleF9jb25zdHJh aW50L3N0YXRpYy9qcy9wcmltYXJ5X2tleS5qcwppbmRleCA3NDJmNzY3Y2YuLmQ3ODY5OTNkYyAx MDA2NDQKLS0tIGEvd2ViL3BnYWRtaW4vYnJvd3Nlci9zZXJ2ZXJfZ3JvdXBzL3NlcnZlcnMvZGF0 YWJhc2VzL3NjaGVtYXMvdGFibGVzL2NvbnN0cmFpbnRzL2luZGV4X2NvbnN0cmFpbnQvc3RhdGlj L2pzL3ByaW1hcnlfa2V5LmpzCisrKyBiL3dlYi9wZ2FkbWluL2Jyb3dzZXIvc2VydmVyX2dyb3Vw cy9zZXJ2ZXJzL2RhdGFiYXNlcy9zY2hlbWFzL3RhYmxlcy9jb25zdHJhaW50cy9pbmRleF9jb25z dHJhaW50L3N0YXRpYy9qcy9wcmltYXJ5X2tleS5qcwpAQCAtMTA1LDcgKzEwNSw3IEBAIGRlZmlu ZSgncGdhZG1pbi5ub2RlLnByaW1hcnlfa2V5JywgWwogICAgICAgICAgIHNwY25hbWU6ICgpPT5n ZXROb2RlTGlzdEJ5TmFtZSgndGFibGVzcGFjZScsIHRyZWVOb2RlSW5mbywgaXRlbU5vZGVEYXRh LCB7fSwgKG0pPT57CiAgICAgICAgICAgICByZXR1cm4gKG0ubGFiZWwgIT0gJ3BnX2dsb2JhbCcp OwogICAgICAgICAgIH0pLAotICAgICAgICAgIGluZGV4OiAoKT0+Z2V0Tm9kZUxpc3RCeU5hbWUo J2luZGV4JywgdHJlZU5vZGVJbmZvLCBpdGVtTm9kZURhdGEpLAorICAgICAgICAgIGluZGV4OiAo KT0+Z2V0Tm9kZUxpc3RCeU5hbWUoJ2luZGV4JywgdHJlZU5vZGVJbmZvLCBpdGVtTm9kZURhdGEs IHtqdW1wQWZ0ZXJOb2RlOiAnc2NoZW1hJ30pLAogICAgICAgICB9LCB0cmVlTm9kZUluZm8pOwog ICAgICAgfSwKICAgICAgIC8vIERlZmluZSB0aGUgbW9kZWwgZm9yIGluZGV4IGNvbnN0cmFpbnQg bm9kZQpkaWZmIC0tZ2l0IGEvd2ViL3BnYWRtaW4vYnJvd3Nlci9zZXJ2ZXJfZ3JvdXBzL3NlcnZl cnMvZGF0YWJhc2VzL3NjaGVtYXMvdGFibGVzL2NvbnN0cmFpbnRzL2luZGV4X2NvbnN0cmFpbnQv c3RhdGljL2pzL3VuaXF1ZV9jb25zdHJhaW50LmpzIGIvd2ViL3BnYWRtaW4vYnJvd3Nlci9zZXJ2 ZXJfZ3JvdXBzL3NlcnZlcnMvZGF0YWJhc2VzL3NjaGVtYXMvdGFibGVzL2NvbnN0cmFpbnRzL2lu ZGV4X2NvbnN0cmFpbnQvc3RhdGljL2pzL3VuaXF1ZV9jb25zdHJhaW50LmpzCmluZGV4IDdiMmE4 ZmU4Ny4uZjI0ZTA2MTk3IDEwMDY0NAotLS0gYS93ZWIvcGdhZG1pbi9icm93c2VyL3NlcnZlcl9n cm91cHMvc2VydmVycy9kYXRhYmFzZXMvc2NoZW1hcy90YWJsZXMvY29uc3RyYWludHMvaW5kZXhf Y29uc3RyYWludC9zdGF0aWMvanMvdW5pcXVlX2NvbnN0cmFpbnQuanMKKysrIGIvd2ViL3BnYWRt aW4vYnJvd3Nlci9zZXJ2ZXJfZ3JvdXBzL3NlcnZlcnMvZGF0YWJhc2VzL3NjaGVtYXMvdGFibGVz L2NvbnN0cmFpbnRzL2luZGV4X2NvbnN0cmFpbnQvc3RhdGljL2pzL3VuaXF1ZV9jb25zdHJhaW50 LmpzCkBAIC05MSw3ICs5MSw3IEBAIGRlZmluZSgncGdhZG1pbi5ub2RlLnVuaXF1ZV9jb25zdHJh aW50JywgWwogICAgICAgICAgIHNwY25hbWU6ICgpPT5nZXROb2RlTGlzdEJ5TmFtZSgndGFibGVz cGFjZScsIHRyZWVOb2RlSW5mbywgaXRlbU5vZGVEYXRhLCB7fSwgKG0pPT57CiAgICAgICAgICAg ICByZXR1cm4gKG0ubGFiZWwgIT0gJ3BnX2dsb2JhbCcpOwogICAgICAgICAgIH0pLAotICAgICAg ICAgIGluZGV4OiAoKT0+Z2V0Tm9kZUxpc3RCeU5hbWUoJ2luZGV4JywgdHJlZU5vZGVJbmZvLCBp dGVtTm9kZURhdGEpLAorICAgICAgICAgIGluZGV4OiAoKT0+Z2V0Tm9kZUxpc3RCeU5hbWUoJ2lu ZGV4JywgdHJlZU5vZGVJbmZvLCBpdGVtTm9kZURhdGEsIHtqdW1wQWZ0ZXJOb2RlOiAnc2NoZW1h J30pLAogICAgICAgICB9LCB0cmVlTm9kZUluZm8pOwogICAgICAgfSwKICAgICB9KTsK --000000000000a4ae1305cdadec54--