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.shirsat@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(-)
