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 1mY5vi-0002Hx-0m for pgadmin-hackers@arkaria.postgresql.org; Wed, 06 Oct 2021 12:21:50 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mY5vg-0006HE-Vq for pgadmin-hackers@arkaria.postgresql.org; Wed, 06 Oct 2021 12:21:48 +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 1mY5vg-0006H5-DD for pgadmin-hackers@lists.postgresql.org; Wed, 06 Oct 2021 12:21:48 +0000 Received: from mail-il1-x136.google.com ([2607:f8b0:4864:20::136]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1mY5vd-0005v5-EJ for pgadmin-hackers@postgresql.org; Wed, 06 Oct 2021 12:21:47 +0000 Received: by mail-il1-x136.google.com with SMTP id j2so2622049ilo.10 for ; Wed, 06 Oct 2021 05:21:45 -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=AIDjEUHeuLQ8+uCPTHYT3FSktYA/T3xuD6gok5XM+Ac=; b=Nm5NAXxYep60QXUkCK7JQS4Gx+yFThFrAkOuiXL6leYDZPrt9ieajHZai2Ho5h8hAH DU/o50lbCveOGflzkiVdBm/tqY/ojhSm+17oSO5uKg2QLec/O3ST0MoYdoczCN7w7IeW KakZtfurXEaFFU9lh2ZMLQ7HzjxMpb7yPIakkBSKtFcmtH5YsJCfL0xDOMHdicMrnwl8 /LHyYoBU4Lrw0/xuewcEdIK7wFtf8b2NOzd61U/JjgZ3KQqLRUjqdeht0wogFWJNx1SU ZS2L6XTkQ/ELxKMjKta7jQmsTHUqIcS4XTFpyxrRrN7B1Go8VM1h0r6r7XvEXY8qEAII p+ig== 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=AIDjEUHeuLQ8+uCPTHYT3FSktYA/T3xuD6gok5XM+Ac=; b=tyoyT2LMkPKw69qWf6map/6FdgepGcn8GjspUPmas6pr2M/+NUDYQgiK1unf//LKSu c9JHdX2Rlf9yIYBoAJAXMQhGNBhZpgBZWnTUwnaId2OLy+TJixrbScnUeGq2P92COtJ6 +5b4kyMqtc7N/z1uDG95sH7MsXcHGS8NmzvdjKWRWCbyZh3i5VrQM2uJWOTasGFfXVqY IuwKm4NL5JWX+UQoVwNBcJFI9kntVQ8PcifxZ2v6AOrVj0JgprMhsE23Y0PgbJ2aew4V AUN4wAkpMHmMkpfd5m1YJ7fSUdKqUpQHz+mJXV1rtEFLJE2NdKlUWBoOiZxslXI81xhU EV7w== X-Gm-Message-State: AOAM530V3kLMsmXNwynfPzwBi7Ny/LKhpgz5FkolASIUwq+t5ATIlE/j FjigSkvWu0YuvmMQj9p7JtLopcnugdohzjwFa1/qo5Os5PapM+tH4lGet1a0/0iW6nsU/E9gGNY b+xBGHJhNrVyJd/GNZ1jLQbjyYgk6gIkTchCzg7xIawgUGRsTBr15/6hiF3XoPjaKG8g9h+rJjs /smloWfGrna6jVEVEyMxoOEmH9qK7bi7/Vb95fxJ39J7H7Qo1b+Qz6Js/FVw== X-Google-Smtp-Source: ABdhPJxBX+XM2h59XHczRPcsnb2hIKep6yTYpiq/3eeErSYJJE6jhnaMy7AgvNOfCIi4dfnNY8PEmfUSBxXGser7y7s= X-Received: by 2002:a05:6e02:bc3:: with SMTP id c3mr7202244ilu.178.1633522903379; Wed, 06 Oct 2021 05:21:43 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Akshay Joshi Date: Wed, 6 Oct 2021 17:51:32 +0530 Message-ID: Subject: Re: [pgAdmin][patch] Partition node related fixes To: Aditya Toshniwal Cc: pgadmin-hackers Content-Type: multipart/alternative; boundary="00000000000063895605cdae30fd" 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 --00000000000063895605cdae30fd Content-Type: text/plain; charset="UTF-8" Thanks, the patch applied. On Wed, Oct 6, 2021 at 5:32 PM Aditya Toshniwal < aditya.toshniwal@enterprisedb.com> wrote: > 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" > -- *Thanks & Regards* *Akshay Joshi* *pgAdmin Hacker | Principal Software Architect* *EDB Postgres * *Mobile: +91 976-788-8246* --00000000000063895605cdae30fd Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Thanks, the patch applied.

On Wed, Oct 6, 2021 at 5:32 PM A= ditya Toshniwal <ad= itya.toshniwal@enterprisedb.com> wrote:
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 <akshay.joshi@enterprisedb.com> wrote:
Thanks, the patch ap= plied.

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

The nodes index, RLS policy, r= ules, triggers are failing to save for partitions. Please review the attach= ed patch to fix the issue.

On Wed, Oct 6, 2021 at 2:54 PM Akshay Joshi= <aks= hay.joshi@enterprisedb.com> wrote:
Thanks, the patch applied.
=
On Wed= , Oct 6, 2021 at 12:25 PM Aditya Toshniwal <aditya.toshniwal@enterprisedb.co= m> wrote:
Hi Hackers,

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

--
Thanks,
Aditya Toshniwal
pgAdmin H= acker=C2=A0| Software Architect= =C2=A0| edbpostgres.com
"Don't Complain ab= out 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 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

--00000000000063895605cdae30fd--