pgAdmin 4 commit: Ensure that trigger function SQL should have 'create

From: Akshay Joshi <akshay(dot)joshi(at)enterprisedb(dot)com>
To: pgadmin-hackers(at)lists(dot)postgresql(dot)org
Subject: pgAdmin 4 commit: Ensure that trigger function SQL should have 'create
Date: 2021-08-24 12:53:38
Message-ID: E1mIVvu-0002nr-Pf@gothos.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-hackers

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(dot)toshniwal(at)enterprisedb(dot)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(-)

Browse pgadmin-hackers by date

  From Date Subject
Next Message Akshay Joshi 2021-08-24 12:54:13 Re: [pgAdmin][RM6495] ERD 1:M relationship - allow the referenced table to be the same as the local table.
Previous Message Aditya Toshniwal 2021-08-24 12:00:58 [pgAdmin][RM5849] "create or replace" for trigger functions