Fixed an issue where schema diff marks an identical table as different. Fixes #5350 Fixed an issue where schema diff showing changes in the identical domain constraints. Fixes #5315
Ignore the keys from the source and target list and also sort both the lists. Branch ------ master Details ------- https://git.postgresql.org/gitweb?p=pgadmin4.git;a=commitdiff;h=4692b21bcff7ee5f2f9b5173a454c99a402d4172 Modified Files -------------- docs/en_US/release_notes_4_21.rst | 2 + .../databases/schemas/foreign_tables/__init__.py | 4 +- .../templates/mviews/pg/9.3_plus/sql/delete.sql | 2 +- .../templates/mviews/pg/9.4_plus/sql/delete.sql | 2 +- .../templates/mviews/ppas/9.3_plus/sql/delete.sql | 2 +- .../static/vendor/backgrid/backgrid-select-all.js | 4 +- web/pgadmin/tools/schema_diff/directory_compare.py | 98 +++++++++++++++++----- .../tools/schema_diff/tests/pg/10_plus/source.sql | 17 ++++ .../tools/schema_diff/tests/pg/10_plus/target.sql | 17 ++++ .../tools/schema_diff/tests/pg/11_plus/source.sql | 17 ++++ .../tools/schema_diff/tests/pg/11_plus/target.sql | 17 ++++ .../tools/schema_diff/tests/pg/12_plus/source.sql | 17 ++++ .../tools/schema_diff/tests/pg/12_plus/target.sql | 17 ++++ .../tools/schema_diff/tests/pg/9.2_plus/source.sql | 17 ++++ .../tools/schema_diff/tests/pg/9.2_plus/target.sql | 17 ++++ .../schema_diff/tests/ppas/10_plus/source.sql | 17 ++++ .../schema_diff/tests/ppas/10_plus/target.sql | 17 ++++ .../schema_diff/tests/ppas/9.2_plus/source.sql | 17 ++++ .../schema_diff/tests/ppas/9.2_plus/target.sql | 17 ++++ 19 files changed, 290 insertions(+), 28 deletions(-)
