From: | Akshay Joshi <akshay(dot)joshi(at)enterprisedb(dot)com> |
---|---|
To: | pgadmin-hackers(at)lists(dot)postgresql(dot)org |
Subject: | pgAdmin 4 commit: The following are the initial fixes for PG15: |
Date: | 2022-05-17 15:05:02 |
Message-ID: | E1nqykw-0003K4-7p@gothos.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(-)
From | Date | Subject | |
---|---|---|---|
Next Message | Aditya Toshniwal | 2022-05-18 06:01:23 | [pgAdmin][RM7393] Do not change position of editor once opened |
Previous Message | Akshay Joshi | 2022-05-17 13:38:11 | Re: [pgAdmin][RM7388] Error message will fill the entire window if the query is long |