Typecast the object to 'text' before using it in length() function, so that correct length function gets called.
Branch ------ master Details ------- https://git.postgresql.org/gitweb?p=pgadmin4.git;a=commitdiff;h=a0940fd1456fa4962c4e35972d188b456d3e4a6a Modified Files -------------- .../templates/catalog_object_column/sql/default/properties.sql | 2 +- .../templates/collations/sql/default/get_collations.sql | 4 ++-- .../domains/templates/domains/sql/9.2_plus/get_collations.sql | 2 +- .../schemas/domains/templates/domains/sql/9.2_plus/properties.sql | 2 +- .../domains/templates/domains/sql/default/get_collations.sql | 2 +- .../schemas/domains/templates/domains/sql/default/properties.sql | 2 +- .../templates/foreign_tables/sql/9.2_plus/get_collations.sql | 2 +- .../templates/foreign_tables/sql/9.2_plus/get_columns.sql | 2 +- .../templates/foreign_tables/sql/9.5_plus/get_columns.sql | 2 +- .../templates/foreign_tables/sql/default/get_collations.sql | 2 +- .../templates/fts_configurations/sql/default/properties.sql | 2 +- .../schemas/tables/templates/columns/sql/10_plus/properties.sql | 2 +- .../schemas/tables/templates/columns/sql/12_plus/properties.sql | 2 +- .../schemas/tables/templates/columns/sql/9.1_plus/properties.sql | 2 +- .../tables/templates/columns/sql/9.2_plus/get_collations.sql | 4 ++-- .../schemas/tables/templates/columns/sql/9.2_plus/properties.sql | 2 +- .../tables/templates/columns/sql/default/get_collations.sql | 4 ++-- .../templates/exclusion_constraint/sql/11_plus/properties.sql | 2 +- .../templates/exclusion_constraint/sql/default/properties.sql | 2 +- .../tables/templates/index_constraint/sql/11_plus/properties.sql | 2 +- .../tables/templates/index_constraint/sql/default/properties.sql | 2 +- .../tables/templates/indexes/sql/11_plus/column_details.sql | 2 +- .../tables/templates/indexes/sql/default/column_details.sql | 2 +- .../tables/templates/indexes/sql/default/get_collations.sql | 4 ++-- .../schemas/tables/templates/indexes/sql/default/properties.sql | 4 ++-- .../tables/templates/partitions/sql/gpdb/5_plus/properties.sql | 2 +- .../tables/templates/partitions/sql/pg/10_plus/properties.sql | 2 +- .../tables/templates/partitions/sql/pg/12_plus/properties.sql | 2 +- .../tables/templates/partitions/sql/ppas/10_plus/properties.sql | 2 +- .../tables/templates/partitions/sql/ppas/12_plus/properties.sql | 2 +- .../schemas/tables/templates/tables/sql/10_plus/properties.sql | 2 +- .../schemas/tables/templates/tables/sql/11_plus/properties.sql | 2 +- .../schemas/tables/templates/tables/sql/12_plus/properties.sql | 2 +- .../schemas/tables/templates/tables/sql/9.1_plus/properties.sql | 2 +- .../schemas/tables/templates/tables/sql/9.6_plus/properties.sql | 2 +- .../schemas/tables/templates/tables/sql/default/properties.sql | 2 +- .../tables/templates/tables/sql/gpdb_5.0_plus/properties.sql | 2 +- .../schemas/types/templates/types/sql/default/get_collations.sql | 4 ++-- .../types/templates/types/sql/default/get_external_functions.sql | 8 ++++---- .../schemas/types/templates/types/sql/default/get_subtypes.sql | 6 +++--- .../schemas/views/templates/mviews/pg/9.3_plus/sql/properties.sql | 2 +- .../schemas/views/templates/mviews/pg/9.4_plus/sql/properties.sql | 2 +- .../views/templates/mviews/ppas/9.3_plus/sql/properties.sql | 2 +- .../views/templates/views/gpdb_5.0_plus/sql/properties.sql | 2 +- .../schemas/views/templates/views/pg/9.1_plus/sql/properties.sql | 2 +- .../schemas/views/templates/views/pg/9.2_plus/sql/properties.sql | 2 +- .../schemas/views/templates/views/pg/9.3_plus/sql/properties.sql | 2 +- .../schemas/views/templates/views/pg/9.4_plus/sql/properties.sql | 2 +- .../views/templates/views/ppas/9.1_plus/sql/properties.sql | 2 +- .../views/templates/views/ppas/9.2_plus/sql/properties.sql | 2 +- .../views/templates/views/ppas/9.3_plus/sql/properties.sql | 2 +- .../views/templates/views/ppas/9.4_plus/sql/properties.sql | 2 +- 52 files changed, 63 insertions(+), 63 deletions(-)
