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 1mY58H-0000O1-Bb for pgadmin-hackers@arkaria.postgresql.org; Wed, 06 Oct 2021 11:30:45 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mY58G-0001Eu-5f for pgadmin-hackers@arkaria.postgresql.org; Wed, 06 Oct 2021 11:30:44 +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 1mY58F-0001Em-Rx for pgadmin-hackers@lists.postgresql.org; Wed, 06 Oct 2021 11:30:44 +0000 Received: from mail-il1-x129.google.com ([2607:f8b0:4864:20::129]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1mY58D-0004sm-CF for pgadmin-hackers@postgresql.org; Wed, 06 Oct 2021 11:30:42 +0000 Received: by mail-il1-x129.google.com with SMTP id j2so2475886ilo.10 for ; Wed, 06 Oct 2021 04:30: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 :cc; bh=qEol5S6TYdsc+VW8w3A+2SB9vFwYo0pVzT5TPzf7t+c=; b=HooGR+P54iPW2KTqb87rc2Y2im2v25X+J7lWV9J8ebvwxhvmSkU5Ccbzjhz9lBlNhY dMwzVbJjwMuUEnwrD7z5lhN9mDPUU9fFIOCMSXlWeiIpRGbt3j3OsWUg2F1xq5LsyMyo oBPBhMdzTrmi17ebuHyfvBemVASo7AsLVZCMVk79mQWA3W484ki3qnGu5e+hmnCaqkI4 K/O/WJ0OnRlRW8DKhpyddHxvLL4z9YxWdXRBI+EfEt1X8Xow4yE2w/RQgIFHq8Rs1XSt zt+2g7kDTxPaLY81BG7q+WGYZpd74u1KrvNXwQpCErPNlzUBE+o1LTg7niPdvnWLTV2b hB8A== 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=qEol5S6TYdsc+VW8w3A+2SB9vFwYo0pVzT5TPzf7t+c=; b=0j0I0di8xjAfhGZu4a9gARPRuKFaZT3k1Zfde0egYa4iqbCRIXvH5HvdSqeTTgL9OX ftl6raorQ+IvTsVCr3N1qhz6HX9tMkN6mCv8KFAVL5DP8iRgk+xhGiR1rb82+1MUCAsI 6vgfcrUfdCKGPgFAj1/+XmDQecI1rfZmq9Uda13ySQjW80D9W4OSATF/WOD3vNvF7Jfc OM99ce4quSiZXD/M++9dQmGX8RM4iCzsdSy+lXDpjVxJf79O+44gVQuhExnGo35AIAAA Y2udQQDtnfPP2um6mdr06Lh9zO3N9wZtZuI+1cJHdwU26rF2H2lrW281+xwM5uTMDzEx 749w== X-Gm-Message-State: AOAM530xn4ckL6WgZZEyxXNzLEUGAolwMgCzQ2nMRULmcbuRBsCnn4CO 2chgkNYEDaZR2KMXW/jRLLEliDwnp73Tp0ixVdMNQiB+y6m3kHmw3tlvKQvleY6WgX63WH6CQaX olBwmmO8kqgfOp4Kq5OOqyEXA/0u9KY3PUthHjK1PpP/h8pbTs8fRFk44GmWeQ0xw9DwEFjl2js Fyz+GYRHe1gsCcaCaoQAuiwOFNklTLWQCvbgvH4X9EyKqQ35Uhe2uGoNNrfTxRVQcQ7/y5 X-Google-Smtp-Source: ABdhPJxBS0PFgPojvmgeJiyIDH9pFOvAtSZi8Wqc3nxL9GHXd5sLpe9+EjRgEa0euMyrNskH2Mg95/ZkE4urxExBOHk= X-Received: by 2002:a05:6e02:2143:: with SMTP id d3mr3715147ilv.290.1633519840649; Wed, 06 Oct 2021 04:30:40 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Akshay Joshi Date: Wed, 6 Oct 2021 17:00:29 +0530 Message-ID: Subject: Re: [pgAdmin][patch] Partition node related fixes To: Aditya Toshniwal Cc: pgadmin-hackers Content-Type: multipart/alternative; boundary="000000000000d5fd4605cdad791a" 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 --000000000000d5fd4605cdad791a Content-Type: text/plain; charset="UTF-8" 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 > 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* --000000000000d5fd4605cdad791a Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
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. Plea= se 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.tos= hniwal@enterprisedb.com> wrote:
Hi Hackers,

Please review the attached p= atch which fixes:
1. Unable to create trigger for partition table. Fixes= #6867.
2. Unable to create index, RLS policy, rules, triggers for parti= tion. 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"


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

--000000000000d5fd4605cdad791a--