Re: [pgadmin-hackers] Declarative partitioning in pgAdmin4

On Fri, May 19, 2017 at 2:17 AM Akshay Joshi <akshay.joshi@enterprisedb.com> wrote:

Hi Shirley 

On Thu, May 18, 2017 at 9:06 PM, Shirley Wang <swang@pivotal.io> wrote:

Hi Akshay!

Is this the workflow that you think users are going to engage in given what you're building? Anne mentioned you're in the process of figuring out what's required for defining the partitions, so you'll notice pink boxes with text in areas where that might happen. 

The modules that appear for partitioning are based on the ones we saw a few weeks ago, let me know if that has changed in any way.

01 user creates a table, if one doesn't already exist

02 user selects 'yes' for partitioning

   Step 1 and 2 are correct. 

 

03 user defines type of partition and ranges

   We will create a new tabs "Partitions" and 'Partition Type' combo will go on that tab along with following controls:

• User should be able to specify Key Column(s) (Based on partition type) to create partitioned(parent) table. Some of the examples of list and range partitions are as below:  
  
  • CREATE TABLE prt1 (a int, b int, c varchar) PARTITION BY RANGE(a);
    
  • CREATE TABLE prt1_e (a int, b int, c varchar) PARTITION BY RANGE(((a + b)/2));
    
  • CREATE TABLE prt1_m (a int, b int, c varchar) PARTITION BY RANGE(a, ((a + b)/2));
    
  • CREATE TABLE plt1 (a int, b int, c text) PARTITION BY LIST(c);
    
  • CREATE TABLE plt1_e (a int, b int, c text) PARTITION BY LIST(ltrim(c, 'A'));
    
• User should be able to create N number of partitions:

• Design one control (subnode control) so that user will add N number of partitions. Here is the syntax as per documentation CREATE  TABLE  table_name PARTITION OF parent_table [ (   { column_name [ WITH OPTIONS ] [ column_constraint [ ... ] ]     | table_constraint }     [, ... ] ) ] FOR VALUES partition_bound_spec partition_bound_spec is:{ IN ( { bound_literal | NULL } [, ...] ) | FROM ( { bound_literal | UNBOUNDED } [, ...] ) TO ( { bound_literal | UNBOUNDED } [, ...] ) }

   Design(GUI) discussion required for above two, which control should we used so that user will be easily able to create N number of partitions.   

Ok. Hopefully we'll get some interviews set up for next week that'll help us determine the best workflow for this.