When I try to view the SQL for a partition of a partitioned table (eg click Tables->my_table_name->Partitions->my_partition, then click SQL in the tabs on the top right of the window), my Chrome developer tools tell me that PgAdmin responded with a status of 410 GONE. I can expand the partition and view the SQL for its constraints and indexes, although I get an indefinite "Retrieving data from the server..." screen when I right click on the partition and select "properties".
I'm able to recreate this in version 3.0 and 3.1, with both dpage's Docker container and the RPM running on Centos 7. The output at the bottom is from the Docker container.
I don't think there's anything weird about my partitions except they use PG10 range partitioning, although what is strange is I created them using PgAdmin (probably 3.0) from the AUR about a month ago and they worked fine then. The new ones that I just created (the partitions for August- every one is a week) are unviewable as well. The names of the partitioned tables are minuteYYYYMMDD, so minute20180701, minute20180708, etc, and those tables are partitions of the minute table.
The fix for this issue has been committed yesterday, so you will get the fix in the next release.
Thanks in advance,
Brian
Version
3.1
Copyright
Copyright 2013 - 2018, The pgAdmin Development Team
