pgAdmin 4 commit: Improved performance while fetching edit types for ea

Akshay Joshi <[email protected]> Mon, 16 Dec 2019 13:20:38 +0000
Newsgroups gmane.comp.db.postgresql.pgadmin.devel
Message-ID <[email protected]>
Improved performance while fetching edit types for each column.

Edit types query is executed for every column when open properties dialog of the table.
Change the logic to fetch the edit types for all the distinct column types used in the table at once.

Branch
------
master

Details
-------
https://git.postgresql.org/gitweb?p=pgadmin4.git;a=commitdiff;h=ded71be73f219884fe3e4a21adc7aef8fb630764
Author: Aditya Toshniwal <[email protected]>

Modified Files
--------------
.../databases/schemas/tables/columns/__init__.py   |  5 ++-
.../databases/schemas/tables/columns/utils.py      | 37 ++++++++++++----------
.../columns/sql/default/edit_mode_types_multi.sql  | 13 ++++++++
.../columns/sql/default/is_referenced.sql          |  6 ----
4 files changed, 37 insertions(+), 24 deletions(-)