Stefan Sonnenberg-Carstens created NETBEANS-4816:
----------------------------------------------------
Summary: 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
Attachments: image-2020-09-18-18-55-37-559.png,
image-2020-09-18-19-00-36-938.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.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
For further information about the NetBeans mailing lists, visit:
https://cwiki.apache.org/confluence/display/NETBEANS/Mailing+lists
