Thanks. We're currently running a beta testing of the upcoming 10.0 version. We'll include this in the next beta version.
Thank you. Roger.
The change discussed here is included in DbVisualizer 10.0, available for purchase now. Is there some other PostgreSQL 10 feature you would like to see supported?
PostgreSQL 10 was released just a week ago, and we have not formally tested with it yet or looked at if there are any new features we should add support for. Once we've done that, the Supported Databases page will be updated to show formal support also for version 10.
The features developed for earlier versions are more than likely to work fine also with PostgreSQL 10. We provide database-specific support for many different databases and add new features for new database version based on requests from our customers. If you find that we do not support something added in PostgreSQL 10, let us know and we will look into it.
It would be great if you can briefly describe what features you would find helpful, so we can look into it. We made a small change a few versions back to list the partitioned tables along with regular tables, at the suggestion of another customer. I assume you would like to see them separated from regular tables with different actions and views?
Thanks. We will look into it and let you know if we add more support for partitioned tables.
DbVisualizer 10.0.7 is now released with extended support for partitioned tables.
I have seen only a few minor flaws:
- if you click on the partitioned table in the navigator, you can see the columns of the table in a tree view.
But when you open this table in the database window (the big window on the right side), the "Columns"
tab does not show the columns. No big deal, but this seems to be wrong ...
- I can see the new partition view only if I log in to the database as a superuser. If the partitioned table is
owned by user "test_schema" and inside the schema "test_schema" and I log in as user "test_schema"
then the partitions are shown as regular tables and the partitioned table (the master of the partitions) is
missing at all.
I can reproduce the first issue, i.e. that the Columns tab is empty, and will look into that.
However, I'm not able to reproduce the second issue. I have a schema named "test" in a database named "postgres". I connect with a user named "test" and create a partitioned table. Looking at the Info tab for this table I see that it is owned by user "test" and is part of the "test" schema. It shows up in the Databases tree as a table and its Partitions node list the partitions. Am I doing something different than the case you describe?
PostgreSQL version 10(beta) supports partitioned tables.
Table attribute 'p' has been added.
The parent table is not visible.
It works after modifying as below.