pgAdmin 4 commit: Fixed and improve API test cases for the schema diff

Fixed and improve API test cases for the schema diff tool. Fixes #5417

Branch
------
master

Details
-------
https://git.postgresql.org/gitweb?p=pgadmin4.git;a=commitdiff;h=55b5080c77740f0d3c686a523c49e5baf8302274

Modified Files
--------------
docs/en_US/release_notes.rst | 1 +
docs/en_US/release_notes_4_27.rst | 20 +
.../servers/databases/event_triggers/__init__.py | 2 +-
.../tests/event_triggers_test_data.json | 2 +-
.../foreign_servers/sql/default/update.sql | 12 +-
.../foreign_data_wrappers/sql/9.3_plus/update.sql | 3 +-
.../servers/databases/languages/__init__.py | 25 +-
web/pgadmin/tools/schema_diff/directory_compare.py | 14 +
.../tools/schema_diff/tests/pg/10_plus/source.sql | 677 ++++++++++++------
.../tools/schema_diff/tests/pg/10_plus/target.sql | 625 +++++++++++-----
.../tools/schema_diff/tests/pg/11_plus/source.sql | 677 ++++++++++++------
.../tools/schema_diff/tests/pg/11_plus/target.sql | 627 +++++++++++-----
.../tools/schema_diff/tests/pg/12_plus/source.sql | 687 ++++++++++++------
.../tools/schema_diff/tests/pg/12_plus/target.sql | 633 +++++++++++------
.../tools/schema_diff/tests/pg/9.2_plus/source.sql | 682 +++++++++++++-----
.../tools/schema_diff/tests/pg/9.2_plus/target.sql | 661 ++++++++++++-----
.../schema_diff/tests/ppas/10_plus/source.sql | 784 ++++++++++++++-------
.../schema_diff/tests/ppas/10_plus/target.sql | 738 +++++++++++++------
.../schema_diff/tests/ppas/9.2_plus/source.sql | 744 +++++++++++++------
.../schema_diff/tests/ppas/9.2_plus/target.sql | 725 +++++++++++++------
.../schema_diff/tests/test_schema_diff_comp.py | 57 +-
web/pgadmin/tools/schema_diff/tests/utils.py | 68 +-
22 files changed, 5896 insertions(+), 2568 deletions(-)