The search path should not be quoted while setting as a parameter, if it is
quoted then that string considers to be a single schema.
Quoting not added for the 'search_path' parameter.
Fixes #4760, #4780
Branch
------
master
Details
-------
https://git.postgresql.org/gitweb?p=pgadmin4.git;a=commitdiff;h=7489c372e5258691834d9a4f50c82f28c13426ab
Modified Files
--------------
docs/en_US/release_notes_4_14.rst | 4 +++-
.../functions/templates/functions/gpdb/sql/default/create.sql | 3 ++-
.../functions/templates/functions/gpdb/sql/default/update.sql | 3 ++-
.../functions/templates/functions/pg/sql/11_plus/create.sql | 3 ++-
.../functions/templates/functions/pg/sql/11_plus/update.sql | 3 ++-
.../functions/templates/functions/pg/sql/12_plus/create.sql | 3 ++-
.../functions/templates/functions/pg/sql/12_plus/update.sql | 3 ++-
.../functions/templates/functions/pg/sql/9.2_plus/create.sql | 3 ++-
.../functions/templates/functions/pg/sql/9.2_plus/update.sql | 3 ++-
.../functions/templates/functions/pg/sql/9.5_plus/create.sql | 3 ++-
.../functions/templates/functions/pg/sql/9.5_plus/update.sql | 3 ++-
.../functions/templates/functions/pg/sql/9.6_plus/create.sql | 3 ++-
.../functions/templates/functions/pg/sql/9.6_plus/update.sql | 3 ++-
.../functions/templates/functions/pg/sql/default/create.sql | 3 ++-
.../functions/templates/functions/pg/sql/default/update.sql | 3 ++-
.../functions/templates/functions/ppas/sql/12_plus/create.sql | 3 ++-
.../functions/templates/functions/ppas/sql/12_plus/update.sql | 3 ++-
.../functions/templates/functions/ppas/sql/9.2_plus/create.sql | 3 ++-
.../functions/templates/functions/ppas/sql/9.2_plus/update.sql | 3 ++-
.../functions/templates/functions/ppas/sql/9.5_plus/create.sql | 3 ++-
.../functions/templates/functions/ppas/sql/9.5_plus/update.sql | 3 ++-
.../functions/templates/functions/ppas/sql/9.6_plus/create.sql | 3 ++-
.../functions/templates/functions/ppas/sql/9.6_plus/update.sql | 3 ++-
.../functions/templates/functions/ppas/sql/default/create.sql | 3 ++-
.../functions/templates/functions/ppas/sql/default/update.sql | 3 ++-
.../functions/templates/procedures/pg/sql/11_plus/create.sql | 3 ++-
.../functions/templates/procedures/pg/sql/11_plus/update.sql | 3 ++-
.../functions/templates/procedures/ppas/sql/11_plus/create.sql | 3 ++-
.../functions/templates/procedures/ppas/sql/11_plus/update.sql | 3 ++-
.../functions/templates/procedures/ppas/sql/9.5_plus/create.sql | 3 ++-
.../functions/templates/procedures/ppas/sql/9.5_plus/update.sql | 3 ++-
.../functions/templates/procedures/ppas/sql/9.6_plus/create.sql | 3 ++-
.../functions/templates/procedures/ppas/sql/9.6_plus/update.sql | 3 ++-
.../templates/trigger_functions/pg/sql/11_plus/create.sql | 3 ++-
.../templates/trigger_functions/pg/sql/11_plus/update.sql | 3 ++-
.../templates/trigger_functions/pg/sql/9.2_plus/create.sql | 3 ++-
.../templates/trigger_functions/pg/sql/9.2_plus/update.sql | 3 ++-
.../templates/trigger_functions/pg/sql/9.5_plus/create.sql | 3 ++-
.../templates/trigger_functions/pg/sql/9.5_plus/update.sql | 3 ++-
.../templates/trigger_functions/pg/sql/default/create.sql | 3 ++-
.../templates/trigger_functions/pg/sql/default/update.sql | 3 ++-
.../templates/trigger_functions/ppas/sql/9.2_plus/create.sql | 3 ++-
.../templates/trigger_functions/ppas/sql/9.2_plus/update.sql | 3 ++-
.../templates/trigger_functions/ppas/sql/9.5_plus/create.sql | 3 ++-
.../templates/trigger_functions/ppas/sql/9.5_plus/update.sql | 3 ++-
.../templates/trigger_functions/ppas/sql/default/create.sql | 3 ++-
.../templates/trigger_functions/ppas/sql/default/update.sql | 3 ++-
.../schemas/functions/tests/pg/default/alter_ptrig_set_2.sql | 1 +
.../schemas/functions/tests/pg/default/alter_ptrig_set_3.sql | 1 +
.../functions/tests/pg/default/create_plain_trigger_full.sql | 1 +
.../functions/tests/pg/default/test_trigger_functions.json | 9 +++++++++
.../schemas/functions/tests/ppas/default/alter_ptrig_set_2.sql | 1 +
.../schemas/functions/tests/ppas/default/alter_ptrig_set_3.sql | 1 +
.../functions/tests/ppas/default/create_plain_trigger_full.sql | 1 +
.../functions/tests/ppas/default/test_trigger_functions.json | 9 +++++++++
.../databases/schemas/functions/tests/test_function_add.py | 5 ++++-
.../databases/schemas/functions/tests/test_procedure_add.py | 3 +++
.../databases/schemas/functions/tests/test_trigger_func_add.py | 3 +++
.../server_groups/servers/templates/macros/variable.macros | 3 ++-
59 files changed, 131 insertions(+), 49 deletions(-)