Hello all
We are very happy with the ongoing work on partitioning i Postgres 11+. We use it in a number of cases.
A small irritation point is that some tools decide that partitions under a table are to be shown in a list of tables, sometimes drowning the main table in a sea of partitions.
PgAdmin shows partitions below the main table, Datagrip also. Other tools do not. The ones that I have heard about is the SAS System and Enterprise Architect, both connecting through ODBC. I am aware that the issue is really that these tools and/or the ODBC Driver issues queries against the catalog and these queries are naive in respect to table partitions.
Any ideas for working around this? Naming partitions in a special manner, something else. It's not the end of the world, but quite irritating for some users.
Regards
Niels Jespersen