Ensure that trigger function SQL should have 'create or replace function' instead of 'create function' only. Fixes
#5849
Branch
------
master
Details
-------
https://git.postgresql.org/gitweb?p=pgadmin4.git;a=commitdiff;h=e39838455e14d9c688a910550f0953c2b9751789
Author: Aditya Toshniwal <aditya.toshniwal@enterprisedb.com>
Modified Files
--------------
docs/en_US/release_notes_5_7.rst | 1 +
.../functions/templates/trigger_functions/pg/sql/11_plus/create.sql | 2 +-
.../functions/templates/trigger_functions/pg/sql/9.2_plus/create.sql | 2 +-
.../functions/templates/trigger_functions/pg/sql/9.5_plus/create.sql | 2 +-
.../functions/templates/trigger_functions/pg/sql/default/create.sql | 2 +-
.../functions/templates/trigger_functions/ppas/sql/9.2_plus/create.sql | 2 +-
.../functions/templates/trigger_functions/ppas/sql/9.5_plus/create.sql | 2 +-
.../functions/templates/trigger_functions/ppas/sql/default/create.sql | 2 +-
.../schemas/functions/tests/pg/11_plus/alter_ptrig_comment.sql | 2 +-
.../databases/schemas/functions/tests/pg/11_plus/alter_ptrig_set_1.sql | 2 +-
.../databases/schemas/functions/tests/pg/11_plus/alter_ptrig_set_2.sql | 2 +-
.../databases/schemas/functions/tests/pg/11_plus/alter_ptrig_set_3.sql | 2 +-
.../schemas/functions/tests/pg/11_plus/create_event_trigger_full.sql | 2 +-
.../schemas/functions/tests/pg/11_plus/create_plain_trigger.sql | 2 +-
.../schemas/functions/tests/pg/11_plus/create_plain_trigger_full.sql | 2 +-
.../schemas/functions/tests/pg/12_plus/alter_ptrig_comment.sql | 2 +-
.../databases/schemas/functions/tests/pg/12_plus/alter_ptrig_set_1.sql | 2 +-
.../databases/schemas/functions/tests/pg/12_plus/alter_ptrig_set_2.sql | 2 +-
.../databases/schemas/functions/tests/pg/12_plus/alter_ptrig_set_3.sql | 2 +-
.../schemas/functions/tests/pg/12_plus/create_event_trigger_full.sql | 2 +-
.../schemas/functions/tests/pg/12_plus/create_plain_trigger.sql | 2 +-
.../schemas/functions/tests/pg/12_plus/create_plain_trigger_full.sql | 2 +-
.../schemas/functions/tests/pg/9.5_plus/alter_ptrig_comment.sql | 2 +-
.../databases/schemas/functions/tests/pg/9.5_plus/alter_ptrig_set_1.sql | 2 +-
.../databases/schemas/functions/tests/pg/9.5_plus/alter_ptrig_set_2.sql | 2 +-
.../databases/schemas/functions/tests/pg/9.5_plus/alter_ptrig_set_3.sql | 2 +-
.../schemas/functions/tests/pg/9.5_plus/create_event_trigger_full.sql | 2 +-
.../schemas/functions/tests/pg/9.5_plus/create_plain_trigger.sql | 2 +-
.../schemas/functions/tests/pg/9.5_plus/create_plain_trigger_full.sql | 2 +-
.../schemas/functions/tests/pg/9.6_plus/alter_ptrig_comment.sql | 2 +-
.../databases/schemas/functions/tests/pg/9.6_plus/alter_ptrig_set_1.sql | 2 +-
.../databases/schemas/functions/tests/pg/9.6_plus/alter_ptrig_set_2.sql | 2 +-
.../databases/schemas/functions/tests/pg/9.6_plus/alter_ptrig_set_3.sql | 2 +-
.../schemas/functions/tests/pg/9.6_plus/create_event_trigger_full.sql | 2 +-
.../schemas/functions/tests/pg/9.6_plus/create_plain_trigger.sql | 2 +-
.../schemas/functions/tests/pg/9.6_plus/create_plain_trigger_full.sql | 2 +-
.../schemas/functions/tests/pg/default/alter_ptrig_comment.sql | 2 +-
.../databases/schemas/functions/tests/pg/default/alter_ptrig_set_1.sql | 2 +-
.../databases/schemas/functions/tests/pg/default/alter_ptrig_set_2.sql | 2 +-
.../databases/schemas/functions/tests/pg/default/alter_ptrig_set_3.sql | 2 +-
.../schemas/functions/tests/pg/default/create_event_trigger_full.sql | 2 +-
.../schemas/functions/tests/pg/default/create_plain_trigger.sql | 2 +-
.../schemas/functions/tests/pg/default/create_plain_trigger_full.sql | 2 +-
.../schemas/functions/tests/ppas/11_plus/alter_ptrig_comment.sql | 2 +-
.../schemas/functions/tests/ppas/11_plus/alter_ptrig_set_1.sql | 2 +-
.../schemas/functions/tests/ppas/11_plus/alter_ptrig_set_2.sql | 2 +-
.../schemas/functions/tests/ppas/11_plus/alter_ptrig_set_3.sql | 2 +-
.../schemas/functions/tests/ppas/11_plus/create_event_trigger_full.sql | 2 +-
.../schemas/functions/tests/ppas/11_plus/create_plain_trigger.sql | 2 +-
.../schemas/functions/tests/ppas/11_plus/create_plain_trigger_full.sql | 2 +-
.../schemas/functions/tests/ppas/12_plus/alter_ptrig_comment.sql | 2 +-
.../schemas/functions/tests/ppas/12_plus/alter_ptrig_set_1.sql | 2 +-
.../schemas/functions/tests/ppas/12_plus/alter_ptrig_set_2.sql | 2 +-
.../schemas/functions/tests/ppas/12_plus/alter_ptrig_set_3.sql | 2 +-
.../schemas/functions/tests/ppas/12_plus/create_event_trigger_full.sql | 2 +-
.../schemas/functions/tests/ppas/12_plus/create_plain_trigger.sql | 2 +-
.../schemas/functions/tests/ppas/12_plus/create_plain_trigger_full.sql | 2 +-
.../schemas/functions/tests/ppas/9.6_plus/alter_ptrig_comment.sql | 2 +-
.../schemas/functions/tests/ppas/9.6_plus/alter_ptrig_set_1.sql | 2 +-
.../schemas/functions/tests/ppas/9.6_plus/alter_ptrig_set_2.sql | 2 +-
.../schemas/functions/tests/ppas/9.6_plus/alter_ptrig_set_3.sql | 2 +-
.../schemas/functions/tests/ppas/9.6_plus/create_event_trigger_full.sql | 2 +-
.../schemas/functions/tests/ppas/9.6_plus/create_plain_trigger.sql | 2 +-
.../schemas/functions/tests/ppas/9.6_plus/create_plain_trigger_full.sql | 2 +-
.../schemas/functions/tests/ppas/default/alter_ptrig_comment.sql | 2 +-
.../schemas/functions/tests/ppas/default/alter_ptrig_set_1.sql | 2 +-
.../schemas/functions/tests/ppas/default/alter_ptrig_set_2.sql | 2 +-
.../schemas/functions/tests/ppas/default/alter_ptrig_set_3.sql | 2 +-
.../schemas/functions/tests/ppas/default/create_event_trigger_full.sql | 2 +-
.../schemas/functions/tests/ppas/default/create_plain_trigger.sql | 2 +-
.../schemas/functions/tests/ppas/default/create_plain_trigger_full.sql | 2 +-
71 files changed, 71 insertions(+), 70 deletions(-)
