Added support of Domain, Domain Constraints and Types to the Schema Diff. Fixes #5262
Branch ------ master Details ------- https://git.postgresql.org/gitweb?p=pgadmin4.git;a=commitdiff;h=94a76cc9e087b8c567a543cb6ad8513ee1f98b9d Modified Files -------------- docs/en_US/release_notes_4_20.rst | 3 +- .../servers/databases/schemas/domains/__init__.py | 85 ++++++++--- .../domains/sql/9.2_plus/domain_schema_diff.sql | 44 ++++++ .../templates/domains/sql/9.2_plus/update.sql | 16 +- .../servers/databases/schemas/types/__init__.py | 74 +++++++++- .../types/sql/default/additional_properties.sql | 4 +- .../types/sql/default/type_schema_diff.sql | 105 +++++++++++++ web/pgadmin/tools/schema_diff/directory_compare.py | 5 +- .../tools/schema_diff/tests/pg/10_plus/source.sql | 162 +++++++++++++++++++++ .../tools/schema_diff/tests/pg/10_plus/target.sql | 145 ++++++++++++++++++ .../tools/schema_diff/tests/pg/11_plus/source.sql | 126 ++++++++++++++++ .../tools/schema_diff/tests/pg/11_plus/target.sql | 145 ++++++++++++++++++ .../tools/schema_diff/tests/pg/12_plus/source.sql | 126 ++++++++++++++++ .../tools/schema_diff/tests/pg/12_plus/target.sql | 145 ++++++++++++++++++ .../tools/schema_diff/tests/pg/9.2_plus/source.sql | 126 ++++++++++++++++ .../tools/schema_diff/tests/pg/9.2_plus/target.sql | 143 ++++++++++++++++++ .../schema_diff/tests/ppas/10_plus/source.sql | 126 ++++++++++++++++ .../schema_diff/tests/ppas/10_plus/target.sql | 146 +++++++++++++++++++ .../schema_diff/tests/ppas/9.2_plus/source.sql | 126 ++++++++++++++++ .../schema_diff/tests/ppas/9.2_plus/target.sql | 145 ++++++++++++++++++ 20 files changed, 1968 insertions(+), 29 deletions(-)