Added support of Foreign Tables to the Schema Diff. Fixes #5263 Branch ------ master
Details ------- https://git.postgresql.org/gitweb?p=pgadmin4.git;a=commitdiff;h=31f255b541f745f0b5a68d9733744e352c1faa94 Modified Files -------------- docs/en_US/release_notes_4_21.rst | 1 + .../databases/schemas/foreign_tables/__init__.py | 137 +++++++++++++++++++-- .../foreign_tables/sql/9.2_plus/get_columns.sql | 2 +- .../sql/9.5_plus/foreign_table_schema_diff.sql | 76 ++++++++++++ .../foreign_tables/sql/9.5_plus/get_columns.sql | 2 +- .../foreign_tables/sql/9.5_plus/update.sql | 11 ++ .../schemas/tables/compound_triggers/__init__.py | 4 +- .../databases/schemas/tables/rules/__init__.py | 4 +- .../databases/schemas/tables/triggers/__init__.py | 4 +- web/pgadmin/tools/schema_diff/directory_compare.py | 26 ++-- .../tools/schema_diff/tests/pg/10_plus/source.sql | 104 ++++++++++++++++ .../tools/schema_diff/tests/pg/10_plus/target.sql | 106 ++++++++++++++++ .../tools/schema_diff/tests/pg/11_plus/source.sql | 104 ++++++++++++++++ .../tools/schema_diff/tests/pg/11_plus/target.sql | 106 ++++++++++++++++ .../tools/schema_diff/tests/pg/12_plus/source.sql | 104 ++++++++++++++++ .../tools/schema_diff/tests/pg/12_plus/target.sql | 106 ++++++++++++++++ .../tools/schema_diff/tests/pg/9.2_plus/source.sql | 104 ++++++++++++++++ .../tools/schema_diff/tests/pg/9.2_plus/target.sql | 106 ++++++++++++++++ .../schema_diff/tests/ppas/10_plus/source.sql | 110 ++++++++++++++++- .../schema_diff/tests/ppas/10_plus/target.sql | 110 ++++++++++++++++- .../schema_diff/tests/ppas/9.2_plus/source.sql | 106 +++++++++++++++- .../schema_diff/tests/ppas/9.2_plus/target.sql | 108 +++++++++++++++- 22 files changed, 1510 insertions(+), 31 deletions(-)
