Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1ioLvO-0007SH-BT for pgadmin-hackers@arkaria.postgresql.org; Mon, 06 Jan 2020 06:31:38 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1ioLvN-0000qC-5D for pgadmin-hackers@arkaria.postgresql.org; Mon, 06 Jan 2020 06:31:37 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1ioLvM-0000nm-U3 for pgadmin-hackers@lists.postgresql.org; Mon, 06 Jan 2020 06:31:36 +0000 Received: from mail-lj1-x22f.google.com ([2a00:1450:4864:20::22f]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1ioLvK-0008Og-3T for pgadmin-hackers@postgresql.org; Mon, 06 Jan 2020 06:31:36 +0000 Received: by mail-lj1-x22f.google.com with SMTP id z22so44989993ljg.1 for ; Sun, 05 Jan 2020 22:31:33 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=enterprisedb-com.20150623.gappssmtp.com; s=20150623; h=mime-version:references:in-reply-to:from:date:message-id:subject:to :cc; bh=TJL2Z7eZz5dLQHYy6AKmK2F6A+iHUDoNauWcdYGZRNE=; b=2FdmAZGjHH/VFQAIqYyXGQ6/ed0ap7kLEq5Z14ypn2gI5g0kr5stkGddtK4NCIWQ9W Ggbj7rIa8SRmZ8U8PUIpFCqTKqk8s/u9yPxL88CbZMZAGyWkdCQEUAC3Np7MhtCcQljI QrEdhFdDC0ZW/rUfAu/dDYNLwT12TMxScjOVcKH1yLgFy89rNd5Bo4wdK5qD8D8/zlDM 80Flij+UzYg71mry7MnaEGjum38m7qx5vER25GO8AnU6May8rz3B6cVegY1Vgw2oZbZW ba+BiQBlyNvkZfY+ySrgutPmDzI8XwONfMwUtlIhXRVNDQksXDlG28O5edWF4qie5kwb jIgQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:references:in-reply-to:from:date :message-id:subject:to:cc; bh=TJL2Z7eZz5dLQHYy6AKmK2F6A+iHUDoNauWcdYGZRNE=; b=ERyDBUNi31Vv36pFwnkNcHRenOTjSXy4y3OMEhfcxuki347XlQtexOpzDrw2PCFFS5 ddkkCsHonLmhAhJcfQ74mTX6GNuAyiAIDQgbOlz7UiEpRsB8sd5b3qsm7ryLPQGgw9kM FyDxu7eh8RKA/ZvV+XhZHwK59W3a/0OOE5QtK1gjRbnVfvQb+LaDwQHB+atoDxvxOIrn 9ExLWIYtalJHL8oW2uGVWmOkXOA+v4VvBPC4A7DHZkhiQSph7aKupo4ChK6o3syZAvE3 HfSibKwr5nkXC73c4vTxFG6GlGyZ5YYSgMzG/j2yOXykR3LtI3AN8qg/Pt8Zl28/nMRC ZSsg== X-Gm-Message-State: APjAAAWxGySB/V7y7lqVfgZ43J8ann0shYor0tpijE/U9Z/h1DYccy9r zE8BN9F5T7MBUua+2514ly61NJ5rs/Gx6buHB2RVkl2rpvXSGJdvHKJOeolSvYeY9Gxd3Vw0D6b vcxlSTCEg+kDdN+R15n0gQHCuNvogqUTPdq4O8caeza01v1XwlLK8DETONPk8WBIIsO07BE7IFC zfwvjyF90wcl5RAtW8XUvFmLzMCq8IgwJnr4XfuAXXxKA5vkEyQTo= X-Google-Smtp-Source: APXvYqyS/yomEN0vjfSJWutlt7iO3xkFSiSdDKgMsLL6CZSIki4X23Z8tRmzm84+vDO8yWmDSfb1huf/7Zg25v5YRMg= X-Received: by 2002:a2e:810d:: with SMTP id d13mr59755516ljg.113.1578292293006; Sun, 05 Jan 2020 22:31:33 -0800 (PST) MIME-Version: 1.0 References: In-Reply-To: From: Khushboo Vashi Date: Mon, 6 Jan 2020 12:01:24 +0530 Message-ID: Subject: Re: [pgAdmin][RM4633] Bad view in partitioned tables To: Akshay Joshi Cc: pgadmin-hackers Content-Type: multipart/alternative; boundary="0000000000007a10b5059b72cfc5" X-CLOUD-SEC-AV-Info: edb,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: Precedence: bulk --0000000000007a10b5059b72cfc5 Content-Type: text/plain; charset="UTF-8" Hi Akshay, On Fri, Jan 3, 2020 at 4:58 PM Akshay Joshi wrote: > Hi Hackers > > Attached is the patch to support the view part of the multilevel > partitions. Users can perform all the operations except creating the > partitions as a partitioned table. Users can create a partition table > separately and attach it as a partition of another partition table. > Multilevel partitions are now manageable through the tree view except creating a partition table of existing partition (which you already mentioned). One more problem that we already discussed that automatic tree refresh of the multilevel partitions is not working due to our structure which is going to be handled by the new RM. Some of the minor review comments. - _get_children_nodes name can be changed as it more like private method but we are using it outside of the class itself. - Stats of partition table is not displayed, but I think that is not related to this patch, so can be fixed later. Thanks, Khushboo > > There are two problems mentioned in the RM. I have fixed the first one and > we won't fix the second problem as by design we decided to show Partitions > like Schema->Table->Partitions > > Please review it. > -- > *Thanks & Regards* > *Akshay Joshi* > > *Sr. Software Architect* > *EnterpriseDB Software India Private Limited* > *Mobile: +91 976-788-8246* > --0000000000007a10b5059b72cfc5 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi Akshay,

On Fri, Jan 3, 2020 at 4:58 PM Akshay Joshi= <akshay.joshi@enterpri= sedb.com> wrote:
Hi Hackers

Attached=C2=A0is the= patch to support the view part of the multilevel partitions. Users can per= form all the operations except creating the partitions as a partitioned tab= le. Users can create a partition table separately and attach it as a partit= ion of another partition table.=C2=A0
Multilevel partitions are now manageable through the tree v= iew except creating a partition table of existing partition (which you alre= ady mentioned).
One more problem t= hat we already discussed that automatic tree refresh of the multilevel part= itions is not working due to our structure which is going to be handled by = the new RM.=C2=A0=C2=A0

Some of the minor r= eview comments.
-=C2=A0_get_children_nodes name can be changed as it more like private me= thod but we are using it outside of the class itself.
- Stats of partition table i= s not displayed, but I think that is not related to this patch, so can be f= ixed later.

Thanks,
Khushboo
There are two problems mentioned in the RM. I have fixed the fi= rst one and we won't fix the second problem as by design we decided to = show Partitions like Schema->Table->Partitions

Please review it.
--
=
Thanks & Reg= ards
Akshay Joshi
Sr. Software Architect
EnterpriseDB Software India Private Limited=
Mobile: +91 976-788-8246
--0000000000007a10b5059b72cfc5--