[
https://issues.apache.org/jira/browse/NETBEANS-4816?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17257260#comment-17257260
]
Jakub Herkel commented on NETBEANS-4816:
----------------------------------------
I have prototype for this but it needs more work to be done to make it completed
!table_with_partitions.png!
> NetBeans database explorer does not handle partitioned tables in PostgreSQL
> correctly
> -------------------------------------------------------------------------------------
>
> Key: NETBEANS-4816
> URL: https://issues.apache.org/jira/browse/NETBEANS-4816
> Project: NetBeans
> Issue Type: Improvement
> Components: db - Show Data
> Affects Versions: 12.1
> Reporter: Stefan Sonnenberg-Carstens
> Assignee: Jakub Herkel
> Priority: Major
> Attachments: image-2020-09-18-18-55-37-559.png,
> image-2020-09-18-19-00-36-938.png, table_with_partitions.png
>
>
> To reproduce:
> connect to a PostgreSQL database (in my case 12.4)
> issue the following commands:
> {code:sql}
> DROP TABLE IF EXISTS T1;
> CREATE TABLE T1 (ID INTEGER, MESSAGE TEXT, TIMESTAMP TIMESTAMP) PARTITION BY
> RANGE (TIMESTAMP); CREATE TABLE T1_2020 PARTITION OF T1 FOR VALUES FROM
> ('2020-01-01') TO ('2020-12-31'); CREATE TABLE T1_2021 PARTITION OF T1 FOR
> VALUES FROM ('2021-01-01') TO ('2021-12-31'); CREATE TABLE T1_2022 PARTITION
> OF T1 FOR VALUES FROM ('2022-01-01') TO ('2022-12-31'); CREATE TABLE T1_2023
> PARTITION OF T1 FOR VALUES FROM ('2023-01-01') TO ('2023-12-31');{code}
> After successful execution you will see a picture like this below:
> !image-2020-09-18-18-55-37-559.png!
> The base table T1 is not visible at all and the sub-tables are shown as if
> they were regular tables.
> The same schema will be shown in IntelliJ like this (which is correct imho):
> !image-2020-09-18-19-00-36-938.png!
> T1 will be shown as a regular table and the attached partition tables /
> sub-tables are shown below it. This makes clear, that t1 is partitioned.
> At least all tables including t1 should be visible.
>
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@netbeans.apache.org
For additional commands, e-mail: commits-h...@netbeans.apache.org
For further information about the NetBeans mailing lists, visit:
https://cwiki.apache.org/confluence/display/NETBEANS/Mailing+lists
