Today I have read the https://www.postgresql.org/docs/release/12.0/ release note. I have created some new feature request and fixed one issue. Following are the issues that I have fixed:
Fixed existing issue to drop/delete partitions of the partition table.
Allow foreign keys to reference partitioned tables.
Created following issues, not sure we need to consider it:
I have started adding support of PostgreSQL v12 in pgAdmin4. Attached is the patch to fix the following issues:
RM #4290: "string indices must be integers" displayed for all objects
RM #4288: View data issue.
PG v12 removes the ability to create table using WITH OIDS, so I have modified the code in GUI as well as on backend.
PG v12 removes obsolete pg_attrdef.adsrc and pg_constraint.consrc column, so fixed with appropriate functions calls.
For partitioned tables, since no storage is required for the table itself. PG v12 throws and error while specifying "TABLESPACE" in create table syntax for partitioned table, so fix that too.
This is the initial patch to fix the issues that has been raised or I have found. Will continue to work on adding support for v12. Will check the release notes.
