| From: | Niels Jespersen <NJN(at)dst(dot)dk> |
|---|---|
| To: | "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Tools showing table partitions as tables in listings of tables |
| Date: | 2020-12-09 12:29:43 |
| Message-ID: | 41f3454665a940399ef246aa96ad0380@dst.dk |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | hubert depesz lubaczewski | 2020-12-09 12:37:47 | Re: Tools showing table partitions as tables in listings of tables |
| Previous Message | Dave Cramer | 2020-12-09 10:21:31 | Re: JDBC driver - is "getGeneratedKeys()" guaranteed to return the ids in the same order a batch insert was made? |