pgAdmin 4 commit: The following are the initial fixes for PG15: - Mailing list pgadmin-hackers

The following are the initial fixes for PG15:

 1) From PG 15 onward, the datlastsysoid has been removed from the table pg_database.
    We have added the constant _DATABASE_LAST_SYSTEM_OID = 16383, all the objects below
    this value are considered to be system objects. Modified the pgAdmin logic accordingly.

 2) Concatenation operator '||' needs a specific typecast to be applied to query variables. Modified SQL's accordingly.

Fixes #7283

Branch
------
master

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

Modified Files
--------------
docs/en_US/release_notes_6_10.rst                  |  1 +
.../server_groups/servers/databases/__init__.py    | 22 ++++------
.../servers/databases/casts/__init__.py            | 21 +++-------
.../servers/databases/event_triggers/__init__.py   |  7 +---
.../servers/databases/extensions/__init__.py       |  8 +---
.../databases/foreign_data_wrappers/__init__.py    |  8 +---
.../foreign_servers/__init__.py                    |  8 +---
.../foreign_servers/user_mappings/__init__.py      |  8 +---
.../servers/databases/languages/__init__.py        |  8 +---
.../servers/databases/publications/__init__.py     |  4 --
.../servers/databases/schemas/__init__.py          |  8 +---
.../databases/schemas/aggregates/__init__.py       | 10 ++---
.../databases/schemas/catalog_objects/__init__.py  |  8 +---
.../schemas/catalog_objects/columns/__init__.py    |  7 +---
.../databases/schemas/collations/__init__.py       | 10 ++---
.../servers/databases/schemas/domains/__init__.py  |  7 +---
.../schemas/domains/domain_constraints/__init__.py |  8 +---
.../databases/schemas/foreign_tables/__init__.py   |  8 +---
.../schemas/fts_configurations/__init__.py         | 12 ++----
.../databases/schemas/fts_dictionaries/__init__.py |  8 +---
.../databases/schemas/fts_parsers/__init__.py      |  8 +---
.../databases/schemas/fts_templates/__init__.py    |  8 +---
.../databases/schemas/functions/__init__.py        |  4 +-
.../databases/schemas/operators/__init__.py        | 10 ++---
.../databases/schemas/sequences/__init__.py        |  7 +---
.../servers/databases/schemas/synonyms/__init__.py |  6 +--
.../servers/databases/schemas/tables/__init__.py   | 20 ++++-----
.../schemas/tables/compound_triggers/__init__.py   | 48 ++++++++--------------
.../constraints/check_constraint/__init__.py       |  8 +---
.../constraints/exclusion_constraint/__init__.py   |  8 +---
.../tables/constraints/foreign_key/__init__.py     |  8 +---
.../constraints/index_constraint/__init__.py       |  8 +---
.../databases/schemas/tables/indexes/__init__.py   | 24 +++++------
.../schemas/tables/partitions/__init__.py          | 25 ++++++-----
.../tables/row_security_policies/__init__.py       | 12 +++---
.../databases/schemas/tables/rules/__init__.py     |  6 +--
.../tables/tests/test_tables_properties_sql.py     |  7 ++--
.../databases/schemas/tables/triggers/__init__.py  | 31 ++++++--------
.../servers/databases/schemas/tables/utils.py      | 18 ++++----
.../templates/schemas/pg/9.2_plus/sql/defacl.sql   |  2 +-
.../templates/schemas/pg/default/sql/defacl.sql    |  2 +-
.../templates/schemas/ppas/9.1_plus/sql/defacl.sql |  2 +-
.../templates/schemas/ppas/9.2_plus/sql/defacl.sql |  2 +-
.../servers/databases/schemas/types/__init__.py    | 22 ++++------
.../servers/databases/schemas/views/__init__.py    | 33 ++++++---------
.../servers/databases/subscriptions/__init__.py    |  4 --
.../databases/sql/9.1_plus/properties.sql          |  2 +-
.../databases/sql/9.2_plus/properties.sql          |  2 +-
.../templates/databases/sql/default/nodes.sql      |  2 +-
.../templates/databases/sql/default/properties.sql |  2 +-
.../server_groups/servers/databases/utils.py       |  6 +--
.../servers/resource_groups/__init__.py            |  8 +---
.../server_groups/servers/roles/__init__.py        |  9 ++--
.../templates/roles/sql/9.1_plus/dependents.sql    |  4 +-
.../templates/roles/sql/9.4_plus/dependents.sql    |  4 +-
.../server_groups/servers/tablespaces/__init__.py  |  7 +---
.../templates/depends/pg/11_plus/dependencies.sql  |  6 +--
.../templates/depends/pg/11_plus/dependents.sql    |  4 +-
.../templates/depends/pg/12_plus/dependencies.sql  |  6 +--
.../templates/depends/pg/12_plus/dependents.sql    |  4 +-
.../templates/depends/pg/9.1_plus/dependencies.sql |  6 +--
.../templates/depends/pg/9.1_plus/dependents.sql   |  4 +-
.../templates/depends/pg/9.3_plus/dependencies.sql |  6 +--
.../templates/depends/pg/9.3_plus/dependents.sql   |  4 +-
.../templates/depends/pg/9.5_plus/dependencies.sql |  6 +--
.../templates/depends/pg/9.5_plus/dependents.sql   |  4 +-
.../depends/ppas/11_plus/dependencies.sql          |  6 +--
.../templates/depends/ppas/11_plus/dependents.sql  |  4 +-
.../depends/ppas/12_plus/dependencies.sql          |  6 +--
.../templates/depends/ppas/12_plus/dependents.sql  |  4 +-
.../depends/ppas/9.1_plus/dependencies.sql         |  6 +--
.../templates/depends/ppas/9.1_plus/dependents.sql |  4 +-
.../depends/ppas/9.3_plus/dependencies.sql         |  6 +--
.../templates/depends/ppas/9.3_plus/dependents.sql |  4 +-
.../depends/ppas/9.5_plus/dependencies.sql         |  6 +--
.../templates/depends/ppas/9.5_plus/dependents.sql |  4 +-
web/pgadmin/browser/utils.py                       |  2 +
web/pgadmin/tools/search_objects/utils.py          |  5 +--
web/pgadmin/utils/constants.py                     |  1 +
web/pgadmin/utils/driver/psycopg2/connection.py    |  2 +-
.../utils/driver/psycopg2/server_manager.py        |  2 +-
81 files changed, 247 insertions(+), 425 deletions(-)