Fixed reverse engineered SQL for partitions when storage parameters are specified. Fixes #5569.
Branch ------ master Details ------- https://git.postgresql.org/gitweb?p=pgadmin4.git;a=commitdiff;h=d6893f9d8a1a4aed95daf20664e4af3655692a11 Author: Rahul Shirsat <rahul.shir...@enterprisedb.com> Modified Files -------------- docs/en_US/release_notes_4_24.rst | 1 + .../servers/databases/schemas/tables/__init__.py | 37 +----- .../schemas/tables/partitions/__init__.py | 66 +++++----- .../tables/partitions/static/js/partition.js | 10 ++ .../tests/pg/10_plus/alter_table_add_partition.sql | 26 ++++ .../pg/10_plus/alter_table_add_partition_msql.sql | 2 + .../pg/10_plus/create_table_with_partition.sql | 18 +++ .../10_plus/create_table_with_partition_msql.sql | 13 ++ .../tests/pg/10_plus/test_partitions.json | 139 +++++++++++++++++++++ .../tests/pg/12_plus/alter_table_add_partition.sql | 22 ++++ .../pg/12_plus/alter_table_add_partition_msql.sql | 2 + .../pg/12_plus/create_table_with_partition.sql | 14 +++ .../12_plus/create_table_with_partition_msql.sql | 10 ++ .../tests/pg/12_plus/test_partitions.json | 139 +++++++++++++++++++++ .../ppas/10_plus/alter_table_add_partition.sql | 26 ++++ .../10_plus/alter_table_add_partition_msql.sql | 2 + .../ppas/10_plus/create_table_with_partition.sql | 18 +++ .../10_plus/create_table_with_partition_msql.sql | 13 ++ .../tests/ppas/10_plus/test_partitions.json | 139 +++++++++++++++++++++ .../ppas/12_plus/alter_table_add_partition.sql | 22 ++++ .../12_plus/alter_table_add_partition_msql.sql | 2 + .../ppas/12_plus/create_table_with_partition.sql | 14 +++ .../12_plus/create_table_with_partition_msql.sql | 10 ++ .../tests/ppas/12_plus/test_partitions.json | 139 +++++++++++++++++++++ .../partitions/sql/gpdb/5_plus/properties.sql | 6 +- .../templates/partitions/sql/pg/10_plus/create.sql | 32 ++--- .../templates/partitions/sql/pg/10_plus/nodes.sql | 29 ++++- .../partitions/sql/pg/10_plus/properties.sql | 6 +- .../partitions/sql/pg/12_plus/properties.sql | 6 +- .../partitions/sql/ppas/10_plus/create.sql | 29 ++--- .../partitions/sql/ppas/10_plus/nodes.sql | 29 ++++- .../partitions/sql/ppas/10_plus/properties.sql | 6 +- .../partitions/sql/ppas/12_plus/properties.sql | 6 +- .../tables/templates/tables/sql/10_plus/create.sql | 2 +- .../tables/templates/tables/sql/11_plus/create.sql | 2 +- .../tables/templates/tables/sql/12_plus/create.sql | 2 +- .../servers/databases/schemas/tables/utils.py | 101 ++++++++++++++- 37 files changed, 1019 insertions(+), 121 deletions(-)
