Re: [pgadmin-hackers] Declarative partitioning in pgAdmin4

Hi Dave

Murtuza and I started thinking about "How to add Declarative Partitioning" support in pgAdmin4. We thought instead of showing Partition Table under existing Tables collection, we should add new collection node "Partition Tables". Showing table under the table node recursively will require lots of code changes in table and it's child nodes (column, index, trigger, etc..) which is more complex and error prone. 

Below is the design that we can implement: 

• Create new "Partition Tables" collection node. User will be able to create partition table by clicking "Create -> Partition Table" menu that we will add on collection node. We will share the dialog prototype later once we will have complete understanding of it.

• Once table is created user will be able to create partitions by clicking "Create -> Partitions" menu will be added on each partitioned table node. We will share the dialog prototype later once we will have complete understanding of it.

• We will have to show sub nodes like (column, index, trigger, constraints, etc..) on main table while some of the sub nodes won't require for partitions like (column and many more again require some more knowledge on partitioning).

Apart from above we will have to figure out following:

• How to remove partitions(table) from existing tables node as value of relkind column is 'r' for partitions.
• Partitioning scheme to show in SQL pane for partitions.
  
• Some unknown issue/features of Declarative partitioning. 

The above implementation may take more time, so it might possible that we may not be able to finish it by 14th May (deadline).