Bug: Chat2DB does not display PgSQL partitioned table

[Jimokk]

Chat2DB Version

3.1.15

Describe the bug

Preface

Years ago, when I used PGSQL to create a table, I found that the table could not be displayed. When the problem recurred today, it was said that the problem was located in the partition table.

Problem Description

The partition table I created is not displayed, but the partitions can be displayed. For example, if I create a partition table called tb_test, this table will not be displayed (refreshing is useless), and then I create a partition for this table such as tb_test_0/ 1/2/3, these partitions can be displayed normally.

Problem recurrence

1. The following is the SQL code (PgSQL) that I executed when reproducing:

DROP TABLE IF EXISTS public.tb_test;
CREATE TABLE public.tb_test (
	id bigserial NOT NULL,
	tx_date varchar(8) NOT NULL,
	CONSTRAINT PK_tb_test_ID PRIMARY KEY (id, tx_date) -- Added a primary key constraint using ID and tx_date
)
PARTITION BY LIST (tx_date);  --Partition LIST, RANGE, LIST is used here

2. You can also check the contents of the table by executing SELECT

SELECT * FROM public.tb_test;

At the same time, if you try to create a new table without deleting it, an error will be reported. You can be sure that the table does exist.

3. At this time, refresh the Schema named plat in Chat2DB and view it as empty. The screenshot is as follows:

But you can see this table in DBeaver, the screenshot is as follows:

4. If I create a partition named tb_test_0/1/2/3 for the table at this time, it will be displayed normally, but it will not be displayed in DBeaver. The relevant statements and screenshots are as follows:

CREATE TABLE plat.tb_test_0 PARTITION OF plat.tb_test FOR VALUES IN ('20240110');

(Since it is just a test, only three partitions are created here, where the constant in plat.tb_test_%d is equal to the last digit of the date).

Summarize

The above is the specific description of this BUG. In fact, I am not sure whether this is a BUG or whether Chat2DB is deliberately set up like this. However, in my work scenario, the relevant partitions of this table are automatically created every day, that is It said that after I created all the work tables, the partition table was not displayed, which was a bit inconvenient and strange to use.

Thank you again to all developers for your hard work and reading! Happy New Year to everyone! Good luck in the Year of the Dragon!